cvs: phpdoc /ja/chapters install.xml /ja/functions math.xml mhash.xml sesam.xml
| From: | Rui Hirokawa | Date: | Wed, 20 Dec 2000 10:01:00 +0000 |
| Subject: | cvs: phpdoc /ja/chapters install.xml /ja/functions math.xml mhash.xml sesam.xml | ||
| Groups: | php.doc | ||
| Request: | Send a blank email to phpdoc+get-969333338@lists.php.net to get a copy of this message | ||
hirokawa Wed Dec 20 02:01:00 2000 EDT
Modified files:
/phpdoc/ja/chapters install.xml
/phpdoc/ja/functions math.xml mhash.xml sesam.xml
Log:
update translation.
Index: phpdoc/ja/chapters/install.xml diff -u phpdoc/ja/chapters/install.xml:1.17 phpdoc/ja/chapters/install.xml:1.18 --- phpdoc/ja/chapters/install.xml:1.17 Sun Nov 19 15:00:22 2000 +++ phpdoc/ja/chapters/install.xml Wed Dec 20 02:00:59 2000 @@ -2726,7 +2726,7 @@ ãã¨ãã§ãã¾ãã </simpara> <para> - ãã®ã¬ã¤ãã¯ã以ä¸ã®Webãã¼ãã¼ã¸ã®ã¤ã³ã¹ãã¼ã«ã + ãã®ã¬ã¤ãã¯ã以ä¸ã®Webã£Ã¼ãã¼ã¸ã®ã¤ã³ã¹ãã¼ã«ã ãµãã¼ããã¦ãã¾ãã <itemizedlist> <listitem> @@ -2763,28 +2763,32 @@ <listitem> <para> é å¸ãã¡ã¤ã«ã好ããªãã£ã¬ã¯ããªã«å±éãã¦ä¸ããã - "C:\PHP\" ããè¯ãä¾ã§ãã + "C:\PHP\" ããè¯ãä¾ã§ãã </para> </listitem> <listitem> <para> - 'php.ini-dist' ã '%WINDOWS%' ãã£ã¬ã¯ããªã«ã³ãã¼ãã - 'php.ini' ã«ãªãã¼ã ãã¦ä¸ããã - '%WINDOWS%' ãã£ã¬ã¯ããªã¯ãéå¸¸ãæ¬¡ã®ããã«ãªãã¾ãã + 'php.ini-dist' ã Windows 95/98ã®å ´åã¯ã + '%WINDOWS%' ãã£ã¬ã¯ããªãWindows NT ã¾ã㯠Windows + 2000ã®å ´åã¯ã'%SYSTEMROOT%'ãã£ã¬ã¯ããªã³ãã¼ãã + 'php.ini' ã«ãªãã¼ã ãã¦ä¸ããã + '%WINDOWS%' ã¾ã㯠'%SYSTEMROOT%'ãã£ã¬ã¯ + ããªã¯ãéå¸¸ãæ¬¡ã®ããã«ãªãã¾ãã <simplelist> <member>Windows 95/98 ã§ã¯ãc:\windows</member> - <member>NT ãµã¼ãã¼ã§ã¯ãc:\winnt ~ã㯠c:\winnt40</member> + <member>NT\2000 ãµã¼ãã¼ã§ã¯ãc:\winnt ã¾ã㯠c:\winnt40</member> </simplelist> </para> </listitem> <listitem> <para> - 'php.ini' ãã¡ã¤ã«ãç·¨éãã¦ä¸ããã + 'php.ini' ãã¡ã¤ã«ãç·¨éãã¦ä¸ããã <itemizedlist> <listitem> <simpara> - 'extension_dir' ã®è¨å®å¤ã php-install-dir ã¾ã㯠'php_*.dll' ã - ç½®ããå ´æã«å¤æ´ããå¿ è¦ãããã¾ããä¾ãã°ãc:\php ã«ãªãã¾ãã + 'extension_dir' ã®è¨å®å¤ã php-install-dir ã¾ã㯠+ 'php_*.dll' ãç½®ããå ´æã«å¤æ´ããå¿ è¦ãããã¾ãã + ä¾ãã°ãc:\php ã«ãªãã¾ãã </simpara> </listitem> <listitem> @@ -3187,7 +3191,7 @@ è¨å®ããWeb ãµã¼ãã¼ã§PHPã使ç¨ããããã«è¨å®ããã«å¿ è¦ãªæ å ±ãé ãã¾ããIIS 㨠NTã¯ã¼ã¯ã¹ãã¼ã·ã§ã³ã«ããã PWS ã®å ´åãã¹ã¯ãªã ããããè¨å®ãæãããµã¼ãã¼ã®å ¨ãã¼ãã®ãªã¹ãã表示ãããPHPã¹ã¯ - ãªããç¨ãããã³ã°è¿½å ãããã¨æãå ´æã®ãã¼ãã鏿ãããã¨ã + ãªããç¨ãããã³ã°?追å ãããã¨æãå ´æã®ãã¼ãã鏿ãããã¨ã å¯è½ã§ãã </simpara> Index: phpdoc/ja/functions/math.xml diff -u phpdoc/ja/functions/math.xml:1.13 phpdoc/ja/functions/math.xml:1.14 --- phpdoc/ja/functions/math.xml:1.13 Mon Dec 11 13:42:13 2000 +++ phpdoc/ja/functions/math.xml Wed Dec 20 02:00:59 2000 @@ -552,7 +552,7 @@ </funcsynopsis> <para> 弿° hex_string ã«ããæå®ããã 16鲿°ã«ç価㪠10 鲿°ãè¿ãã¾ãã - HexDec 㯠16 鲿°ã表ãæååã 10 鲿°ã«å¤æãã¾ãã + HexDec 㯠16 鲿°ã表ãæååã 10 鲿°ã«å¤æãã¾ãã 夿ã§ããæå¤§ã®æ°åã¯16鲿°ã® 7fffffff ããã㯠10 鲿°ã® 2147483647 ã§ãã </para> @@ -1021,10 +1021,12 @@ </informalexample> </para> <note> - <para> + <simpara> + ãã©ã¡ã¼ã¿ <parameter>precision</parameter> ã¯ãPHP 4ã§ã®ã¿å©ç¨ + å¯è½ã§ãã (訳注ï¼å é¨çãª2鲿°è¡¨ç¾ã¨10鲿°è¡¨ç¾ã®å·®ã«ããçãã丸ã誤差ã®å½±é¿ã«ãã å¿ ãããå°æ°ç¹ä»¥ä¸ã忍äºå ¥ããçµæãè¿ããªããã¨ã«æ³¨æãã¦ä¸ããã) - </para> + </simpara> </note> <simpara> <function>ceil</function> 㨠Index: phpdoc/ja/functions/mhash.xml diff -u phpdoc/ja/functions/mhash.xml:1.5 phpdoc/ja/functions/mhash.xml:1.6 --- phpdoc/ja/functions/mhash.xml:1.5 Thu Oct 26 15:19:21 2000 +++ phpdoc/ja/functions/mhash.xml Wed Dec 20 02:00:59 2000 @@ -241,7 +241,7 @@ ãè¿ããã¾ããHMACã¯ãã¡ãã»ã¼ã¸èªè¨¼æã¯ãã¼ã«åºã¥ãããã·ã¥ãã¾ã ã¯æå®ãããã¼ã«åºã¥ãåãªãã¡ãã»ã¼ã¸ãã¤ã¸ã§ã¹ãã§ããmhashã§ãµ ãã¼ãããã¦ããå ¨ã¦ã®ã¢ã«ã´ãªãºã ãHMACã¢ã¼ãã§ä½¿ç¨ã§ããããã§ - ã¯ãªãããµãã¼ãããã¦ããªãå ´åã¯ã¨ã©ã¼ãè¿ãã¾ãã + ã¯ããã¾ãããã¨ã©ã¼ã®å ´åã¯ã¨ã©ã¼ãè¿ããã¾ãã </para> </refsect1> </refentry> Index: phpdoc/ja/functions/sesam.xml diff -u phpdoc/ja/functions/sesam.xml:1.3 phpdoc/ja/functions/sesam.xml:1.4 --- phpdoc/ja/functions/sesam.xml:1.3 Sat Dec 16 19:34:25 2000 +++ phpdoc/ja/functions/sesam.xml Wed Dec 20 02:00:59 2000 @@ -364,14 +364,13 @@ <listitem> <simpara><command>DROP TABLE thename;</command></simpara> <simpara> - SESAMã§ã¯ãin the <command>DROP TABLE</command> - command, the table name must be either followed by - the keyword <literal>RESTRICT</literal> or - <literal>CASCADE</literal>. When specifying - <literal>RESTRICT</literal>, an error is returned if - there are dependent objects (e.g., VIEWs), while with - <literal>CASCADE</literal>, dependent objects will be - deleted along with the specified table. + SESAMã§ã¯ã<command>DROP TABLE</command> ã«ããã¦ãã¼ãã«åã® + å¾ã«ãã¼ãÃÉ <literal>RESTRICT</literal> ã¾ã㯠+ <literal>CASCADE</literal> ã®ã©ã¡ãããå¾ã«ä»å ããå¿ è¦ããã + ã¾ãã<literal>RESTRICT</literal> ãæå®ããå ´åã(VIEWã®ãã + ãª)ä¾åãããªãã¸ã§ã¯ããããå ´åã«ã¨ã©ã¼ãè¿ããã¾ããã¾ãã + <literal>CASCADE</literal> ãæå®ããå ´åãä¾åãããªãã¸ã§ã¯ + ãã¯æå®ãããã¼ãã«ããåé¤ããã¾ãã </simpara> </listitem> </itemizedlist> @@ -379,22 +378,22 @@ </note> <note> <title> - Notes on the use of various SQL types + æ§ã ãªSQLåã使ç¨ããå ´åã®æ³¨æ </title> <para> - SESAM does not currently support the BLOB type. A future - version of SESAM will have support for BLOB. + SESAM ã¯ç¾å¨BLOBåããµãã¼ããã¦ãã¾ãããSESAMã®å°æ¥ã®ãã¼ã¸ã§ã³ + ã¯ãBLOBããµãã¼ãããäºå®ã§ãã </para> <para> - At the PHP interface, the following type conversions are - automatically applied when retrieving SQL fields: + PHP ã¤ã³ã¿ã¼ãã§ã¼ã¹ã§ã¯ãSQLãã£ã¼ã«ããåå¾ããéã«æ¬¡ã®å夿ã + èªåçã«é©ç¨ããã¾ãã <table> - <title>SQL to PHP Type Conversions</title> + <title>SQL ãã PHP ã¸ã®å夿</title> <tgroup cols="2"> <thead> <row> - <entry>SQL Type</entry> - <entry>PHP Type</entry> + <entry>SQL å</entry> + <entry>PHP å</entry> </row> </thead> <tbody> @@ -417,24 +416,23 @@ </tbody> </tgroup> </table> - When retrieving a complete row, the result is returned as an - array. Empty fields are not filled in, so you will have to - check for the existence of the individual fields yourself - (use <function>isset</function> or - <function>empty</function> to test for empty fields). - That allows more user control over the appearance of empty - fields (than in the case of an empty string as the - representation of an empty field). + ã¬ã³ã¼ãå ¨ä½ãåå¾ããéãçµæã¯é åã¨ãã¦è¿ããã¾ãã空ã®ãã£ã¼ + ã«ãã«ã¯å¤ãå ¥ã£ã¦ããªããããåã ã®ãã£ã¼ã«ãèªä½ã®åå¨ã調ã¹ã + å¿ è¦ãããã¾ã(空ã®ãã£ã¼ã«ããã©ãã調ã¹ãã«ã¯ã + <function>isset</function> ã¾ã㯠<function>empty</function> ã使 + ç¨ãã¦ä¸ãã) ããã®ææ³ã¯ã(空ã®ãã£ã¼ã«ãã®è¡¨ç¾ã¨ãã¦åã®æåå + ã使ç¨ããããã)空ã®ãã£ã¼ã«ãã®è¦ãæ¹ãã¦ã¼ã¶ãå¶å¾¡ãããã¨ãå¯ + è½ã¨ãªãã¾ãã </para> </note> <note> - <title>Support of SESAM's "multiple fields" feature</title> + <title>SESAM ã® "è¤æ°ãã£ã¼ã«ã" æ©è½ã®ãµãã¼ã</title> <para> - The special "multiple fields" feature of SESAM allows a column to - consist of an array of fields. Such a "multiple field" column can - be created like this: + SESAMç¹æã®"è¤æ°ãã£ã¼ã«ã"æ©è½ã«ããè¤æ°ã®ãã£ã¼ã«ãã®é åãã㪠+ ãã«ã©ã ã使ç¨ãããã¨ãå¯è½ã§ãã"è¤æ°ãã£ã¼ã«ã"ã«ã©ã äºã¯ã次 + ã®ããã«ä½æå¯è½ã§ãã <example> - <title>Creating a "multiple field" column</title> + <title>"è¤æ°ãã£ã¼ã«ã"ã«ã©ã ã使ãã</title> <programlisting role="sesam"> CREATE TABLE multi_field_test ( @@ -443,32 +441,30 @@ ) </programlisting> </example> - and can be filled in using: + ä¸ã®ã¬ã³ã¼ãã«æ¬¡ã®ããã«ä»£å ¥ãããã¨ãã§ãã¾ãã <example> - <title>Filling a "multiple field" column</title> + <title>"è¤æ°ãã£ã¼ã«ã"ã«ã©ã ã«ä»£å ¥ãã</title> <programlisting role="sesam"> INSERT INTO multi_field_test ( pkey, multi(2..3) ) VALUES ( 'Second', <'first_val','second_val'>) </programlisting> </example> - Note that (like in this case) leading empty sub-fields are ignored, - and the filled-in values are collapsed, so that in the above - example the result will appear as multi(1..2) instead of - multi(2..3). + (ãã®å ´åã®ããã«)å é ã®ç©ºã®ãµããã£ã¼ã«ãã¯ç¡è¦ãããä»£å ¥ããã + å¤ã¯è©°ãããããã¨ã«æ³¨æãã¦ä¸ããããã®ãããä¸è¨ã®ä¾ã®çµæã¯ã + multi(2..3) ã§ã¯ãªããmulti(1..2) ã¨ãªãã¾ãã </para> <para> - When retrieving a result row, "multiple columns" are accessed like - "inlined" additional columns. In the example above, "pkey" will have - the index 0, and the three "multi(1..3)" columns will be accessible - as indices 1 through 3. + çµæã¬ã³ã¼ããåå¾ããéã"è¤æ°ã«ã©ã "ã¯"ã¤ã³ã©ã¤ã³ã®"ä»å ã«ã©ã + ã®ããã«ã¢ã¯ã»ã¹ããã¾ããä¸ã®ã«ããã¦ã"pkey" ã¯æ·»å0ãæãã3㤠+ ã®"multi(1..3)" ã«ã©ã ã¯æ·»å1ãã3ã§ã¢ã¯ã»ã¹å¯è½ã§ãã </para> </note> <para> - For specific SESAM details, please refer to - <ulink url="&url.sesam.en;">the SESAM/SQL-Server - documentation (english)</ulink> or - <ulink url="&url.sesam.de;">the SESAM/SQL-Server documentation (german)</ulink>, - both available online, or use the respective manuals. + SESAMåºæã®äºé ã«ã¤ãã¦è©³ç´°ã¯ã<ulink url="&url.sesam.en;">the + SESAM/SQL-Serverããã¥ã¡ã³ã(è±èª)</ulink> ã¾ã㯠+ <ulink url="&url.sesam.de;">SESAM/SQL-Server ããã¥ã¡ã³ã(ãã¤ãèª) + </ulink> ãåç §ä¸ãããå ±ã«ãªã³ã©ã¤ã³ã§åç §å¯è½ã§ãããããã¯ãé© + å½ãªããã¥ã¢ã«ã使ç¨ãã¦ä¸ããã </para> </partintro> @@ -488,44 +484,43 @@ </funcprototype> </funcsynopsis> <para> - Returns <literal>TRUE</literal> if a connection to the SESAM database was made, or - <literal>FALSE</literal> on error. + SESAMãã¼ã¿ãã¼ã¹ã¸ã®æ¥ç¶ã使ãããå ´åã« + <literal>TRUE</literal>ãã¨ã©ã¼ã®å ´åã« <literal>FALSE</literal> + ãè¿ãã¾ãã </para> <para> - <function>sesam_connect</function> establishes a connection to an - SESAM database handler task. The connection is always - "persistant" in the sense that only the very first invocation will - actually load the driver from the configured SESAM OML PLAM - library. Subsequent calls will reuse the driver and will - immediately use the given catalog, schema, and user. + <function>sesam_connect</function> ã¯SESAMãã¼ã¿ãã¼ã¹ãã³ãã©ã¿ + ã¹ã¯ã¸ã®æ¥ç¶ã確ç«ãã¾ããæ¥ç¶ã¯ãæåã®èµ·åæã«ã®ã¿è¨å®ããã + SESAM OML PLAMã©ã¤ãã©ãªããå®éã«ãã©ã¤ãããã¼ããããã¨ããæ + å³ã§å¸¸ã«"æç¶ç"ã§ãããã®å¾ã®ã³ã¼ã«ã§ã¯ããã©ã¤ãã¯åå©ç¨ããã + æå®ãã«ã¿ãã°ãã¹ãã¼ããã¦ã¼ã¶ãç´ã¡ã«ä½¿ç¨ããã¾ãã </para> <para> - When creating a database, the <parameter>"catalog"</parameter> - name is specified in the - SESAM configuration directive <command>//ADD-SQL-DATABASE-CATALOG-LIST - ENTRY-1 = *CATALOG(CATALOG-NAME = catalogname,...)</command> + ãã¼ã¿ãã¼ã¹ã使ããéã<parameter>"catalog"</parameter> åã¯ã + SESAMè¨å®ãã£ã¬ã¯ãã£ã <command>//ADD-SQL-DATABASE-CATALOG-LIST + ENTRY-1 = *CATALOG(CATALOG-NAME = catalogname,...)</command> ã§æ + å®ãã¾ãã </para> <para> - The <parameter>"schema"</parameter> references the desired - database schema (see SESAM handbook). + <parameter>"schema"</parameter> ã«ã¯é¸æãããã¼ã¿ãã¼ã¹ã¹ãã¼ã + ãæå®ãã¾ãã(SESAMãã³ãããã¯ãåç §) </para> <para> - The <parameter>"user"</parameter> argument references one of the - users which are allowed to access this - <parameter>"catalog"</parameter> / <parameter>"schema"</parameter> - combination. Note that <parameter>"user"</parameter> is completely - independent from both the system's user id's and from HTTP - user/password protection. It appears in the SESAM configuration - only. + <parameter>"user"</parameter> 弿°ã«ã¯ããã® + <parameter>"catalog"</parameter> / + <parameter>"schema"</parameter> ã®çµã«ã¢ã¯ã»ã¹å¯è½ãªã¦ã¼ã¶ã®ä¸äºº + ãæå®ãã¾ãã<parameter>"user"</parameter>ã¯ãã·ã¹ãã ã®ã¦ã¼ã¶ID + ã¨HTTPã¦ã¼ã¶/ãã¹ã¯ã¼ãä¿è·ããå ±ã«å®å ¨ã«ç¬ç«ãã¦ããã¨ã«æ³¨æã㦠+ ä¸ãããSESAMè¨å®ã«ã®ã¿ä½¿ç¨ããã¾ãã </para> <para> - See also <function>sesam_disconnect</function>. + <function>sesam_disconnect</function>ãåç §ä¸ããã <example> - <title>Connect to a SESAM database</title> + <title>SESAM ãã¼ã¿ãã¼ã¹ã¸ã®æ¥ç¶</title> <programlisting role="php"> <?php if (! sesam_connect ("mycatalog", "myschema", "otto") - die("Unable to connect to SESAM"; + die("SESAMã«æ¥ç¶ã§ãã¾ãã"; ?> </programlisting> </example> @@ -547,34 +542,34 @@ </funcprototype> </funcsynopsis> <para> - Returns: always <literal>TRUE</literal>. + è¿ãå¤: 常㫠<literal>TRUE</literal>ã </para> <para> - <function>sesam_disconnect</function> closes the logical link to a - SESAM database (without actually disconnecting and unloading the - driver). + <function>sesam_disconnect</function> ã¯(å®éã«æ¥ç¶ãæã«ãããã + ãã©ã¤ããã¢ã³ãã¼ããããã¨ãªã)SESAMãã¼ã¿ãã¼ã¹ã¸ã®è«çãªã³ã¯ + ãéãã¾ãã </para> <para> - Note that this isn't usually necessary, as the open connection is - automatically closed at the end of the script's execution. - Uncommitted data will be discarded, because an implicit - <function>sesam_rollback</function> is executed. + ãªã¼ãã³ãããæ¥ç¶ã¯ã¹ã¯ãªããã®å®è¡çµäºæã«éããããããããã® + 颿°ã¯é常ä¸è¦ã§ããã³ãããããã¦ããªããã¼ã¿ã¯ãæé»ã®ãã¡ã« + <function>sesam_rollback</function> ãå®è¡ããããããç ´æ£ããã¾ + ãã </para> <para> - <function>sesam_disconnect</function> will not close the - persistent link, it will only invalidate the currently defined - <parameter>"catalog"</parameter>, <parameter>"schema"</parameter> - and <parameter>"user"</parameter> triple, so that any sesam - function called after <function>sesam_disconnect</function> will - fail. + <function>sesam_disconnect</function> ã¯ãæç¶çãªãªã³ã¯ãéããã + ç¾å¨ãå®ç¾©ããã¦ãã <parameter>"catalog"</parameter>ã + <parameter>"schema"</parameter>ã<parameter>"user"</parameter> ã® + çµãç¡å¹ã«ããã ãã§ãããã®ããã + <function>sesam_disconnect</function> ã®å¾ã§ã³ã¼ã«ããã SESAM é¢ + æ°ã¯å¤±æãã¾ãã </para> <para> - See also: <function>sesam_connect</function>. + <function>sesam_connect</function>ãåç §ä¸ããã <example> - <title>Closing a SESAM connection</title> + <title>SESAM æ¥ç¶ãéãã</title> <programlisting role="php"> if (sesam_connect ("mycatalog", "myschema", "otto")) { -... some queries and stuff ... +... ã¯ã¨ãªç ... sesam_disconnect(); } </programlisting> </example> @@ -597,35 +592,35 @@ </funcprototype> </funcsynopsis> <para> - Returns: <literal>TRUE</literal> if the values are valid, and the - <function>settransaction</function> operation was successful, - <literal>FALSE</literal> otherwise. + è¿ãå¤: <function>settransaction</function> å¦çãæåãã¦ã + æå¹ãªå ´åã« <literal>TRUE</literal>ããã®ä»ã®å ´åã« + <literal>FALSE</literal>ã </para> <para> - <function>sesam_settransaction</function> overrides the default - values for the "isolation level" and "read-only" transaction - parameters (which are set in the SESAM configuration file), in - order to optimize subsequent queries and guarantee database - consistency. The overridden values are used for the next transaction - only. + <function>sesam_settransaction</function> ã¯ã(SESAMè¨å®ãã¡ã¤ã« + ã§è¨å®ããã)ãã©ã³ã¶ã¯ã·ã§ã³ãã©ã¡ã¼ã¿ "isolation level" 㨠+ "read-only" ã®ããã©ã«ãå¤ã䏿¸ããã¾ããããã¯ãé£ç¶ããã¯ã¨ãª + ãæé©åãããã¼ã¿ãã¼ã¹ã®çµ±ä¸æ§ãä¿è¨¼ããããã§ãã䏿¸ãããã + å¤ã¯ã次ã®ãã©ã³ã¶ã¯ã·ã§ã³ã§ã®ã¿ä½¿ç¨ããã¾ãã </para> <para> - <function>sesam_settransaction</function> can only be called before - starting a transaction, not after the transaction has been started - already. + <function>sesam_settransaction</function> ã¯ããã©ã³ã¶ã¯ã·ã§ã³ã + éå§ããåã«ã®ã¿ã³ã¼ã«ãããã¨ãå¯è½ã§ãæ¢ã«ãã©ã³ã¶ã¯ã·ã§ã³ãé + å§ããã¦ããå ´åã«ã¯ãã³ã¼ã«ãããã¨ãã§ãã¾ããã </para> <para> - To simplify the use in php scripts, the following constants have - been predefined in php (see SESAM handbook for detailed - explanation of the semantics): + PHPã¹ã¯ãªããã®ä½¿ç¨ãç°¡åã«ããã«ã¯ã次ã®å®æ°ããPHPã§å®ç¾©ãã㦠+ ãã¾ãã(æå³ã®è©³ç´°ã«ã¤ãã¦ã¯SESAMãã³ãããã¯ãåç §) <table> - <title>Valid values for <parameter>"Isolation_Level"</parameter> parameter</title> + <title> + <parameter>"Isolation_Level"</parameter>ãã©ã¡ã¼ã¿ã®æå¹ãªå¤ + </title> <tgroup cols="3"> <thead> <row> - <entry>Value</entry> - <entry>Constant</entry> - <entry>Meaning</entry> + <entry>å¤</entry> + <entry>宿°</entry> + <entry>æå³</entry> </row> </thead> <tbody> @@ -653,13 +648,15 @@ </tgroup> </table> <table> - <title>Valid values for <parameter>"Read_Only"</parameter> parameter</title> + <title> + <parameter>"Read_Only"</parameter> ãã©ã¡ã¼ã¿ã®æå¹ãªå¤ + </title> <tgroup cols="3"> <thead> <row> - <entry>Value</entry> - <entry>Constant</entry> - <entry>Meaning</entry> + <entry>å¤</entry> + <entry>宿°</entry> + <entry>æå³</entry> </row> </thead> <tbody> @@ -678,13 +675,13 @@ </table> </para> <para> - The values set by <function>sesam_settransaction</function> will - override the default setting specified in the <link - linkend="ini.sesam-configfile">SESAM configuration file</link>. + <function>sesam_settransaction</function> ã«ããè¨å®ãããå¤ã¯ã + <link linkend="ini.sesam-configfile">SESAM è¨å®ãã¡ã¤ã«</link>ã§ + æå®ãããããã©ã«ãè¨å®ã䏿¸ããã¾ãã </para> <para> <example> - <title>Setting SESAM transaction parameters</title> + <title>SESAM ãã©ã³ã¶ã¯ã·ã§ã³ãã©ã¡ã¼ã¿ãè¨å®ãã</title> <programlisting role="php"> <?php sesam_settransaction(SESAM_TXISOL_REPEATABLE_READ, @@ -699,7 +696,9 @@ <refentry id="function.sesam-commit"> <refnamediv> <refname>sesam_commit</refname> - <refpurpose>SESAMãã¼ã¿ãã¼ã¹ã¸ã®å¾ æ©ä¸ã®æ´æ°å¦çãã³ããããã</refpurpose> + <refpurpose> + SESAMãã¼ã¿ãã¼ã¹ã¸ã®å¾ æ©ä¸ã®æ´æ°å¦çãã³ããããã + </refpurpose> </refnamediv> <refsect1> <title>説æ</title> @@ -718,20 +717,17 @@ ã¸ã®æ´æ°å¦çãã³ããããã¾ãã </para> <para> - ä»ã®ãã¼ã¿ãã¼ã¹ã®ããã«"èªåã³ããã"æ©è½ããªãããã - - Note that there is no "auto-commit" feature as in other databases, - as it could lead to accidental data loss. Uncommitted data at - the end of the current script (or when calling - <function>sesam_disconnect</function>) will be discarded by an - implied <function>sesam_rollback</function> call. + ä»ã®ãã¼ã¿ãã¼ã¹ã®ããã«"èªåã³ããã"æ©è½ããªããããäºæ ã«ãã + ãã¼ã¿ã失ãããå¯è½æ§ããããã¨ã«æ³¨æãã¦ä¸ãããã«ã¬ã³ãã®ã¹ã¯ + ãªããå®è¡çµäºæã«ã³ãããããã¦ããªããã¼ã¿ã¯ãæé»ã® + <function>sesam_rollback</function> ã³ã¼ã«ã«ããç ´æ£ããã¾ãã </para> <para> </para> <para> - See also: <function>sesam_rollback</function>. + <function>sesam_rollback</function>ãåç §ä¸ããã <example> - <title>Committing an update to the SESAM database</title> + <title>SESAM ãã¼ã¿ãã¼ã¹ã®æ´æ°ãã³ããããã</title> <programlisting role="php"> <?php if (sesam_connect ("mycatalog", "myschema", "otto")) { @@ -750,7 +746,9 @@ <refentry id="function.sesam-rollback"> <refnamediv> <refname>sesam_rollback</refname> - <refpurpose>Discard any pending updates to the SESAM database</refpurpose> + <refpurpose> + SESAMãã¼ã¿ãã¼ã¹ã«å¯¾ããå¾ æ©ä¸ã®æ´æ°ãç ´æ£ãã + </refpurpose> </refnamediv> <refsect1> <title>説æ</title> @@ -761,24 +759,22 @@ </funcprototype> </funcsynopsis> <para> - Returns: <literal>TRUE</literal> on success, - <literal>FALSE</literal> on errors + è¿ãå¤: æåæã« <literal>TRUE</literal>ãã¨ã©ã¼æã« + <literal>FALSE</literal> </para> <para> - <function>sesam_rollback</function> discards any pending updates to - the database. Also affected are result cursors and result - descriptors. + <function>sesam_rollback</function> ã¯ããã¼ã¿ãã¼ã¹ã¸ã®å¾ æ©ä¸ã® + æ´æ°ãç ´æ£ãã¾ããçµæã«ã¼ã½ã«ã¨çµæè¨è¿°åã夿´ããã¾ãã </para> <para> - At the end of each script, and as part of the - <function>sesam_disconnect</function> function, an implied - <function>sesam_rollback</function> is executed, discarding any - pending changes to the database. + ã¹ã¯ãªããã®çµäºæã«ã<function>sesam_disconnect</function> 颿° + ããæé»ã®ãã¡ã« <function>sesam_rollback</function>ãå®è¡ããã + ãã¼ã¿ãã¼ã¹ã®å¾ æ©ä¸ã®å ¨ã¦ã®å¤æ´ã¯ç ´æ£ããã¾ãã </para> <para> - See also: <function>sesam_commit</function>. + <function>sesam_commit</function>ãåç §ä¸ããã <example> - <title>Discarding an update to the SESAM database</title> + <title>SESAM ãã¼ã¿ãã¼ã¹ã¸ã®æ´æ°ãç ´æ£ãã</title> <programlisting role="php"> <?php if (sesam_connect ("mycatalog", "myschema", "otto")) { @@ -798,7 +794,7 @@ <refentry id="function.sesam-execimm"> <refnamediv> <refname>sesam_execimm</refname> - <refpurpose>Execute an "immediate" SQL-statement</refpurpose> + <refpurpose>SQLå½ä»¤ãç´ã¡ã«å®è¡ãã</refpurpose> </refnamediv> <refsect1> <title>説æ</title> @@ -809,32 +805,30 @@ </funcprototype> </funcsynopsis> <para> - Returns: A SESAM "result identifier" on success, or - <literal>FALSE</literal> on error. + è¿ãå¤: æåæã«SESAM "çµæID"ãã¨ã©ã¼æã« + <literal>FALSE</literal> </para> <para> - <function>sesam_execimm</function> executes an "immediate" - statement (i.e., a statement like UPDATE, INSERT or DELETE which - returns no result, and has no INPUT or OUTPUT variables). - "select type" queries can not be used with - <function>sesam_execimm</function>. Sets the - <parameter>affected_rows</parameter> value for retrieval by the - <function>sesam_affected_rows</function> function. - </para> - <para> - Note that <function>sesam_query</function> can handle both - "immediate" and "select-type" queries. Use - <function>sesam_execimm</function> only if you know beforehand - what type of statement will be executed. - An attempt to use SELECT type queries with - <function>sesam_execimm</function> will return - <literal>$err["sqlstate"] == "42SBW"</literal>. - </para> - <para> - The returned "result identifier" can not be used for retrieving - anything but the <function>sesam_affected_rows</function>; it is - only returned for symmetry with the - <function>sesam_query</function> function. + <function>sesam_execimm</function> ã¯å½ä»¤(ããªãã¡ãUPDATEã + INSERTãDELETEã®ãããªçµæãè¿ããªãå½ä»¤ãå ¥åºå夿°ããªãå½ä»¤)ã + "ç´ã¡ã«"å®è¡ãã¾ãã"select å" ã¯ã¨ãªã¯ã + <function>sesam_execimm</function> ã§ä½¿ç¨ãããã¨ã¯ã§ãã¾ããã + <function>sesam_affected_rows</function> 颿°ã«ããåå¾å¯è½ãª + <parameter>affected_rows</parameter> ã®å¤ãè¨å®ãã¾ãã + </para> + <para> + <function>sesam_query</function> ã¯ã"峿å"ããã³"selectå"ã¯ã¨ + ãªã®ä¸¡æ¹ãå¦çãããã¨ãã§ãããã¨ã«æ³¨æãã¦ä¸ãããå®è¡ãããå½ + 令ã®åãäºåã«åãã£ã¦ããå ´åã«ã®ã¿ + <function>sesam_execimm</function> ã使ç¨ãã¦ä¸ãããSELECTåã¯ã¨ + ãªã使ç¨ãããã¨ããã¨ã<function>sesam_execimm</function>㯠+ <literal>$err["sqlstate"] == "42SBW"</literal>ãè¿ãã¾ãã + </para> + <para> + è¿ããã"çµæID"ã¯ãä½ããåå¾ããéã«ä½¿ç¨ãããã¨ã¯ã§ããã + <function>sesam_affected_rows</function> ãå®è¡ããéã«ä½¿ç¨ãã¾ãã + ãã®IDã¯ã<function>sesam_query</function> 颿°ã¨å¯¾ç§°æ§ãä¿ã¤ãã + ã«ã®ã¿è¿ããã¾ãã </para> <para> <informalexample> @@ -847,8 +841,8 @@ sesam_affected_rows($result)."\n"); </programlisting> </informalexample> - See also: <function>sesam_query</function> and - <function>sesam_affected_rows</function>. + <function>sesam_query</function> ããã³ + <function>sesam_affected_rows</function>ãåç §ä¸ããã </para> </refsect1> </refentry> @@ -856,13 +850,13 @@ <refentry id="function.sesam-query"> <refnamediv> <refname>sesam_query</refname> - <refpurpose>Perform a SESAM SQL query and prepare the result</refpurpose> + <refpurpose>SESAM SQL ã¯ã¨ãªãå®è¡ããçµæãæºåãã</refpurpose> </refnamediv> <refsect1> <title>説æ</title> <funcsynopsis> <funcprototype> - <funcdef>string <function>sesam_query</function></funcdef> + <funcdef>resource <function>sesam_query</function></funcdef> <paramdef>string <parameter>query</parameter></paramdef> <paramdef>boolean <parameter><optional>scrollable</optional></parameter> @@ -870,66 +864,62 @@ </funcprototype> </funcsynopsis> <para> - Returns: A SESAM "result identifier" on success, or - <literal>FALSE</literal> on error. + è¿ãå¤: æåæã«SESAM "çµæID" ã¾ãã¯ã¨ã©ã¼æã« + <literal>FALSE</literal>ã </para> <para> - A "result_id" resource is used by other functions to retrieve the - query results. + "result_id"ãªã½ã¼ã¹ã¯ãã¯ã¨ãªçµæãåå¾ããéã«ä»ã®é¢æ°ã§ä½¿ç¨ãã + ã¾ãã </para> <para> - <function>sesam_query</function> sends a query to the currently - active database on the server. It can execute both - "immediate" SQL statements and "select type" queries. If an - "immediate" statement is executed, then no cursor is allocated, - and any subsequent <function>sesam_fetch_row</function> or - <function>sesam_fetch_result</function> call will return an empty - result (zero columns, indicating end-of-result). - For "select type" statements, a result descriptor and a - (scrollable or sequential, depending on the optional - boolean <parameter>scrollable</parameter> parameter) cursor will - be allocated. If <parameter>scrollable</parameter> is omitted, - the cursor will be sequential. + <function>sesam_query</function> ã¯ãã¯ã¨ãªããµã¼ãä¸ã®ç¾å¨ã¢ã¯ã㣠+ ããªãã¼ã¿ãã¼ã¹ã«éä¿¡ãã¾ãããã®é¢æ°ã¯ã"峿"SQLå½ä»¤ããã³ + "selectå"ã¯ã¨ãªã®ä¸¡æ¹ãå®è¡å¯è½ã§ãã"峿å"å½ä»¤ãå®è¡ããå ´åã + ã«ã¼ã½ã«ã¯ç¢ºä¿ãããããã®å¾ã« + <function>sesam_fetch_row</function> ã¾ã㯠+ <function>sesam_fetch_result</function> ãã³ã¼ã«ãã¦ã空ã®çµæ(çµ + æã®çµç«¯ã示ãã«ã©ã æ°0)ãè¿ããã¾ãã"selectå"å½ä»¤ã®å ´åãçµæ + è¨è¿°åããã³(ãªãã·ã§ã³ã®ãã©ã¡ã¼ã¿ + <parameter>scrollable</parameter>ã®è¨å®ã«ããã¹ã¯ãã¼ã«åã¾ãã¯é£ + ç¶åã®)ã«ã¼ã½ã«ã確ä¿ããã¾ãã<parameter>scrollable</parameter> + ãçç¥ãããå ´åãã«ã¼ã½ã«ã¯é£ç¶åã¨ãªãã¾ãã </para> <para> - When using "scrollable" cursors, the cursor can be freely - positioned on the result set. For each "scrollable" query, - there are global default values for the scrolling type - (initialized to: <literal>SESAM_SEEK_NEXT</literal>) and - the scrolling offset which can either be set once - by <function>sesam_seek_row</function> or - each time when fetching a row using - <function>sesam_fetch_row</function>. + "ã¹ã¯ãã¼ã«å"ã«ã¼ã½ã«ã使ç¨ãã¦ããå ´åãã«ã¼ã½ã«ã¯çµæéåä¸ã + èªç±ã«ç§»åå¯è½ã§ããå"ã¹ã¯ãã¼ã«å"ã¯ã¨ãªã«é¢ãã¦ãã¹ã¯ãã¼ã«å + ã®ã°ãã¼ãã«ããã©ã«ãå¤(<literal>SESAM_SEEK_NEXT</literal>ã«åæ + åããã¦ãã¾ã)㨠<function>sesam_seek_row</function> ã«ããä¸åº¦ + è¨å®ãããã<function>sesam_fetch_row</function> ã使ç¨ãã¦ã¬ã³ã¼ + ããåå¾ãã度ã«è¨å®ããã¹ã¯ãã¼ã«ãªãã»ãããããã¾ãã </para> <para> - For "immediate" statements, the number of affected - rows is saved for retrieval by the - <function>sesam_affected_rows</function> function. + "峿å"å½ä»¤ã®å ´åãä½ç¨ãããã¬ã³ã¼ãã®æ°ãä¿åããã¾ãããã®æ° + ã¯ã<function>sesam_affected_rows</function> 颿°ã§åå¾å¯è½ã§ãã </para> <para> - See also: <function>sesam_fetch_row</function> and - <function>sesam_fetch_result</function>. + <function>sesam_fetch_row</function> ããã³ + <function>sesam_fetch_result</function> ãåç §ä¸ããã <example> <title> - Show all rows of the "phone" table as a html table + "phone"ãã¼ãã«ã®å ¨ã¦ã®ã¬ã³ã¼ããHTMLãã¼ãã«ã¨ãã¦è¡¨ç¤º </title> <programlisting role="php"> <?php if (!sesam_connect("phonedb", "demo", "otto")) - die("cannot connect"); + die("æ¥ç¶ã§ãã¾ãã"); $result = sesam_query("select * from phone"); if (!$result) { $err = sesam_diagnostic(); die($err["errmsg"]); } echo "<TABLE BORDER>\n"; -// Add title header with column names above the result: +// ä¸ã®çµæã«ã©ã åã§ã¿ã¤ãã«ãããã追å ãã if ($cols = sesam_field_array($result)) { echo " <TR><TH COLSPAN=".$cols["count"].">Result:</TH></TR>\n"; echo " <TR>\n"; for ($col = 0; $col < $cols["count"]; ++$col) { $colattr = $cols[$col]; - /* Span the table head over SESAM's "Multiple Fields": */ + /* SESAMã®"è¤æ°ãã¼ãã«"ã«ã¾ããããã¼ãã«ããããå±é: */ if ($colattr["count"] > 1) { echo " <TH COLSPAN=".$colattr["count"].">".$colattr["name"]. "(1..".$colattr["count"].")</TH>\n"; @@ -942,7 +932,7 @@ } do { - // Fetch the result in chunks of 100 rows max. + // æå¤§100ã¬ã³ã¼ãåã®çµæãåå¾ $ok = sesam_fetch_result($result,100); for ($row=0; $row < $ok["rows"]; ++$row) { echo " <TR>\n"; @@ -954,9 +944,9 @@ } echo " </TR>\n"; } -} while ($ok["truncated"]); // while there may be more data +} while ($ok["truncated"]); // ã¾ã ãã¼ã¿ãããå¯è½æ§ãããé echo "</TABLE>\n"; -// free result id +// çµæIDãéæ¾ sesam_free_result($result); ?> </programlisting> @@ -968,7 +958,7 @@ <refentry id="function.sesam-num-fields"> <refnamediv> <refname>sesam_num_fields</refname> - <refpurpose>Return the number of fields/columns in a result set</refpurpose> + <refpurpose>çµæéåã®ãã£ã¼ã«ã/ã«ã©ã æ°ãè¿ã</refpurpose> </refnamediv> <refsect1> <title>説æ</title> @@ -978,23 +968,20 @@ <paramdef>string <parameter>result_id</parameter></paramdef> </funcprototype> </funcsynopsis> + <para> + "selectå"ã¯ã¨ãªã§ <function>sesam_query</function>ãã³ã¼ã«ããå¾ã + ãã®é¢æ°ã«ããçµæã®ã«ã©ã æ°ãå¾ããã¨ãå¯è½ã§ããå ¨ä½ã®ã«ã©ã (ã¾ + ãã¯ãã£ã¼ã«ã)ã®æ°ãè¨è¿°ããæ´æ°ãè¿ãã¾ãã + </para> + <para> + "峿å"å½ä»¤ã®å ´åãå¤0ãè¿ããã¾ããSESAM"è¤æ°ãã£ã¼ã«ã"ã«ã©ã + ã¯ãããããã®æ¬¡å æ¯ã«æ°ãããã¾ããããªãã¡ã"è¤æ°ãã£ã¼ã«ã"ã®3 + ã«ã©ã ã¯ã«ã©ã 3ã¤ã¨ãã¦æ°ãããã¾ãã + </para> <para> - After calling <function>sesam_query</function> with a - "select type" query, this function gives you the - number of columns in the result. - Returns an integer describing the total number of columns (aka. - fields) in the current <parameter>result_id</parameter> result - set or <literal>FALSE</literal> on error. - </para> - <para> - For "immediate" statements, the value zero is returned. The SESAM - "multiple field" columns count as their respective dimension, - i.e., a three-column "multiple field" counts as three columns. - </para> - <para> - See also: <function>sesam_query</function> and - <function>sesam_field_array</function> for a way to distinguish - between "multiple field" columns and regular columns. + "è¤æ°ãã£ã¼ã«ã"ã«ã©ã ãæ¨æºã«ã©ã ãåºå¥ããã«ã¯ã + <function>sesam_query</function> ããã³ + <function>sesam_field_array</function> ãåç §ä¸ããã </para> </refsect1> </refentry> @@ -1003,7 +990,7 @@ <refnamediv> <refname>sesam_field_name</refname> <refpurpose> - Return one column name of the result set + çµæéåã®ã«ã©ã åãè¿ã </refpurpose> </refnamediv> <refsect1> @@ -1016,28 +1003,31 @@ </funcprototype> </funcsynopsis> <para> - Returns the name of a field (i.e., the column name) in the result - set, or <literal>FALSE</literal> on error. + çµæéåã®ä¸ã®ãã£ã¼ã«ãå(ããªãã¡ãã«ã©ã å)ã¾ãã¯ã¨ã©ã¼ã®éã« + <literal>FALSE</literal> ãè¿ãã¾ãã </para> <para> - For "immediate" queries, or for dynamic columns, an empty string - is returned. + "峿å"ã¯ã¨ãªã¾ãã¯åçãªã«ã©ã ã®å ´åãç©ºã®æååãè¿ããã¾ãã </para> - <note><para> - The column index is zero-based, not one-based as in SESAM. - </para></note> + <note> + <para> + ã«ã©ã ã®æ·»åã¯ãSESAMã®ããã«1ããå§ã¾ããã0ããå§ã¾ãã¾ãã + </para> + </note> <para> - See also: <function>sesam_field_array</function>. It provides an - easier interface to access the column names and types, and allows - for detection of "multiple fields". + <function>sesam_field_array</function> ãåç §ä¸ããããã®é¢æ°ã¯ã + ã«ã©ã åããã³åã«ããç°¡åã«ã¢ã¯ã»ã¹ããã¤ã³ã¿ã¼ãã§ã¼ã¹ãæä¾ãã + "è¤æ°ãã£ã¼ã«ã"ã®æ¤åºãå¯è½ã«ãªãã¾ãã </para> </refsect1> </refentry> - + <refentry id="function.sesam-diagnostic"> <refnamediv> <refname>sesam_diagnostic</refname> - <refpurpose>ç´è¿ã®SESAMã³ã¼ã«ã«é¢ããã¹ãã¼ã¿ã¹æ å ±ãè¿ã</refpurpose> + <refpurpose> + ç´è¿ã®SESAMã³ã¼ã«ã«é¢ããã¹ãã¼ã¿ã¹æ å ±ãè¿ã + </refpurpose> </refnamediv> <refsect1> <title>説æ</title> @@ -1048,48 +1038,53 @@ </funcprototype> </funcsynopsis> <para> - Returns an associative array of status and return codes for the - last SQL query/statement/command. - Elements of the array are: + ç´è¿ã®SQLã¯ã¨ãª/å½ä»¤/ã³ãã³ãã«é¢ããã¹ãã¼ã¿ã¹ããã³ã¨ã©ã¼ã³ã¼ã + ã飿³é åã¨ãã¦è¿ãã¾ããé åã®è¦ç´ ã¯æ¬¡ã®ããã«ãªãã¾ãã <table> <title> - Status information returned by <function>sesam_diagnostic</function> + <function>sesam_diagnostic</function>ã«ããè¿ãããã¹ãã¼ã¿ã¹æ å ± </title> <tgroup cols="2"> <thead> <row> - <entry>Element</entry> - <entry>Contents</entry> + <entry>è¦ç´ </entry> + <entry>å 容</entry> </row> </thead> <tbody> <row> - <entry>$array["sqlstate"]</entry> - <entry>5 digit SQL return code (see the SESAM manual for the - description of the possible values of SQLSTATE)</entry> + <entry>$array["sqlstate"]</entry> + <entry> + 5 æ¡ã® SQL ãªã¿ã¼ã³ã³ã¼ã (SQLSTATEã®å¤ã®èª¬æã«ã¤ãã¦ã¯ã + SESAMããã¥ã¢ã«åç §) + </entry> </row> <row> - <entry>$array["rowcount"]</entry> - <entry>number of affected rows in last update/insert/delete - (set after "immediate" statements only) + <entry>$array["rowcount"]</entry> + <entry> + ç´è¿ã®update/insert/deleteã¯ã¨ãªã§ä½ç¨ãããã¬ã³ã¼ãã®æ° + ("峿å"å½ä»¤ã®å¾ã§ã®ã¿è¨å®ããã¾ã) </entry> </row> <row> <entry>$array["errmsg"]</entry> - <entry>"human readable" error message string - (set after errors only) + <entry> + "å¯èªãª" ã¨ã©ã¼ã¡ãã»ã¼ã¸æåå + (ã¨ã©ã¼ã®å¾ã§ã®ã¿è¨å®ããã¾ã) </entry> </row> <row> <entry>$array["errcol"]</entry> - <entry>error column number of previous error - (0-based; or -1 if undefined. Set after errors only) + <entry> + 以åã®ã¨ã©ã¼ã®ã¨ã©ã¼ã«ã©ã çªå· + (0ããå§ã¾ããæªå®ç¾©ã®å ´åã¯-1ãã¨ã©ã¼ã®å¾ã§ã®ã¿è¨å®ããã¾ã) </entry> </row> <row> <entry>$array["errlin"]</entry> - <entry>error line number of previous error - (0-based; or -1 if undefined. Set after errors only) + <entry> + åã®ã¨ã©ã¼ã®ã¨ã©ã¼è¡çªå· + (0ããå§ã¾ããæªå®ç¾©ã®å ´åã¯-1ãã¨ã©ã¼ã®å¾ã§ã®ã¿è¨å®ããã¾ã) </entry> </row> </tbody> @@ -1097,20 +1092,18 @@ </table> </para> <para> - In the following example, a syntax error (E SEW42AE ILLEGAL - CHARACTER) is displayed by including the offending SQL statement - and pointing to the error location: + 次ã®ä¾ã§ã¯ãåé¡ãããSQLå½ä»¤ãå«ã¿ãã¨ã©ã¼ä½ç½®ãæãæ§æã¨ã©ã¼(E + SEW42AE ILLEGAL CHARACTER)ã表示ããã¾ãã <example> - <title>Displaying SESAM error messages with error position</title> + <title>ã¨ã©ã¼ä½ç½®ãä»ãã¦SESAMã¨ã©ã¼ã¡ãã»ã¼ã¸ã表示</title> <programlisting role="php"> <?php -// Function which prints a formatted error message, -// displaying a pointer to the syntax error in the -// SQL statement +// ãã©ã¼ããããããã¨ã©ã¼ã¡ãã»ã¼ã¸ãåºåãã颿° +// SQLå½ä»¤ã«ãããæ§æã¨ã©ã¼ã®å ´æã表示 function PrintReturncode($exec_str) { $err = Sesam_Diagnostic(); - $colspan=4; // 4 cols for: sqlstate, errlin, errcol, rowcount + $colspan=4; // sqlstate, errlin, errcol, rowcount ç¨ã®4ã¤ã®ã«ã©ã if ($err["errlin"] == -1) --$colspan; if ($err["errcol"] == -1) @@ -1124,7 +1117,7 @@ echo "<TR><TD COLSPAN=".$colspan."><PRE>\n"; $errstmt = $exec_str."\n"; for ($lin=0; $errstmt != ""; ++$lin) { - if ($lin != $err["errlin"]) { // $lin is less or greater than errlin + if ($lin != $err["errlin"]) { // $lin ã¯errlinããå°ãããã¾ãã¯å¤§ãã if (! ($i = strchr($errstmt, "\n"))) $i = ""; $line = substr($errstmt, 0, strlen($errstmt)-strlen($i)+1); @@ -1161,7 +1154,7 @@ } if (!sesam_connect("mycatalog", "phoneno", "otto")) - die("cannot connect"); + die("æ¥ç¶ã§ãã¾ãã"); $stmt = "SELECT * FROM phone\n". " WHERE@ LASTNAME='KRAEMER'\n". @@ -1173,8 +1166,8 @@ </example> </para> <para> - See also: <function>sesam_errormsg</function> for simple access to the - error string only + ã¨ã©ã¼æååã«ç°¡åã«ã¢ã¯ã»ã¹ããããã«ã¯ã + <function>sesam_errormsg</function> ãåç §ä¸ããã </para> </refsect1> </refentry> @@ -1198,9 +1191,10 @@ </funcprototype> </funcsynopsis> <para> - Returns a mixed array with the query result entries, optionally - limited to a maximum of <parameter>max_rows</parameter> rows. - Note that both row and column indexes are zero-based. + ã¯ã¨ãªçµæã®ã¨ã³ããªã種ã ã®åã®é åã¨ãã¦è¿ãã¾ãããªãã·ã§ã³ã§ + æå¤§ã¬ã³ã¼ãæ°ã <parameter>max_rows</parameter> ã«å¶éãããã¨ã + å¯è½ã§ããã¬ã³ã¼ãçªå·ããã³ã«ã©ã çªå·ã¯å ±ã«0ããå§ã¾ããã¨ã«æ³¨æ + ãã¦ä¸ããã <table> <title> <function>sesam_fetch_result</function>ã«ããè¿ããã種ã ã®çµæéå @@ -1215,57 +1209,59 @@ <tbody> <row> <entry>int $arr["count"]</entry> - <entry>number of columns in result set (or zero if this was an - "immediate" query)</entry> + <entry> + çµæéåã®ã«ã©ã æ° ("峿å"ã¯ã¨ãªã®å ´åã«0) + </entry> </row> <row> <entry>int $arr["rows"]</entry> - <entry>number of rows in result set (between zero and - <parameter>max_rows</parameter>)</entry> + <entry> + çµæéåã®ã¬ã³ã¼ãæ°(0ã¨<parameter>max_rows</parameter>ã®é) + </entry> </row> <row> <entry>boolean $arr["truncated"]</entry> - <entry><literal>TRUE</literal> if the number of rows was at least - <parameter>max_rows</parameter>, <literal>FALSE</literal> otherwise. Note - that even when this is <literal>TRUE</literal>, the next - <function>sesam_fetch_result</function> call may return - zero rows because there are no more result entries. - </entry> + <entry> + ã¬ã³ã¼ãæ°ã<parameter>max_rows</parameter>以ä¸ã®å ´åã« + <literal>TRUE</literal>ãããã§ãªãå ´åã« + <literal>FALSE</literal>ãããã <literal>TRUE</literal>ã§ãª + ãå ´åã§ããçµæã¨ã³ããªã¯ãããªãããã«æ¬¡ã® + <function>sesam_fetch_result</function> ã¯ã¬ã³ã¼ããè¿ããªã + å¯è½æ§ãããã¾ãã + </entry> </row> <row> <entry>mixed $arr[col][row]</entry> - <entry>result data for all the fields at - row(<literal>row</literal>) and - column(<literal>col</literal>), (where the integer - index <literal>row</literal> is - between 0 and <literal>$arr["rows"]-1</literal>, and - <literal>col</literal> is between 0 - and <literal>$arr["count"]-1</literal>). Fields - may be empty, so you must check for the existence of a - field by using the php <function>isset</function> - function. The type of the returned fields depend on the - respective SQL type declared for its column (see <link - linkend="ref.sesam">SESAM overview</link> for the - conversions applied). SESAM "multiple - fields" are "inlined" and treated like a sequence - of columns. + <entry> + ã¬ã³ã¼ã(<literal>row</literal>) ããã³ + ã«ã©ã (<literal>col</literal>)ã«ããå ¨ã¦ã®ãã£ã¼ã«ãã®çµæãã¼ + ã¿ã(æ´æ°ã®ã¬ã³ã¼ãçªå·<literal>row</literal>ã¯0ãã + <literal>$arr["rows"]-1</literal>ã®éã§ããã + <literal>col</literal> 㯠0 ãã + <literal>$arr["count"]-1</literal>ã®éã§ã)ããã£ã¼ã«ãã¯ç©º + ã§ããå¯è½æ§ãããããã®ãããPHPã® + <function>isset</function> 颿°ã使ç¨ãã¦ãã£ã¼ã«ããåå¨ã + ããã©ãã確èªããå¿ è¦ãããã¾ããè¿ããããã£ã¼ã«ãã®åã¯ã + ãã®ã«ã©ã ã®SQLå宣è¨(é©ç¨ããã夿ã«ã¤ãã¦ã¯<link + linkend="ref.sesam">SESAM æ¦è¦</link>åç §)ã«ä¾åãã¾ãã + SESAM "è¤æ°ãã£ã¼ã«ã" ã¯"ã¤ã³ã©ã¤ã³"ã§ãããã«ã©ã ã®çªå·ã¨ + åæ§ã«å¦çããã¾ãã </entry> </row> </tbody> </tgroup> </table> - Note that the amount of memory used up by a large query may be - gigantic. Use the <parameter>max_rows</parameter> parameter to - limit the maximum number of rows returned, unless you are - absolutely sure that your result will not use up all available - memory. + 大ããªã¯ã¨ãªã§ä½¿ç¨ãããã¡ã¢ãªã®æå¤§å¤ã¯ã巨大ãªãã®ã«ãªãå¯è½æ§ + ããããã¨ã«æ³¨æãã¦ä¸ãããçµæãå©ç¨å¯è½ãªå ¨ã¡ã¢ãªãæ¶è²»ããªã + ãã¨ã確å®ã§ããå ´å以å¤ã¯ãè¿ãããã¬ã³ã¼ãæ°ã®æå¤§å¤ãå¶éãã + ããã« <parameter>max_rows</parameter> ãã©ã¡ã¼ã¿ã使ç¨ãã¦ä¸ããã </para> <para> - See also: <function>sesam_fetch_row</function>, and - <function>sesam_field_array</function> to check for "multiple - fields". See the description of the - <function>sesam_query</function> function for a complete example - using <function>sesam_fetch_result</function>. + "è¤æ°ãã£ã¼ã«ã"ã確èªããããã« + <function>sesam_fetch_row</function>ããã³ + <function>sesam_field_array</function> ãåç §ä¸ããã + <function>sesam_fetch_result</function>ã®å®å ¨ãªä¾ã«ã¤ãã¦ã¯ã + <function>sesam_query</function> 颿°ã®èª¬æãåç §ä¸ããã </para> </refsect1> </refentry> @@ -1286,31 +1282,30 @@ </funcprototype> </funcsynopsis> <para> - <parameter>result_id</parameter> is a valid result id returned by - <function>sesam_query</function>. + <parameter>result_id</parameter> ã¯ã + <function>sesam_query</function> ã«ããè¿ãããæå¹ãªçµæIDã§ãã </para> <para> - Returns the number of rows affected by a query associated with - <parameter>result_id</parameter>. + <parameter>result_id</parameter> ã«é¢é£ããã¯ã¨ãªã«ããä½ç¨ããã + ã¬ã³ã¼ãæ°ãè¿ãã¾ãã </para> <para> - The <function>sesam_affected_rows</function> function can only - return useful values when used in combination with "immediate" SQL - statements (updating operations like <literal>INSERT</literal>, - <literal>UPDATE</literal> and <literal>DELETE</literal>) because - SESAM does not deliver any "affected rows" information for "select - type" queries. - The number returned is the number of affected rows. + <function>sesam_affected_rows</function> 颿°ã¯ã"峿å"SQLå½ä»¤ + (<literal>INSERT</literal>ã<literal>UPDATE</literal>ã + <literal>DELETE</literal>ã®ãããªæ´æ°å¦ç)ã®çµåãã§ä½¿ç¨ãããå ´ + åã«ã®ã¿æç¨ãªå¤ãè¿ãã¾ããããã¯ãSESAMã"selectå"ã¯ã¨ãªã«é¢ã + ã¦"ä½ç¨ãããã¬ã³ã¼ã"ã«é¢ããæ å ±ãè¿ããªãããã§ããè¿ãããæ° + ã¯ä½ç¨ãããã¬ã³ã¼ãã®æ°ã§ãã </para> <para> - See also: <function>sesam_query</function> and - <function>sesam_execimm</function> + <function>sesam_query</function> ããã³ + <function>sesam_execimm</function> ãåç §ä¸ããã </para> <informalexample> <programlisting role="php"> $result = sesam_execimm ("DELETE FROM PHONE WHERE LASTNAME = '".strtoupper($name)."'"); if (! $result) { - ... error ... + ... ã¨ã©ã¼ ... } print sesam_affected_rows($result). " entries with last name ".$name." deleted.\n" @@ -1333,8 +1328,7 @@ </funcprototype> </funcsynopsis> <para> - Returns the SESAM error message associated with the most - recent SESAM error. + ç´è¿ã®SESAMã¨ã©ã¼ã«é¢é£ãã SESAMã¨ã©ã¼ã¡ãã»ã¼ã¸ãè¿ãã¾ãã </para> <informalexample> <programlisting role="php"> @@ -1343,8 +1337,8 @@ </programlisting> </informalexample> <para> - See also: <function>sesam_diagnostic</function> for the full set - of SESAM SQL status information + SESAM SQLã¹ãã¼ã¿ã¹æ å ±ã®å®å ¨ãªéåã«ã¤ãã¦ã¯ã + <function>sesam_diagnostic</function> ãåç §ä¸ããã </para> </refsect1> </refentry> @@ -1365,180 +1359,172 @@ </funcprototype> </funcsynopsis> <para> - <parameter>result_id</parameter> is a valid result id returned by - <function>sesam_query</function>. + <parameter>result_id</parameter> ã¯ã + <function>sesam_query</function> ã«ããè¿ãããæå¹ãªçµæIDã§ãã </para> <para> - Returns a mixed associative/indexed array with meta information - (column name, type, precision, ...) about individual columns of the result after the - query associated with <parameter>result_id</parameter>. + <parameter>result_id</parameter>ã«é¢é£ããã¯ã¨ãªã®å¾ã§ãçµæã®åã + ã®ã«ã©ã ã«é¢ããã¡ã¿æ å ±(ã«ã©ã åãåã精度ã...)ãæãã飿³/æ·» + åé åãè¿ãã¾ãã </para> <para> <table> <title> - Mixed result set returned by <function>sesam_field_array</function> + <function>sesam_field_array</function> ã§è¿ãããçµæéå </title> <tgroup cols="2"> <thead> <row> - <entry>Array Element</entry> - <entry>Contents</entry> + <entry>é åè¦ç´ </entry> + <entry>宿°</entry> </row> </thead> <tbody> <row> <entry>int $arr["count"]</entry> - <entry>Total number of columns in result set (or zero if - this was an "immediate" query). SESAM "multiple - fields" are "inlined" and treated like the - respective number of columns. + <entry> + çµæéåã«ãããã«ã©ã æ°ã®åè¨ (ã¾ãã¯"峿å"ã¯ã¨ãªã®å ´åã« + 0)ã SESAM "è¤æ°ãã£ã¼ã«ã"ã¯ã¤ã³ã©ã¤ã³åããã¦ããã対å¿ã + ãã«ã©ã çªå·ã¨åæ§ã«å¦çããã¾ãã </entry> </row> <row> <entry>string $arr[col]["name"]</entry> - <entry>column name for column(<literal>col</literal>), - where <literal>col</literal> is between 0 and - <literal>$arr["count"]-1</literal>. The returned - value can be the empty string (for dynamically - computed columns). SESAM "multiple fields" are - "inlined" and treated like the respective number of - columns, each with the same column name. + <entry> + ã«ã©ã (<literal>col</literal>)ã®ã«ã©ã åããã ãã + <literal>col</literal> ã¯ã0 ãã + <literal>$arr["count"]-1</literal>ã®éã§ããè¿ãããå¤ã¯ã + (åçã«è¨ç®ãããã«ã©ã ã®å ´åã)ç©ºã®æååã¨ãªãå¯è½æ§ããã + ã¾ããSESAM "è¤æ°ãã£ã¼ã«ã" ã¯"ã¤ã³ã©ã¤ã³å"ããã¦ãããã« + ã©ã çªå·ã¨åæ§ã«åãã«ã©ã åã§å¦çããã¾ãã </entry> </row> <row> <entry>string $arr[col]["count"]</entry> - <entry>The "count" attribute describes the repetition - factor when the column has been declared as a - "multiple field". Usually, the "count" attribute is - 1. The first column of a "multiple field" column - however contains the number of repetitions (the - second and following column of the "multiple field" - contain a "count" attribute of 1). This can be used - to detect "multiple fields" in the result set. See - the example shown in the - <function>sesam_query</function> description for a - sample use of the "count" attribute. - </entry> + <entry> + 屿§ "count" ã¯ãã«ã©ã ã"è¤æ°ãã£ã¼ã«ã"ã¨ãã¦å®£è¨ãããå ´ + åã®ç¹°ãè¿ãæ°ãè¨è¿°ãã¾ããé常ã"count"屿§ã¯1ã§ãããããã + "è¤æ°ãã£ã¼ã«ã"ã«ã©ã ã®æåã®ã«ã©ã ã¯ç¹°è¿ãæ°ãæãã¾ãã + ("è¤æ°ãã£ã¼ã«ã"ã®2çªç®ä»¥éã®ã«ã©ã ã¯1ã¨ãã"count"屿§ãæ + ãã¾ã)ãã®å±æ§ã¯ãçµæéåã®ä¸ã§"è¤æ°ãã£ã¼ã«ã"ãæ¤åºãã + ããã«ä½¿ç¨å¯è½ã§ãã"count"屿§ã®ä½¿ç¨ä¾ã«ã¤ãã¦ã¯ã + <function>sesam_query</function> ã®èª¬æã«ç¤ºããã¦ããä¾ãå + ç §ä¸ããã + </entry> </row> <row> <entry>string $arr[col]["type"]</entry> - <entry>php variable type of the data for - column(<literal>col</literal>), where - <literal>col</literal> is between 0 - and <literal>$arr["count"]-1</literal>. The returned - value can be one of - <itemizedlist> - <listitem> - <simpara>"integer"</simpara> - </listitem> - <listitem> - <simpara>"double"</simpara> - </listitem> - <listitem> - <simpara>"string"</simpara> - </listitem> - </itemizedlist> - depending on the SQL type of the result. SESAM - "multiple fields" are "inlined" and treated like the - respective number of columns, each with the same php - type. - </entry> - </row> - <row> - <entry>string $arr[col]["sqltype"]</entry> - <entry>SQL variable type of the column data for - column(<literal>col</literal>), where - <literal>col</literal> is between 0 - and <literal>$arr["count"]-1</literal>. The returned - value can be one of - <itemizedlist> - <listitem> - <simpara>"CHARACTER"</simpara> - </listitem> - <listitem> - <simpara>"VARCHAR"</simpara> - </listitem> - <listitem> - <simpara>"NUMERIC"</simpara> - </listitem> - <listitem> - <simpara>"DECIMAL"</simpara> - </listitem> - <listitem> - <simpara>"INTEGER"</simpara> - </listitem> - <listitem> - <simpara>"SMALLINT"</simpara> - </listitem> - <listitem> - <simpara>"FLOAT"</simpara> - </listitem> - <listitem> - <simpara>"REAL"</simpara> - </listitem> - <listitem> - <simpara>"DOUBLE"</simpara> - </listitem> - <listitem> - <simpara>"DATE"</simpara> - </listitem> - <listitem> - <simpara>"TIME"</simpara> - </listitem> - <listitem> - <simpara>"TIMESTAMP"</simpara> - </listitem> - </itemizedlist> - describing the SQL type of the result. SESAM - "multiple fields" are "inlined" and treated like the - respective number of columns, each with the same SQL - type. + <entry> + ã«ã©ã (<literal>col</literal>)ã«é¢ãããã¼ã¿ã®PHP 夿°åãã + ã ãã<literal>col</literal> 㯠0 㨠+ <literal>$arr["count"]-1</literal> ã®éã§ããå¤ã¯ãçµæã®SQL + åã«åºã¥ã以ä¸ã®ã©ããã¨ãªãã¾ãã + <itemizedlist> + <listitem> + <simpara>"integer"</simpara> + </listitem> + <listitem> + <simpara>"double"</simpara> + </listitem> + <listitem> + <simpara>"string"</simpara> + </listitem> + </itemizedlist> + SESAM "è¤æ°ãã£ã¼ã«ã"ã¯"ã¤ã³ã©ã¤ã³å"ããã¦ãããåãã«ã©ã + æ°ãæããåãPHPåã®å ´åã¨åæ§ã«å¦çããã¾ãã + </entry> + </row> + <row> + <entry>string $arr[col]["sqltype"]</entry> + <entry> + SQL variable type of the column data for + ã«ã©ã (<literal>col</literal>)ã«é¢ããã«ã©ã ãã¼ã¿ã®SQL夿° + åããã ãã<literal>col</literal> 㯠0 ãã + and <literal>$arr["count"]-1</literal>ã®éã«ãªãã¾ããè¿ãã + ãå¤ã¯ãçµæã®SQLåãè¨è¿°ããæ¬¡ã®ã©ããã¨ãªãã¾ãã + <itemizedlist> + <listitem> + <simpara>"CHARACTER"</simpara> + </listitem> + <listitem> + <simpara>"VARCHAR"</simpara> + </listitem> + <listitem> + <simpara>"NUMERIC"</simpara> + </listitem> + <listitem> + <simpara>"DECIMAL"</simpara> + </listitem> + <listitem> + <simpara>"INTEGER"</simpara> + </listitem> + <listitem> + <simpara>"SMALLINT"</simpara> + </listitem> + <listitem> + <simpara>"FLOAT"</simpara> + </listitem> + <listitem> + <simpara>"REAL"</simpara> + </listitem> + <listitem> + <simpara>"DOUBLE"</simpara> + </listitem> + <listitem> + <simpara>"DATE"</simpara> + </listitem> + <listitem> + <simpara>"TIME"</simpara> + </listitem> + <listitem> + <simpara>"TIMESTAMP"</simpara> + </listitem> + </itemizedlist> + SESAM "è¤æ°ãã£ã¼ã«ã"ã¯"ã¤ã³ã©ã¤ã³å"ããã¦ãããåãã«ã©ã + æ°ãåãPHPåã®å ´åã¨åæ§ã«å¦çããã¾ãã </entry> </row> <row> <entry>string $arr[col]["length"]</entry> - <entry>The SQL "length" attribute of the SQL variable in - column(<literal>col</literal>), where - <literal>col</literal> is between 0 and - <literal>$arr["count"]-1</literal>. The "length" - attribute is used with "CHARACTER" and "VARCHAR" SQL - types to specify the (maximum) length of the string - variable. SESAM "multiple fields" are "inlined" and - treated like the respective number of columns, each with - the same length attribute. - </entry> + <entry> + ã«ã©ã (<literal>col</literal>)ã®SQL夿°ã®SQL "length" 屿§ã + ãã ãã<literal>col</literal> ã¯ã0 ãã + <literal>$arr["count"]-1</literal>ã®éã§ãã"length"屿§ã¯ã + æåå夿°ã®(æå¤§)é·ããæå®ããããã«"CHARACTER" ããã³ + "VARCHAR" SQLåãæå®ãã¦ä½¿ç¨ããã¾ãã + SESAM "è¤æ°ãã£ã¼ã«ã"ã¯"ã¤ã³ã©ã¤ã³å"ããã¦ãããåãã«ã©ã + æ°ãåãPHPåã®å ´åã¨åæ§ã«å¦çããã¾ãã + </entry> </row> <row> <entry>string $arr[col]["precision"]</entry> - <entry>The "precision" attribute of the SQL variable in - column(<literal>col</literal>), where - <literal>col</literal> is between 0 and - <literal>$arr["count"]-1</literal>. The "precision" - attribute is used with numeric and time data types. - SESAM "multiple fields" are "inlined" and - treated like the respective number of columns, each with - the same precision attribute. - </entry> + <entry> + ã«ã©ã (<literal>col</literal>ã«ããSQL夿°,ã® + "precision" 屿§ããã ãã<literal>col</literal> ã¯ã0ãã + <literal>$arr["count"]-1</literal>ã®éã§ãã"precision"屿§ + ã¯ãæ°å¤ããã³æéãã¼ã¿åã§ä½¿ç¨ããã¾ãã + SESAM "è¤æ°ãã£ã¼ã«ã"ã¯"ã¤ã³ã©ã¤ã³å"ããã¦ãããåãã«ã©ã + æ°ãåãPHPåã®å ´åã¨åæ§ã«å¦çããã¾ãã + </entry> </row> <row> <entry>string $arr[col]["scale"]</entry> - <entry>The "scale" attribute of the SQL variable in - column(<literal>col</literal>), where - <literal>col</literal> is between 0 and - <literal>$arr["count"]-1</literal>. The "scale" - attribute is used with numeric data types. - SESAM "multiple fields" are "inlined" and - treated like the respective number of columns, each with - the same scale attribute. - </entry> + <entry> + ã«ã©ã (<literal>col</literal>)ã«ããSQL夿°ã®"scale" 屿§ã + ãã ãã<literal>col</literal> ã¯ã0 ãã + <literal>$arr["count"]-1</literal>ã®éã§ãã"scale"屿§ã¯ã + æ°å¤ãã¼ã¿åã§ä½¿ç¨ããã¾ãã + SESAM "è¤æ°ãã£ã¼ã«ã"ã¯"ã¤ã³ã©ã¤ã³å"ããã¦ãããåãã«ã©ã + æ°ãåãPHPåã®å ´åã¨åæ§ã«å¦çããã¾ãã + </entry> </row> </tbody> </tgroup> </table> </para> <para> - See the <function>sesam_query</function> function - for an example of the <function>sesam_field_array</function> use. + <function>sesam_field_array</function> ã®ä½¿ç¨ä¾ã«ã¤ãã¦ã¯ã + <function>sesam_query</function> 颿°ãåç §ä¸ããã </para> </refsect1> </refentry> @@ -1546,7 +1532,7 @@ <refentry id="function.sesam-fetch-row"> <refnamediv> <refname>sesam_fetch_row</refname> - <refpurpose>ã¬ã³ã¼ãã1ä»¶é åã¨ãã¦åå¾</refpurpose> + <refpurpose>1ä»¶åã®ã¬ã³ã¼ããé åã¨ãã¦åå¾</refpurpose> </refnamediv> <refsect1> <title>説æ</title> @@ -1563,132 +1549,137 @@ </funcprototype> </funcsynopsis> <para> - Returns an array that corresponds to the fetched row, - or <literal>FALSE</literal> if there are no more rows. + åå¾ããã¬ã³ã¼ããå«ãé åã¾ãã¯ããã¬ã³ã¼ãããªãå ´åã« + <literal>FALSE</literal> ãè¿ãã¾ãã </para> - <para>The number of columns in the result set is returned in an - associative array element $array["count"]. Because some of the - result columns may be empty, the - <function>count</function> function can not be used on - the result row returned by - <function>sesam_fetch_row</function>. + <para> + çµæéåã®ã«ã©ã æ°ã飿³é åã®è¦ç´ $array["count"] ã§è¿ããã¾ãã + ããã¤ãã®ã«ã©ã ã¯ç©ºã§ããå¯è½æ§ãããããã + <function>sesam_fetch_row</function> ã«ããè¿ãããçµæã¬ã³ã¼ãã« + 対ã㦠<function>count</function> 颿°ã使ç¨ãããã¨ã¯ã§ãã¾ããã </para> <para> - <parameter>result_id</parameter> is a valid result id returned by - <function>sesam_query</function> (select type queries only!). + <parameter>result_id</parameter> ã¯ã + <function>sesam_query</function> (select åã¯ã¨ãªã®ã¿!)ã«ããè¿ã + ããæå¹ãªçµæIDã§ãã </para> <para> - <parameter><optional>whence</optional></parameter> is an - optional parameter for a fetch operation on "scrollable" - cursors, which can be set to the following predefined - constants: + <parameter><optional>whence</optional></parameter> ã¯ã"ã¹ã¯ãã¼ + ã«å"ã«ã¼ã½ã«ã§åå¾å¦çãè¡ãããã®ãªãã·ã§ã³ãã©ã¡ã¼ã¿ã§ã次ã®ã + ããªå®ç¾©æ¸ã¿ã®å®æ°ãè¨å®ãããã¨ãå¯è½ã§ãã <table> - <title>Valid values for <parameter>"whence"</parameter> parameter</title> + <title><parameter>"whence"</parameter> ãã©ã¡ã¼ã¿ã§æå¹ãªå¤</title> <tgroup cols="3"> <thead> <row> - <entry>Value</entry> - <entry>Constant</entry> - <entry>Meaning</entry> + <entry>å¤</entry> + <entry>宿°</entry> + <entry>æå³</entry> </row> </thead> <tbody> <row> - <entry>0</entry> - <entry><literal>SESAM_SEEK_NEXT</literal></entry> - <entry>read sequentially (after fetch, the internal default is - set to <literal>SESAM_SEEK_NEXT</literal>) - </entry> + <entry>0</entry> + <entry><literal>SESAM_SEEK_NEXT</literal></entry> + <entry> + é£ç¶çã«èªã¿è¾¼ã(åå¾å¾ãå é¨ããã©ã«ãå¤ã¯ + <literal>SESAM_SEEK_NEXT</literal>ã«è¨å®ããã¾ã) + </entry> + </row> + <row> + <entry>1</entry> + <entry><literal>SESAM_SEEK_PRIOR</literal></entry> + <entry> + é£ç¶çã«å¾åãã«èªã¿è¾¼ã (åå¾å¾ãå é¨ããã©ã«ãå¤ã¯ + <literal>SESAM_SEEK_PRIOR</literal>ã«è¨å®ããã¾ã) + </entry> + </row> + <row> + <entry>2</entry> + <entry><literal>SESAM_SEEK_FIRST</literal></entry> + <entry> + æåã®ã¬ã³ã¼ãã«ç§»å(åå¾å¾ãããã©ã«ãå¤ã¯ + <literal>SESAM_SEEK_NEXT</literal>ã«è¨å®ããã¾ã) + </entry> + </row> + <row> + <entry>3</entry> + <entry><literal>SESAM_SEEK_LAST</literal></entry> + <entry> + æå¾ã®ã¬ã³ã¼ãã«ç§»å (åå¾å¾ãããã©ã«ãå¤ã¯ + <literal>SESAM_SEEK_PRIOR</literal>ã«è¨å®ããã¾ã) + </entry> + </row> + <row> + <entry>4</entry> + <entry><literal>SESAM_SEEK_ABSOLUTE</literal></entry> + <entry> + <parameter>offset</parameter> (0ãå é ãåå¾å¾ãå é¨ããã©ã« + ãå¤ã¯ã<literal>SESAM_SEEK_ABSOLUTE</literal> ã«è¨å®ãã¦ä¸ + ãããå é¨ã®ãªãã»ããå¤ã¯ãèªåçã«å¢å ãã¾ã)ã§æå®ããçµ¶ + 対ã¬ã³ã¼ãçªå·ã«ç§»åãã¾ãã + </entry> + </row> + <row> + <entry>5</entry> + <entry><literal>SESAM_SEEK_RELATIVE</literal></entry> + <entry> + ã«ã¬ã³ãã®ã¹ã¯ãã¼ã«ä½ç½®ã«å¯¾ãã¦ç¸å¯¾ä½ç½®ã«ç§»åããã ãã + <parameter>offset</parameter> ã¯æ£ã¾ãã¯è² ã®å¤ãæå®å¯è½ã§ãã + </entry> </row> - <row> - <entry>1</entry> - <entry><literal>SESAM_SEEK_PRIOR</literal></entry> - <entry>read sequentially backwards (after fetch, the internal - default is set to <literal>SESAM_SEEK_PRIOR</literal>) - </entry> - </row> - <row> - <entry>2</entry> - <entry><literal>SESAM_SEEK_FIRST</literal></entry> - <entry>rewind to first row (after fetch, the default is set to - <literal>SESAM_SEEK_NEXT</literal>)</entry> - </row> - <row> - <entry>3</entry> - <entry><literal>SESAM_SEEK_LAST</literal></entry> - <entry>seek to last row (after fetch, the default is set to - <literal>SESAM_SEEK_PRIOR</literal>)</entry> - </row> - <row> - <entry>4</entry> - <entry><literal>SESAM_SEEK_ABSOLUTE</literal></entry> - <entry>seek to absolute row number given as - <parameter>offset</parameter> (Zero-based. After fetch, - the internal default is - set to <literal>SESAM_SEEK_ABSOLUTE</literal>, and the - internal offset value is auto-incremented)</entry> - </row> - <row> - <entry>5</entry> - <entry><literal>SESAM_SEEK_RELATIVE</literal></entry> - <entry>seek relative to current scroll position, where - <parameter>offset</parameter> can be a positive or - negative offset value.</entry> - </row> </tbody> </tgroup> </table> - This parameter is only valid for "scrollable" cursors. + ãã®ãã©ã¡ã¼ã¿ã¯ã"ã¹ã¯ãã¼ã«å"ã«ã¼ã½ã«ã§ã®ã¿æå¹ã§ãã </para> <para> - When using "scrollable" cursors, the cursor can be freely - positioned on the result set. If the - <parameter><optional>whence</optional></parameter> parameter - is omitted, the global default values for the scrolling type - (initialized to: <literal>SESAM_SEEK_NEXT</literal>, and - settable by <function>sesam_seek_row</function>) are used. If - <parameter><optional>whence</optional></parameter> is - supplied, its value replaces the global default. - </para> - <para> - <parameter><optional>offset</optional></parameter> is an - optional parameter which is only evaluated (and required) - if <parameter><optional>whence</optional></parameter> is - either <literal>SESAM_SEEK_RELATIVE</literal> or - <literal>SESAM_SEEK_ABSOLUTE</literal>. This - parameter is only valid for "scrollable" cursors. - </para> - <para> - <function>sesam_fetch_row</function> fetches one row of data - from the result associated with the specified result - identifier. The row is returned as an array (indexed by - values between <literal>0</literal> and - <literal>$array["count"]-1</literal>). Fields may be empty, - so you must check for the existence of a field by using the - php <function>isset</function> function. The type of the - returned fields depend on the respective SQL type declared for - its column (see <link linkend="ref.sesam">SESAM - overview</link> for the conversions applied). SESAM "multiple - fields" are "inlined" and treated like a sequence of columns. - </para> - <para> - Subsequent calls to <function>sesam_fetch_row</function> would - return the next (or prior, or n'th next/prior, depending on - the scroll attributes) row in the result set, or - <literal>FALSE</literal> if there are no - more rows. + "ã¹ã¯ãã¼ã«å"ã«ã¼ã½ã«ã使ç¨ãã¦ããå ´åãã«ã¼ã½ã«ã¯çµæéåãèª + ç±ã«ç§»åå¯è½ã§ãã + <parameter><optional>whence</optional></parameter> ãã©ã¡ã¼ã¿ãç + ç¥ãããå ´åãã¹ã¯ãã¼ã«ã®åã«ã¯ãã°ãã¼ãã«ãªããã©ã«ãå¤ + (<literal>SESAM_SEEK_NEXT</literal>ã«åæåããã¦ããã + <function>sesam_seek_row</function>ã§è¨å®å¯è½ã§ã) ã使ç¨ããã¾ãã + <parameter><optional>whence</optional></parameter> ãæå®ãããå ´ + åããã®å¤ã¯ã°ãã¼ãã«ããã©ã«ãå¤ã«ç½®æããã¾ãã + </para> + <para> + <parameter><optional>offset</optional></parameter> ã¯ããªãã·ã§ã³ + ã®ãã©ã¡ã¼ã¿ã§ããã + <parameter><optional>whence</optional></parameter> ã + <literal>SESAM_SEEK_RELATIVE</literal> ã¾ã㯠+ <literal>SESAM_SEEK_ABSOLUTE</literal> ã®ã©ã¡ããã§ããå ´åã«ã®ã¿ + è©ä¾¡ããã¾ã(ããã¦å¿ è¦ã¨ããã¾ã)ããã®ãã©ã¡ã¼ã¿ã¯ã"ã¹ã¯ãã¼ã« + å"ã«ã¼ã½ã«ã§ã®ã¿æå¹ã§ãã + </para> + <para> + <function>sesam_fetch_row</function> ã¯ãæå®ããçµæIDãæãçµæ + ãã1ä»¶åã®ã¬ã³ã¼ãã®ãã¼ã¿ãåå¾ãã¾ããã¬ã³ã¼ãã¯ã( + <literal>0</literal> ãã <literal>$array["count"]-1</literal> ã + æ·»åã¨ãã)é åã¨ãã¦è¿ããã¾ãããã£ã¼ã«ãã¯ç©ºã§ããå¯è½æ§ããã + ãããPHP ã® <function>isset</function> 颿°ã使ç¨ãã¦ãã£ã¼ã«ã + ã®åå¨ã確èªããå¿ è¦ãããã¾ããè¿ããããã£ã¼ã«ãã®åã¯ããã®ã« + ã©ã ã宣è¨ããSQLåã«ä¾åãã¾ãã(é©ç¨ããã夿ã«ã¤ãã¦ã¯ã<link + linkend="ref.sesam">SESAMã®æ¦è¦</link> ãåç §ä¸ããã + SESAM "è¤æ°ãã£ã¼ã«ã" 㯠"ã¤ã³ã©ã¤ã³å" ããã¦ãããé£ç¶ããã«ã© + ã ã®ããã«å¦çããã¾ãã + </para> + <para> + <function>sesam_fetch_row</function> ãé£ãã¦ã³ã¼ã«ããå ´åãçµæ + éåã®æ¬¡ã®(ã¹ã¯ãã¼ã«å±æ§ã«å¿ãã¦åã¾ãã¯nçªç®ã®å/å¾)ã¬ã³ã¼ãã¾ + ãã¯ã¬ã³ã¼ãããããªãå ´åã« <literal>FALSE</literal>ãè¿ãã¾ãã </para> <example> - <title>SESAM fetch rows</title> + <title>SESAM ã¬ã³ã¼ããåå¾</title> <programlisting role="php"> <?php $result = sesam_query ("SELECT * FROM phone\n". " WHERE LASTNAME='".strtoupper($name)."'\n". " ORDER BY FIRSTNAME", 1); if (! $result) { - ... error ... + ... ã¨ã©ã¼ ... } -// print the table in backward order +// éé ã«ãã¼ãã«ãåºå print "<TABLE BORDER>\n"; $row = sesam_fetch_row ($result, SESAM_SEEK_LAST); while (is_array($row)) { @@ -1697,7 +1688,7 @@ print " <TD>".htmlspecialchars($row[$col])."</TD>\n"; } print " </TR>\n"; - // use implied SESAM_SEEK_PRIOR + // æé»ã® SESAM_SEEK_PRIOR ãä½¿ç¨ $row = sesam_fetch_row ($result); } print "</TABLE>\n"; @@ -1706,9 +1697,9 @@ </programlisting> </example> <para> - See also: <function>sesam_fetch_array</function> which returns - an associative array, and <function>sesam_fetch_result</function> - which returns many rows per invocation. + 飿³é åãè¿ã <function>sesam_fetch_array</function>ãããã¦ã + ä¸åº¦ã«å¤ãã®ã¬ã³ã¼ããè¿ã + <function>sesam_fetch_result</function> ãåç §ä¸ããã </para> </refsect1> </refentry> @@ -1733,73 +1724,66 @@ </funcprototype> </funcsynopsis> <para> - Returns an array that corresponds to the fetched row, - or <literal>FALSE</literal> if there are no more rows. + åå¾ããã¬ã³ã¼ãã«å¯¾å¿ããé åã¾ãã¯ã¬ã³ã¼ãããããªãå ´åã«ã¯ + <literal>FALSE</literal> ãè¿ãã¾ãã </para> <para> - <function>sesam_fetch_array</function> is an alternative - version of <function>sesam_fetch_row</function>. Instead - of storing the data in the numeric indices of the result - array, it stores the data in associative indices, using the - field names as keys. + <function>sesam_fetch_array</function> ã¯ã + <function>sesam_fetch_row</function> ã®é£æ³é åçã§ãããã¼ã¿ãçµ + æé åã®æ°å¤æ·»åã«ä¿åãã代ããã«ããã¼ã¿ããã£ã¼ã«ãåããã¼ã¨ + ãã¦é£æ³é åã«ä¿åãã¾ãã </para> <para> - <parameter>result_id</parameter> is a valid result id returned by - <function>sesam_query</function> (select type queries only!). + <parameter>result_id</parameter> ã¯ã + <function>sesam_query</function> (select åã¯ã¨ãªã®ã¿!)ã«ããè¿ã + ããæå¹ãªçµæIDã§ãã </para> <para> - For the valid values of the optional - <parameter><optional>whence</optional></parameter>and - <parameter><optional>offset</optional></parameter> - parameters, see the <function>sesam_fetch_row</function> - function for details. + ãªãã·ã§ã³ã® <parameter><optional>whence</optional></parameter> + ããã³ <parameter><optional>offset</optional></parameter> ãã©ã¡ã¼ + ã¿ã®æå¹ãªå¤ã®è©³ç´°ã«ã¤ãã¦ã¯ã颿° + <function>sesam_fetch_row</function> ãåç §ä¸ããã </para> <para> - <function>sesam_fetch_array</function> fetches one row of data from - the result associated with the specified result identifier. The - row is returned as an associative array. Each result - column is stored with an associative index equal to its - column (aka. field) name. The column names are converted to lower case. - + <function>sesam_fetch_array</function> ã¯ã + æå®ããçµæIDãæãçµæãã1ä»¶åã®ã¬ã³ã¼ããåå¾ãã¾ããã¬ã³ã¼ã + ã¯ã飿³é åã¨ãã¦è¿ããã¾ããåçµæã«ã©ã ã¯ããã®ã«ã©ã (ã¾ã㯠+ ãã£ã¼ã«ã)åã«çãã飿³é åã®è¦ç´ ã«ä¿åããã¾ããã«ã©ã åã¯ãå° + æåã«å¤æããã¾ãã </para> <para> - Columns without a field name (e.g., results of arithmetic - operations) and empty fields are not stored in the array. - Also, if two or more columns of the result have the same - column names, the later column will take precedence. In - this situation, either call - <function>sesam_fetch_row</function> or make an alias for - the column. + ãã£ã¼ã«ãåããªãã«ã©ã (ä¾ãã°ãæ°å¤æ¼ç®ã®çµæ)ããã³ç©ºã®ãã£ã¼ + ã«ãã¯ãé åã«ä¿åããã¾ãããã¾ãã2ã¤ä»¥ä¸ã®çµæãã«ã©ã åã«åã + ã«ã©ã åãããå ´åãæå¾ã®ã«ã©ã ãåªå ããã¾ãããã®å ´åã + <function>sesam_fetch_row</function>ãã³ã¼ã«ããããã®ã«ã©ã ã¸ã® + ã¨ã¤ãªã¢ã¹ã使ãã¦ä¸ããã <informalexample> <programlisting> -SELECT TBL1.COL AS FOO, TBL2.COL AS BAR FROM TBL1, TBL2</programlisting> +SELECT TBL1.COL AS FOO, TBL2.COL AS BAR FROM TBL1, TBL2 + </programlisting> </informalexample> </para> <para> - A special handling allows fetching "multiple field" - columns (which would otherwise all have the same column - names). For each column of a "multiple field", the - index name is constructed by appending the string "(n)" - where n is the sub-index of the multiple field column, - ranging from 1 to its declared repetition factor. The indices - are NOT zero based, in order to match the nomenclature - used in the respective query syntax. - For a column declared as: + ç¹å¥ãªå¦çã«ãã"è¤æ°ãã£ã¼ã«ã"ã«ã©ã (ãããã¯åãã«ã©ã åãæã + ãã«ã©ã )ãåå¾ãããã¨ãå¯è½ã«ãªãã¾ãã"è¤æ°ãã£ã¼ã«ã"ã®åã«ã© + ã ã«é¢ãã¦ãæ·»ååã¯ãæåå"(n)"ãä»å ãããã¨ã«ããæ§ç¯ããã¾ãã + ãã ããn ã¯è¤æ°ãã£ã¼ã«ãã®ã«ã©ã ã®å¯æ·»åã§ããã1ããå®£è¨æ¸ã¿ã® + å復æ°ã¾ã§ã®ç¯å²ã¨ãªãã¾ããã¯ã¨ãªæ§æã§ä½¿ç¨ããã表è¨ã«ä¸è´ãã + ãããã«æ·»åã¯ã¼ããåºæºã«ãã¦ãã¾ããã + 次ã®ããã«å®£è¨ããã¦ããããã«ã©ã ã®å ´åã <informalexample> <programlisting role="sesam"> -CREATE TABLE ... ( ... MULTI(3) INT )</programlisting> +CREATE TABLE ... ( ... MULTI(3) INT ) + </programlisting> </informalexample> - the associative indices used for the individual "multiple field" - columns would be <literal>"multi(1)"</literal>, - <literal>"multi(2)"</literal>, and - <literal>"multi(3)"</literal> respectively. + åã ã®"è¤æ°ãã£ã¼ã«ã"ã«ã©ã ã«é¢ãã¦é£æ³æ·»åã¯ããããã + <literal>"multi(1)"</literal>,<literal>"multi(2)"</literal>, + <literal>"multi(3)"</literal> ã«ãªãã¾ãã </para> <para> - Subsequent calls to <function>sesam_fetch_array</function> would - return the next (or prior, or n'th next/prior, depending on - the scroll attributes) row in the result set, or - <literal>FALSE</literal> if there are no - more rows. + <function>sesam_fetch_array</function> ãç¶ãã¦ã³ã¼ã«ããå ´åãçµ + æéåã®æ¬¡ã®(ã¹ã¯ãã¼ã«å±æ§ã«å¿ãã¦åã¾ãã¯nçªç®ã®å/å¾)ã¬ã³ã¼ãã¾ + ãã¯ã¬ã³ã¼ãããããªãå ´åã« <literal>FALSE</literal>ãè¿ãã¾ãã </para> <example> <title>SESAM åå¾é å</title> @@ -1809,9 +1793,9 @@ " WHERE LASTNAME='".strtoupper($name)."'\n". " ORDER BY FIRSTNAME", 1); if (! $result) { - ... error ... + ... ã¨ã©ã¼ ... } -// print the table: +// ãã¼ãã«ãåºåãã¾ã print "<TABLE BORDER>\n"; while (($row = sesam_fetch_array ($result)) && count($row) > 0) { print " <TR>\n"; @@ -1826,8 +1810,7 @@ </programlisting> </example> <para> - See also: <function>sesam_fetch_row</function> which returns - an indexed array. + æ·»åé åãè¿ã <function>sesam_fetch_row</function> ãåç §ä¸ããã </para> </refsect1> </refentry> @@ -1857,79 +1840,90 @@ ããéã«"ã¹ã¯ãã¼ã«å¯è½ãª"ã«ã¼ã½ã«ãè¦æ±ãããå ´åã®ã¿) </para> <para> - <parameter>whence</parameter> sets the global default value - for the scrolling type, it specifies the scroll type - to use in subsequent fetch operations on "scrollable" - cursors, which can be set to the following predefined - constants: + <parameter>whence</parameter> ã¯ããã®å¾ã®"ã¹ã¯ãã¼ã«å"ã«ã¼ã½ã« + ã®åå¾å¦çã§ä½¿ç¨ãããã¹ã¯ãã¼ã«ã®åãæå®ããã¹ã¯ãã¼ã«åã®ã°ãã¼ + ãã«ãªããã©ã«ãå¤ãè¨å®ããæ¬¡ã®ãããªå®ç¾©æ¸ã¿ã®å®æ°ãè¨å®ãã¾ãã <table> - <title>Valid values for <parameter>"whence"</parameter> parameter</title> + <title><parameter>"whence"</parameter> ãã©ã¡ã¼ã¿ã®æå¹ãªå¤</title> <tgroup cols="3"> <thead> <row> - <entry>Value</entry> - <entry>Constant</entry> - <entry>Meaning</entry> + <entry>å¤</entry> + <entry>宿°</entry> + <entry>æå³</entry> </row> </thead> <tbody> <row> - <entry>0</entry> - <entry><literal>SESAM_SEEK_NEXT</literal></entry> - <entry>read sequentially - </entry> + <entry>0</entry> + <entry><literal>SESAM_SEEK_NEXT</literal></entry> + <entry> + é£ç¶çã«èªã¿è¾¼ã + </entry> + </row> + <row> + <entry>1</entry> + <entry><literal>SESAM_SEEK_PRIOR</literal></entry> + <entry> + é£ç¶çã«å¾åãã«èªã + </entry> + </row> + <row> + <entry>1</entry> + <entry><literal>SESAM_SEEK_PRIOR</literal></entry> + <entry> + é£ç¶çã«å¾åãã«èªã¿è¾¼ã (åå¾å¾ãå é¨ããã©ã«ãå¤ã¯ + <literal>SESAM_SEEK_PRIOR</literal>ã«è¨å®ããã¾ã) + </entry> + </row> + <row> + <entry>2</entry> + <entry><literal>SESAM_SEEK_FIRST</literal></entry> + <entry> + æåã®ã¬ã³ã¼ãã«ç§»å(åå¾å¾ãããã©ã«ãå¤ã¯ + <literal>SESAM_SEEK_NEXT</literal>ã«è¨å®ããã¾ã) + </entry> + </row> + <row> + <entry>3</entry> + <entry><literal>SESAM_SEEK_LAST</literal></entry> + <entry> + æå¾ã®ã¬ã³ã¼ãã«ç§»å (åå¾å¾ãããã©ã«ãå¤ã¯ + <literal>SESAM_SEEK_PRIOR</literal>ã«è¨å®ããã¾ã) + </entry> + </row> + <row> + <entry>4</entry> + <entry><literal>SESAM_SEEK_ABSOLUTE</literal></entry> + <entry> + <parameter>offset</parameter> (0ãå é ãåå¾å¾ãå é¨ããã©ã« + ãå¤ã¯ã<literal>SESAM_SEEK_ABSOLUTE</literal> ã«è¨å®ãã¦ä¸ + ãããå é¨ã®ãªãã»ããå¤ã¯ãèªåçã«å¢å ãã¾ã)ã§æå®ããçµ¶ + 対ã¬ã³ã¼ãçªå·ã«ç§»åãã¾ãã + </entry> + </row> + <row> + <entry>5</entry> + <entry><literal>SESAM_SEEK_RELATIVE</literal></entry> + <entry> + ã«ã¬ã³ãã®ã¹ã¯ãã¼ã«ä½ç½®ã«å¯¾ãã¦ç¸å¯¾ä½ç½®ã«ç§»åããã ãã + <parameter>offset</parameter> ã¯æ£ã¾ãã¯è² ã®å¤ãæå®å¯è½ã§ãã + </entry> </row> - <row> - <entry>1</entry> - <entry><literal>SESAM_SEEK_PRIOR</literal></entry> - <entry>read sequentially backwards - </entry> - </row> - <row> - <entry>2</entry> - <entry><literal>SESAM_SEEK_FIRST</literal></entry> - <entry>fetch first row (after fetch, the default - is set to - <literal>SESAM_SEEK_NEXT</literal>)</entry> - </row> - <row> - <entry>3</entry> - <entry><literal>SESAM_SEEK_LAST</literal></entry> - <entry>fetch last row (after fetch, the default is - set to - <literal>SESAM_SEEK_PRIOR</literal>)</entry> - </row> - <row> - <entry>4</entry> - <entry><literal>SESAM_SEEK_ABSOLUTE</literal></entry> - <entry>fetch absolute row number given as - <parameter>offset</parameter> (Zero-based. After - fetch, the default is set to - <literal>SESAM_SEEK_ABSOLUTE</literal>, and the - offset value is auto-incremented)</entry> - </row> - <row> - <entry>5</entry> - <entry><literal>SESAM_SEEK_RELATIVE</literal></entry> - <entry>fetch relative to current scroll position, where - <parameter>offset</parameter> can be a positive or - negative offset value (this also sets the default - "offset" value for subsequent fetches).</entry> - </row> </tbody> </tgroup> </table> </para> <para> - <parameter><optional>offset</optional></parameter> is an - optional parameter which is only evaluated (and required) - if <parameter>whence</parameter> is - either <literal>SESAM_SEEK_RELATIVE</literal> or - <literal>SESAM_SEEK_ABSOLUTE</literal>. + <parameter><optional>offset</optional></parameter> ã¯ããªãã·ã§ã³ + ã®ãã©ã¡ã¼ã¿ã§ããã<parameter>whence</parameter> ã + <literal>SESAM_SEEK_RELATIVE</literal> ã¾ã㯠+ <literal>SESAM_SEEK_ABSOLUTE</literal> ã®ã©ã¡ããã§ããå ´åã«ã®ã¿ + è©ä¾¡ããã¾ã(ã¾ãå¿ è¦ã¨ããã¾ã)ã </para> </refsect1> </refentry> - + <refentry id="function.sesam-free-result"> <refnamediv> <refname>sesam_free_result</refname>
Index: phpdoc/ja/chapters/install.xml diff -u phpdoc/ja/chapters/install.xml:1.17 phpdoc/ja/chapters/install.xml:1.18 --- phpdoc/ja/chapters/install.xml:1.17 Sun Nov 19 15:00:22 2000 +++ phpdoc/ja/chapters/install.xml Wed Dec 20 02:00:59 2000 @@ -2726,7 +2726,7 @@ ãã¨ãã§ãã¾ãã </simpara> <para> - ãã®ã¬ã¤ãã¯ã以ä¸ã®Webãã¼ãã¼ã¸ã®ã¤ã³ã¹ãã¼ã«ã + ãã®ã¬ã¤ãã¯ã以ä¸ã®Webã£Ã¼ãã¼ã¸ã®ã¤ã³ã¹ãã¼ã«ã ãµãã¼ããã¦ãã¾ãã <itemizedlist> <listitem> @@ -2763,28 +2763,32 @@ <listitem> <para> é å¸ãã¡ã¤ã«ã好ããªãã£ã¬ã¯ããªã«å±éãã¦ä¸ããã - "C:\PHP\" ããè¯ãä¾ã§ãã + "C:\PHP\" ããè¯ãä¾ã§ãã </para> </listitem> <listitem> <para> - 'php.ini-dist' ã '%WINDOWS%' ãã£ã¬ã¯ããªã«ã³ãã¼ãã - 'php.ini' ã«ãªãã¼ã ãã¦ä¸ããã - '%WINDOWS%' ãã£ã¬ã¯ããªã¯ãéå¸¸ãæ¬¡ã®ããã«ãªãã¾ãã + 'php.ini-dist' ã Windows 95/98ã®å ´åã¯ã + '%WINDOWS%' ãã£ã¬ã¯ããªãWindows NT ã¾ã㯠Windows + 2000ã®å ´åã¯ã'%SYSTEMROOT%'ãã£ã¬ã¯ããªã³ãã¼ãã + 'php.ini' ã«ãªãã¼ã ãã¦ä¸ããã + '%WINDOWS%' ã¾ã㯠'%SYSTEMROOT%'ãã£ã¬ã¯ + ããªã¯ãéå¸¸ãæ¬¡ã®ããã«ãªãã¾ãã <simplelist> <member>Windows 95/98 ã§ã¯ãc:\windows</member> - <member>NT ãµã¼ãã¼ã§ã¯ãc:\winnt ~ã㯠c:\winnt40</member> + <member>NT\2000 ãµã¼ãã¼ã§ã¯ãc:\winnt ã¾ã㯠c:\winnt40</member> </simplelist> </para> </listitem> <listitem> <para> - 'php.ini' ãã¡ã¤ã«ãç·¨éãã¦ä¸ããã + 'php.ini' ãã¡ã¤ã«ãç·¨éãã¦ä¸ããã <itemizedlist> <listitem> <simpara> - 'extension_dir' ã®è¨å®å¤ã php-install-dir ã¾ã㯠'php_*.dll' ã - ç½®ããå ´æã«å¤æ´ããå¿ è¦ãããã¾ããä¾ãã°ãc:\php ã«ãªãã¾ãã + 'extension_dir' ã®è¨å®å¤ã php-install-dir ã¾ã㯠+ 'php_*.dll' ãç½®ããå ´æã«å¤æ´ããå¿ è¦ãããã¾ãã + ä¾ãã°ãc:\php ã«ãªãã¾ãã </simpara> </listitem> <listitem> @@ -3187,7 +3191,7 @@ è¨å®ããWeb ãµã¼ãã¼ã§PHPã使ç¨ããããã«è¨å®ããã«å¿ è¦ãªæ å ±ãé ãã¾ããIIS 㨠NTã¯ã¼ã¯ã¹ãã¼ã·ã§ã³ã«ããã PWS ã®å ´åãã¹ã¯ãªã ããããè¨å®ãæãããµã¼ãã¼ã®å ¨ãã¼ãã®ãªã¹ãã表示ãããPHPã¹ã¯ - ãªããç¨ãããã³ã°è¿½å ãããã¨æãå ´æã®ãã¼ãã鏿ãããã¨ã + ãªããç¨ãããã³ã°?追å ãããã¨æãå ´æã®ãã¼ãã鏿ãããã¨ã å¯è½ã§ãã </simpara> Index: phpdoc/ja/functions/math.xml diff -u phpdoc/ja/functions/math.xml:1.13 phpdoc/ja/functions/math.xml:1.14 --- phpdoc/ja/functions/math.xml:1.13 Mon Dec 11 13:42:13 2000 +++ phpdoc/ja/functions/math.xml Wed Dec 20 02:00:59 2000 @@ -552,7 +552,7 @@ </funcsynopsis> <para> 弿° hex_string ã«ããæå®ããã 16鲿°ã«ç価㪠10 鲿°ãè¿ãã¾ãã - HexDec 㯠16 鲿°ã表ãæååã 10 鲿°ã«å¤æãã¾ãã + HexDec 㯠16 鲿°ã表ãæååã 10 鲿°ã«å¤æãã¾ãã 夿ã§ããæå¤§ã®æ°åã¯16鲿°ã® 7fffffff ããã㯠10 鲿°ã® 2147483647 ã§ãã </para> @@ -1021,10 +1021,12 @@ </informalexample> </para> <note> - <para> + <simpara> + ãã©ã¡ã¼ã¿ <parameter>precision</parameter> ã¯ãPHP 4ã§ã®ã¿å©ç¨ + å¯è½ã§ãã (訳注ï¼å é¨çãª2鲿°è¡¨ç¾ã¨10鲿°è¡¨ç¾ã®å·®ã«ããçãã丸ã誤差ã®å½±é¿ã«ãã å¿ ãããå°æ°ç¹ä»¥ä¸ã忍äºå ¥ããçµæãè¿ããªããã¨ã«æ³¨æãã¦ä¸ããã) - </para> + </simpara> </note> <simpara> <function>ceil</function> 㨠Index: phpdoc/ja/functions/mhash.xml diff -u phpdoc/ja/functions/mhash.xml:1.5 phpdoc/ja/functions/mhash.xml:1.6 --- phpdoc/ja/functions/mhash.xml:1.5 Thu Oct 26 15:19:21 2000 +++ phpdoc/ja/functions/mhash.xml Wed Dec 20 02:00:59 2000 @@ -241,7 +241,7 @@ ãè¿ããã¾ããHMACã¯ãã¡ãã»ã¼ã¸èªè¨¼æã¯ãã¼ã«åºã¥ãããã·ã¥ãã¾ã ã¯æå®ãããã¼ã«åºã¥ãåãªãã¡ãã»ã¼ã¸ãã¤ã¸ã§ã¹ãã§ããmhashã§ãµ ãã¼ãããã¦ããå ¨ã¦ã®ã¢ã«ã´ãªãºã ãHMACã¢ã¼ãã§ä½¿ç¨ã§ããããã§ - ã¯ãªãããµãã¼ãããã¦ããªãå ´åã¯ã¨ã©ã¼ãè¿ãã¾ãã + ã¯ããã¾ãããã¨ã©ã¼ã®å ´åã¯ã¨ã©ã¼ãè¿ããã¾ãã </para> </refsect1> </refentry> Index: phpdoc/ja/functions/sesam.xml diff -u phpdoc/ja/functions/sesam.xml:1.3 phpdoc/ja/functions/sesam.xml:1.4 --- phpdoc/ja/functions/sesam.xml:1.3 Sat Dec 16 19:34:25 2000 +++ phpdoc/ja/functions/sesam.xml Wed Dec 20 02:00:59 2000 @@ -364,14 +364,13 @@ <listitem> <simpara><command>DROP TABLE thename;</command></simpara> <simpara> - SESAMã§ã¯ãin the <command>DROP TABLE</command> - command, the table name must be either followed by - the keyword <literal>RESTRICT</literal> or - <literal>CASCADE</literal>. When specifying - <literal>RESTRICT</literal>, an error is returned if - there are dependent objects (e.g., VIEWs), while with - <literal>CASCADE</literal>, dependent objects will be - deleted along with the specified table. + SESAMã§ã¯ã<command>DROP TABLE</command> ã«ããã¦ãã¼ãã«åã® + å¾ã«ãã¼ãÃÉ <literal>RESTRICT</literal> ã¾ã㯠+ <literal>CASCADE</literal> ã®ã©ã¡ãããå¾ã«ä»å ããå¿ è¦ããã + ã¾ãã<literal>RESTRICT</literal> ãæå®ããå ´åã(VIEWã®ãã + ãª)ä¾åãããªãã¸ã§ã¯ããããå ´åã«ã¨ã©ã¼ãè¿ããã¾ããã¾ãã + <literal>CASCADE</literal> ãæå®ããå ´åãä¾åãããªãã¸ã§ã¯ + ãã¯æå®ãããã¼ãã«ããåé¤ããã¾ãã </simpara> </listitem> </itemizedlist> @@ -379,22 +378,22 @@ </note> <note> <title> - Notes on the use of various SQL types + æ§ã ãªSQLåã使ç¨ããå ´åã®æ³¨æ </title> <para> - SESAM does not currently support the BLOB type. A future - version of SESAM will have support for BLOB. + SESAM ã¯ç¾å¨BLOBåããµãã¼ããã¦ãã¾ãããSESAMã®å°æ¥ã®ãã¼ã¸ã§ã³ + ã¯ãBLOBããµãã¼ãããäºå®ã§ãã </para> <para> - At the PHP interface, the following type conversions are - automatically applied when retrieving SQL fields: + PHP ã¤ã³ã¿ã¼ãã§ã¼ã¹ã§ã¯ãSQLãã£ã¼ã«ããåå¾ããéã«æ¬¡ã®å夿ã + èªåçã«é©ç¨ããã¾ãã <table> - <title>SQL to PHP Type Conversions</title> + <title>SQL ãã PHP ã¸ã®å夿</title> <tgroup cols="2"> <thead> <row> - <entry>SQL Type</entry> - <entry>PHP Type</entry> + <entry>SQL å</entry> + <entry>PHP å</entry> </row> </thead> <tbody> @@ -417,24 +416,23 @@ </tbody> </tgroup> </table> - When retrieving a complete row, the result is returned as an - array. Empty fields are not filled in, so you will have to - check for the existence of the individual fields yourself - (use <function>isset</function> or - <function>empty</function> to test for empty fields). - That allows more user control over the appearance of empty - fields (than in the case of an empty string as the - representation of an empty field). + ã¬ã³ã¼ãå ¨ä½ãåå¾ããéãçµæã¯é åã¨ãã¦è¿ããã¾ãã空ã®ãã£ã¼ + ã«ãã«ã¯å¤ãå ¥ã£ã¦ããªããããåã ã®ãã£ã¼ã«ãèªä½ã®åå¨ã調ã¹ã + å¿ è¦ãããã¾ã(空ã®ãã£ã¼ã«ããã©ãã調ã¹ãã«ã¯ã + <function>isset</function> ã¾ã㯠<function>empty</function> ã使 + ç¨ãã¦ä¸ãã) ããã®ææ³ã¯ã(空ã®ãã£ã¼ã«ãã®è¡¨ç¾ã¨ãã¦åã®æåå + ã使ç¨ããããã)空ã®ãã£ã¼ã«ãã®è¦ãæ¹ãã¦ã¼ã¶ãå¶å¾¡ãããã¨ãå¯ + è½ã¨ãªãã¾ãã </para> </note> <note> - <title>Support of SESAM's "multiple fields" feature</title> + <title>SESAM ã® "è¤æ°ãã£ã¼ã«ã" æ©è½ã®ãµãã¼ã</title> <para> - The special "multiple fields" feature of SESAM allows a column to - consist of an array of fields. Such a "multiple field" column can - be created like this: + SESAMç¹æã®"è¤æ°ãã£ã¼ã«ã"æ©è½ã«ããè¤æ°ã®ãã£ã¼ã«ãã®é åãã㪠+ ãã«ã©ã ã使ç¨ãããã¨ãå¯è½ã§ãã"è¤æ°ãã£ã¼ã«ã"ã«ã©ã äºã¯ã次 + ã®ããã«ä½æå¯è½ã§ãã <example> - <title>Creating a "multiple field" column</title> + <title>"è¤æ°ãã£ã¼ã«ã"ã«ã©ã ã使ãã</title> <programlisting role="sesam"> CREATE TABLE multi_field_test ( @@ -443,32 +441,30 @@ ) </programlisting> </example> - and can be filled in using: + ä¸ã®ã¬ã³ã¼ãã«æ¬¡ã®ããã«ä»£å ¥ãããã¨ãã§ãã¾ãã <example> - <title>Filling a "multiple field" column</title> + <title>"è¤æ°ãã£ã¼ã«ã"ã«ã©ã ã«ä»£å ¥ãã</title> <programlisting role="sesam"> INSERT INTO multi_field_test ( pkey, multi(2..3) ) VALUES ( 'Second', <'first_val','second_val'>) </programlisting> </example> - Note that (like in this case) leading empty sub-fields are ignored, - and the filled-in values are collapsed, so that in the above - example the result will appear as multi(1..2) instead of - multi(2..3). + (ãã®å ´åã®ããã«)å é ã®ç©ºã®ãµããã£ã¼ã«ãã¯ç¡è¦ãããä»£å ¥ããã + å¤ã¯è©°ãããããã¨ã«æ³¨æãã¦ä¸ããããã®ãããä¸è¨ã®ä¾ã®çµæã¯ã + multi(2..3) ã§ã¯ãªããmulti(1..2) ã¨ãªãã¾ãã </para> <para> - When retrieving a result row, "multiple columns" are accessed like - "inlined" additional columns. In the example above, "pkey" will have - the index 0, and the three "multi(1..3)" columns will be accessible - as indices 1 through 3. + çµæã¬ã³ã¼ããåå¾ããéã"è¤æ°ã«ã©ã "ã¯"ã¤ã³ã©ã¤ã³ã®"ä»å ã«ã©ã + ã®ããã«ã¢ã¯ã»ã¹ããã¾ããä¸ã®ã«ããã¦ã"pkey" ã¯æ·»å0ãæãã3㤠+ ã®"multi(1..3)" ã«ã©ã ã¯æ·»å1ãã3ã§ã¢ã¯ã»ã¹å¯è½ã§ãã </para> </note> <para> - For specific SESAM details, please refer to - <ulink url="&url.sesam.en;">the SESAM/SQL-Server - documentation (english)</ulink> or - <ulink url="&url.sesam.de;">the SESAM/SQL-Server documentation (german)</ulink>, - both available online, or use the respective manuals. + SESAMåºæã®äºé ã«ã¤ãã¦è©³ç´°ã¯ã<ulink url="&url.sesam.en;">the + SESAM/SQL-Serverããã¥ã¡ã³ã(è±èª)</ulink> ã¾ã㯠+ <ulink url="&url.sesam.de;">SESAM/SQL-Server ããã¥ã¡ã³ã(ãã¤ãèª) + </ulink> ãåç §ä¸ãããå ±ã«ãªã³ã©ã¤ã³ã§åç §å¯è½ã§ãããããã¯ãé© + å½ãªããã¥ã¢ã«ã使ç¨ãã¦ä¸ããã </para> </partintro> @@ -488,44 +484,43 @@ </funcprototype> </funcsynopsis> <para> - Returns <literal>TRUE</literal> if a connection to the SESAM database was made, or - <literal>FALSE</literal> on error. + SESAMãã¼ã¿ãã¼ã¹ã¸ã®æ¥ç¶ã使ãããå ´åã« + <literal>TRUE</literal>ãã¨ã©ã¼ã®å ´åã« <literal>FALSE</literal> + ãè¿ãã¾ãã </para> <para> - <function>sesam_connect</function> establishes a connection to an - SESAM database handler task. The connection is always - "persistant" in the sense that only the very first invocation will - actually load the driver from the configured SESAM OML PLAM - library. Subsequent calls will reuse the driver and will - immediately use the given catalog, schema, and user. + <function>sesam_connect</function> ã¯SESAMãã¼ã¿ãã¼ã¹ãã³ãã©ã¿ + ã¹ã¯ã¸ã®æ¥ç¶ã確ç«ãã¾ããæ¥ç¶ã¯ãæåã®èµ·åæã«ã®ã¿è¨å®ããã + SESAM OML PLAMã©ã¤ãã©ãªããå®éã«ãã©ã¤ãããã¼ããããã¨ããæ + å³ã§å¸¸ã«"æç¶ç"ã§ãããã®å¾ã®ã³ã¼ã«ã§ã¯ããã©ã¤ãã¯åå©ç¨ããã + æå®ãã«ã¿ãã°ãã¹ãã¼ããã¦ã¼ã¶ãç´ã¡ã«ä½¿ç¨ããã¾ãã </para> <para> - When creating a database, the <parameter>"catalog"</parameter> - name is specified in the - SESAM configuration directive <command>//ADD-SQL-DATABASE-CATALOG-LIST - ENTRY-1 = *CATALOG(CATALOG-NAME = catalogname,...)</command> + ãã¼ã¿ãã¼ã¹ã使ããéã<parameter>"catalog"</parameter> åã¯ã + SESAMè¨å®ãã£ã¬ã¯ãã£ã <command>//ADD-SQL-DATABASE-CATALOG-LIST + ENTRY-1 = *CATALOG(CATALOG-NAME = catalogname,...)</command> ã§æ + å®ãã¾ãã </para> <para> - The <parameter>"schema"</parameter> references the desired - database schema (see SESAM handbook). + <parameter>"schema"</parameter> ã«ã¯é¸æãããã¼ã¿ãã¼ã¹ã¹ãã¼ã + ãæå®ãã¾ãã(SESAMãã³ãããã¯ãåç §) </para> <para> - The <parameter>"user"</parameter> argument references one of the - users which are allowed to access this - <parameter>"catalog"</parameter> / <parameter>"schema"</parameter> - combination. Note that <parameter>"user"</parameter> is completely - independent from both the system's user id's and from HTTP - user/password protection. It appears in the SESAM configuration - only. + <parameter>"user"</parameter> 弿°ã«ã¯ããã® + <parameter>"catalog"</parameter> / + <parameter>"schema"</parameter> ã®çµã«ã¢ã¯ã»ã¹å¯è½ãªã¦ã¼ã¶ã®ä¸äºº + ãæå®ãã¾ãã<parameter>"user"</parameter>ã¯ãã·ã¹ãã ã®ã¦ã¼ã¶ID + ã¨HTTPã¦ã¼ã¶/ãã¹ã¯ã¼ãä¿è·ããå ±ã«å®å ¨ã«ç¬ç«ãã¦ããã¨ã«æ³¨æã㦠+ ä¸ãããSESAMè¨å®ã«ã®ã¿ä½¿ç¨ããã¾ãã </para> <para> - See also <function>sesam_disconnect</function>. + <function>sesam_disconnect</function>ãåç §ä¸ããã <example> - <title>Connect to a SESAM database</title> + <title>SESAM ãã¼ã¿ãã¼ã¹ã¸ã®æ¥ç¶</title> <programlisting role="php"> <?php if (! sesam_connect ("mycatalog", "myschema", "otto") - die("Unable to connect to SESAM"; + die("SESAMã«æ¥ç¶ã§ãã¾ãã"; ?> </programlisting> </example> @@ -547,34 +542,34 @@ </funcprototype> </funcsynopsis> <para> - Returns: always <literal>TRUE</literal>. + è¿ãå¤: 常㫠<literal>TRUE</literal>ã </para> <para> - <function>sesam_disconnect</function> closes the logical link to a - SESAM database (without actually disconnecting and unloading the - driver). + <function>sesam_disconnect</function> ã¯(å®éã«æ¥ç¶ãæã«ãããã + ãã©ã¤ããã¢ã³ãã¼ããããã¨ãªã)SESAMãã¼ã¿ãã¼ã¹ã¸ã®è«çãªã³ã¯ + ãéãã¾ãã </para> <para> - Note that this isn't usually necessary, as the open connection is - automatically closed at the end of the script's execution. - Uncommitted data will be discarded, because an implicit - <function>sesam_rollback</function> is executed. + ãªã¼ãã³ãããæ¥ç¶ã¯ã¹ã¯ãªããã®å®è¡çµäºæã«éããããããããã® + 颿°ã¯é常ä¸è¦ã§ããã³ãããããã¦ããªããã¼ã¿ã¯ãæé»ã®ãã¡ã« + <function>sesam_rollback</function> ãå®è¡ããããããç ´æ£ããã¾ + ãã </para> <para> - <function>sesam_disconnect</function> will not close the - persistent link, it will only invalidate the currently defined - <parameter>"catalog"</parameter>, <parameter>"schema"</parameter> - and <parameter>"user"</parameter> triple, so that any sesam - function called after <function>sesam_disconnect</function> will - fail. + <function>sesam_disconnect</function> ã¯ãæç¶çãªãªã³ã¯ãéããã + ç¾å¨ãå®ç¾©ããã¦ãã <parameter>"catalog"</parameter>ã + <parameter>"schema"</parameter>ã<parameter>"user"</parameter> ã® + çµãç¡å¹ã«ããã ãã§ãããã®ããã + <function>sesam_disconnect</function> ã®å¾ã§ã³ã¼ã«ããã SESAM é¢ + æ°ã¯å¤±æãã¾ãã </para> <para> - See also: <function>sesam_connect</function>. + <function>sesam_connect</function>ãåç §ä¸ããã <example> - <title>Closing a SESAM connection</title> + <title>SESAM æ¥ç¶ãéãã</title> <programlisting role="php"> if (sesam_connect ("mycatalog", "myschema", "otto")) { -... some queries and stuff ... +... ã¯ã¨ãªç ... sesam_disconnect(); } </programlisting> </example> @@ -597,35 +592,35 @@ </funcprototype> </funcsynopsis> <para> - Returns: <literal>TRUE</literal> if the values are valid, and the - <function>settransaction</function> operation was successful, - <literal>FALSE</literal> otherwise. + è¿ãå¤: <function>settransaction</function> å¦çãæåãã¦ã + æå¹ãªå ´åã« <literal>TRUE</literal>ããã®ä»ã®å ´åã« + <literal>FALSE</literal>ã </para> <para> - <function>sesam_settransaction</function> overrides the default - values for the "isolation level" and "read-only" transaction - parameters (which are set in the SESAM configuration file), in - order to optimize subsequent queries and guarantee database - consistency. The overridden values are used for the next transaction - only. + <function>sesam_settransaction</function> ã¯ã(SESAMè¨å®ãã¡ã¤ã« + ã§è¨å®ããã)ãã©ã³ã¶ã¯ã·ã§ã³ãã©ã¡ã¼ã¿ "isolation level" 㨠+ "read-only" ã®ããã©ã«ãå¤ã䏿¸ããã¾ããããã¯ãé£ç¶ããã¯ã¨ãª + ãæé©åãããã¼ã¿ãã¼ã¹ã®çµ±ä¸æ§ãä¿è¨¼ããããã§ãã䏿¸ãããã + å¤ã¯ã次ã®ãã©ã³ã¶ã¯ã·ã§ã³ã§ã®ã¿ä½¿ç¨ããã¾ãã </para> <para> - <function>sesam_settransaction</function> can only be called before - starting a transaction, not after the transaction has been started - already. + <function>sesam_settransaction</function> ã¯ããã©ã³ã¶ã¯ã·ã§ã³ã + éå§ããåã«ã®ã¿ã³ã¼ã«ãããã¨ãå¯è½ã§ãæ¢ã«ãã©ã³ã¶ã¯ã·ã§ã³ãé + å§ããã¦ããå ´åã«ã¯ãã³ã¼ã«ãããã¨ãã§ãã¾ããã </para> <para> - To simplify the use in php scripts, the following constants have - been predefined in php (see SESAM handbook for detailed - explanation of the semantics): + PHPã¹ã¯ãªããã®ä½¿ç¨ãç°¡åã«ããã«ã¯ã次ã®å®æ°ããPHPã§å®ç¾©ãã㦠+ ãã¾ãã(æå³ã®è©³ç´°ã«ã¤ãã¦ã¯SESAMãã³ãããã¯ãåç §) <table> - <title>Valid values for <parameter>"Isolation_Level"</parameter> parameter</title> + <title> + <parameter>"Isolation_Level"</parameter>ãã©ã¡ã¼ã¿ã®æå¹ãªå¤ + </title> <tgroup cols="3"> <thead> <row> - <entry>Value</entry> - <entry>Constant</entry> - <entry>Meaning</entry> + <entry>å¤</entry> + <entry>宿°</entry> + <entry>æå³</entry> </row> </thead> <tbody> @@ -653,13 +648,15 @@ </tgroup> </table> <table> - <title>Valid values for <parameter>"Read_Only"</parameter> parameter</title> + <title> + <parameter>"Read_Only"</parameter> ãã©ã¡ã¼ã¿ã®æå¹ãªå¤ + </title> <tgroup cols="3"> <thead> <row> - <entry>Value</entry> - <entry>Constant</entry> - <entry>Meaning</entry> + <entry>å¤</entry> + <entry>宿°</entry> + <entry>æå³</entry> </row> </thead> <tbody> @@ -678,13 +675,13 @@ </table> </para> <para> - The values set by <function>sesam_settransaction</function> will - override the default setting specified in the <link - linkend="ini.sesam-configfile">SESAM configuration file</link>. + <function>sesam_settransaction</function> ã«ããè¨å®ãããå¤ã¯ã + <link linkend="ini.sesam-configfile">SESAM è¨å®ãã¡ã¤ã«</link>ã§ + æå®ãããããã©ã«ãè¨å®ã䏿¸ããã¾ãã </para> <para> <example> - <title>Setting SESAM transaction parameters</title> + <title>SESAM ãã©ã³ã¶ã¯ã·ã§ã³ãã©ã¡ã¼ã¿ãè¨å®ãã</title> <programlisting role="php"> <?php sesam_settransaction(SESAM_TXISOL_REPEATABLE_READ, @@ -699,7 +696,9 @@ <refentry id="function.sesam-commit"> <refnamediv> <refname>sesam_commit</refname> - <refpurpose>SESAMãã¼ã¿ãã¼ã¹ã¸ã®å¾ æ©ä¸ã®æ´æ°å¦çãã³ããããã</refpurpose> + <refpurpose> + SESAMãã¼ã¿ãã¼ã¹ã¸ã®å¾ æ©ä¸ã®æ´æ°å¦çãã³ããããã + </refpurpose> </refnamediv> <refsect1> <title>説æ</title> @@ -718,20 +717,17 @@ ã¸ã®æ´æ°å¦çãã³ããããã¾ãã </para> <para> - ä»ã®ãã¼ã¿ãã¼ã¹ã®ããã«"èªåã³ããã"æ©è½ããªãããã - - Note that there is no "auto-commit" feature as in other databases, - as it could lead to accidental data loss. Uncommitted data at - the end of the current script (or when calling - <function>sesam_disconnect</function>) will be discarded by an - implied <function>sesam_rollback</function> call. + ä»ã®ãã¼ã¿ãã¼ã¹ã®ããã«"èªåã³ããã"æ©è½ããªããããäºæ ã«ãã + ãã¼ã¿ã失ãããå¯è½æ§ããããã¨ã«æ³¨æãã¦ä¸ãããã«ã¬ã³ãã®ã¹ã¯ + ãªããå®è¡çµäºæã«ã³ãããããã¦ããªããã¼ã¿ã¯ãæé»ã® + <function>sesam_rollback</function> ã³ã¼ã«ã«ããç ´æ£ããã¾ãã </para> <para> </para> <para> - See also: <function>sesam_rollback</function>. + <function>sesam_rollback</function>ãåç §ä¸ããã <example> - <title>Committing an update to the SESAM database</title> + <title>SESAM ãã¼ã¿ãã¼ã¹ã®æ´æ°ãã³ããããã</title> <programlisting role="php"> <?php if (sesam_connect ("mycatalog", "myschema", "otto")) { @@ -750,7 +746,9 @@ <refentry id="function.sesam-rollback"> <refnamediv> <refname>sesam_rollback</refname> - <refpurpose>Discard any pending updates to the SESAM database</refpurpose> + <refpurpose> + SESAMãã¼ã¿ãã¼ã¹ã«å¯¾ããå¾ æ©ä¸ã®æ´æ°ãç ´æ£ãã + </refpurpose> </refnamediv> <refsect1> <title>説æ</title> @@ -761,24 +759,22 @@ </funcprototype> </funcsynopsis> <para> - Returns: <literal>TRUE</literal> on success, - <literal>FALSE</literal> on errors + è¿ãå¤: æåæã« <literal>TRUE</literal>ãã¨ã©ã¼æã« + <literal>FALSE</literal> </para> <para> - <function>sesam_rollback</function> discards any pending updates to - the database. Also affected are result cursors and result - descriptors. + <function>sesam_rollback</function> ã¯ããã¼ã¿ãã¼ã¹ã¸ã®å¾ æ©ä¸ã® + æ´æ°ãç ´æ£ãã¾ããçµæã«ã¼ã½ã«ã¨çµæè¨è¿°åã夿´ããã¾ãã </para> <para> - At the end of each script, and as part of the - <function>sesam_disconnect</function> function, an implied - <function>sesam_rollback</function> is executed, discarding any - pending changes to the database. + ã¹ã¯ãªããã®çµäºæã«ã<function>sesam_disconnect</function> 颿° + ããæé»ã®ãã¡ã« <function>sesam_rollback</function>ãå®è¡ããã + ãã¼ã¿ãã¼ã¹ã®å¾ æ©ä¸ã®å ¨ã¦ã®å¤æ´ã¯ç ´æ£ããã¾ãã </para> <para> - See also: <function>sesam_commit</function>. + <function>sesam_commit</function>ãåç §ä¸ããã <example> - <title>Discarding an update to the SESAM database</title> + <title>SESAM ãã¼ã¿ãã¼ã¹ã¸ã®æ´æ°ãç ´æ£ãã</title> <programlisting role="php"> <?php if (sesam_connect ("mycatalog", "myschema", "otto")) { @@ -798,7 +794,7 @@ <refentry id="function.sesam-execimm"> <refnamediv> <refname>sesam_execimm</refname> - <refpurpose>Execute an "immediate" SQL-statement</refpurpose> + <refpurpose>SQLå½ä»¤ãç´ã¡ã«å®è¡ãã</refpurpose> </refnamediv> <refsect1> <title>説æ</title> @@ -809,32 +805,30 @@ </funcprototype> </funcsynopsis> <para> - Returns: A SESAM "result identifier" on success, or - <literal>FALSE</literal> on error. + è¿ãå¤: æåæã«SESAM "çµæID"ãã¨ã©ã¼æã« + <literal>FALSE</literal> </para> <para> - <function>sesam_execimm</function> executes an "immediate" - statement (i.e., a statement like UPDATE, INSERT or DELETE which - returns no result, and has no INPUT or OUTPUT variables). - "select type" queries can not be used with - <function>sesam_execimm</function>. Sets the - <parameter>affected_rows</parameter> value for retrieval by the - <function>sesam_affected_rows</function> function. - </para> - <para> - Note that <function>sesam_query</function> can handle both - "immediate" and "select-type" queries. Use - <function>sesam_execimm</function> only if you know beforehand - what type of statement will be executed. - An attempt to use SELECT type queries with - <function>sesam_execimm</function> will return - <literal>$err["sqlstate"] == "42SBW"</literal>. - </para> - <para> - The returned "result identifier" can not be used for retrieving - anything but the <function>sesam_affected_rows</function>; it is - only returned for symmetry with the - <function>sesam_query</function> function. + <function>sesam_execimm</function> ã¯å½ä»¤(ããªãã¡ãUPDATEã + INSERTãDELETEã®ãããªçµæãè¿ããªãå½ä»¤ãå ¥åºå夿°ããªãå½ä»¤)ã + "ç´ã¡ã«"å®è¡ãã¾ãã"select å" ã¯ã¨ãªã¯ã + <function>sesam_execimm</function> ã§ä½¿ç¨ãããã¨ã¯ã§ãã¾ããã + <function>sesam_affected_rows</function> 颿°ã«ããåå¾å¯è½ãª + <parameter>affected_rows</parameter> ã®å¤ãè¨å®ãã¾ãã + </para> + <para> + <function>sesam_query</function> ã¯ã"峿å"ããã³"selectå"ã¯ã¨ + ãªã®ä¸¡æ¹ãå¦çãããã¨ãã§ãããã¨ã«æ³¨æãã¦ä¸ãããå®è¡ãããå½ + 令ã®åãäºåã«åãã£ã¦ããå ´åã«ã®ã¿ + <function>sesam_execimm</function> ã使ç¨ãã¦ä¸ãããSELECTåã¯ã¨ + ãªã使ç¨ãããã¨ããã¨ã<function>sesam_execimm</function>㯠+ <literal>$err["sqlstate"] == "42SBW"</literal>ãè¿ãã¾ãã + </para> + <para> + è¿ããã"çµæID"ã¯ãä½ããåå¾ããéã«ä½¿ç¨ãããã¨ã¯ã§ããã + <function>sesam_affected_rows</function> ãå®è¡ããéã«ä½¿ç¨ãã¾ãã + ãã®IDã¯ã<function>sesam_query</function> 颿°ã¨å¯¾ç§°æ§ãä¿ã¤ãã + ã«ã®ã¿è¿ããã¾ãã </para> <para> <informalexample> @@ -847,8 +841,8 @@ sesam_affected_rows($result)."\n"); </programlisting> </informalexample> - See also: <function>sesam_query</function> and - <function>sesam_affected_rows</function>. + <function>sesam_query</function> ããã³ + <function>sesam_affected_rows</function>ãåç §ä¸ããã </para> </refsect1> </refentry> @@ -856,13 +850,13 @@ <refentry id="function.sesam-query"> <refnamediv> <refname>sesam_query</refname> - <refpurpose>Perform a SESAM SQL query and prepare the result</refpurpose> + <refpurpose>SESAM SQL ã¯ã¨ãªãå®è¡ããçµæãæºåãã</refpurpose> </refnamediv> <refsect1> <title>説æ</title> <funcsynopsis> <funcprototype> - <funcdef>string <function>sesam_query</function></funcdef> + <funcdef>resource <function>sesam_query</function></funcdef> <paramdef>string <parameter>query</parameter></paramdef> <paramdef>boolean <parameter><optional>scrollable</optional></parameter> @@ -870,66 +864,62 @@ </funcprototype> </funcsynopsis> <para> - Returns: A SESAM "result identifier" on success, or - <literal>FALSE</literal> on error. + è¿ãå¤: æåæã«SESAM "çµæID" ã¾ãã¯ã¨ã©ã¼æã« + <literal>FALSE</literal>ã </para> <para> - A "result_id" resource is used by other functions to retrieve the - query results. + "result_id"ãªã½ã¼ã¹ã¯ãã¯ã¨ãªçµæãåå¾ããéã«ä»ã®é¢æ°ã§ä½¿ç¨ãã + ã¾ãã </para> <para> - <function>sesam_query</function> sends a query to the currently - active database on the server. It can execute both - "immediate" SQL statements and "select type" queries. If an - "immediate" statement is executed, then no cursor is allocated, - and any subsequent <function>sesam_fetch_row</function> or - <function>sesam_fetch_result</function> call will return an empty - result (zero columns, indicating end-of-result). - For "select type" statements, a result descriptor and a - (scrollable or sequential, depending on the optional - boolean <parameter>scrollable</parameter> parameter) cursor will - be allocated. If <parameter>scrollable</parameter> is omitted, - the cursor will be sequential. + <function>sesam_query</function> ã¯ãã¯ã¨ãªããµã¼ãä¸ã®ç¾å¨ã¢ã¯ã㣠+ ããªãã¼ã¿ãã¼ã¹ã«éä¿¡ãã¾ãããã®é¢æ°ã¯ã"峿"SQLå½ä»¤ããã³ + "selectå"ã¯ã¨ãªã®ä¸¡æ¹ãå®è¡å¯è½ã§ãã"峿å"å½ä»¤ãå®è¡ããå ´åã + ã«ã¼ã½ã«ã¯ç¢ºä¿ãããããã®å¾ã« + <function>sesam_fetch_row</function> ã¾ã㯠+ <function>sesam_fetch_result</function> ãã³ã¼ã«ãã¦ã空ã®çµæ(çµ + æã®çµç«¯ã示ãã«ã©ã æ°0)ãè¿ããã¾ãã"selectå"å½ä»¤ã®å ´åãçµæ + è¨è¿°åããã³(ãªãã·ã§ã³ã®ãã©ã¡ã¼ã¿ + <parameter>scrollable</parameter>ã®è¨å®ã«ããã¹ã¯ãã¼ã«åã¾ãã¯é£ + ç¶åã®)ã«ã¼ã½ã«ã確ä¿ããã¾ãã<parameter>scrollable</parameter> + ãçç¥ãããå ´åãã«ã¼ã½ã«ã¯é£ç¶åã¨ãªãã¾ãã </para> <para> - When using "scrollable" cursors, the cursor can be freely - positioned on the result set. For each "scrollable" query, - there are global default values for the scrolling type - (initialized to: <literal>SESAM_SEEK_NEXT</literal>) and - the scrolling offset which can either be set once - by <function>sesam_seek_row</function> or - each time when fetching a row using - <function>sesam_fetch_row</function>. + "ã¹ã¯ãã¼ã«å"ã«ã¼ã½ã«ã使ç¨ãã¦ããå ´åãã«ã¼ã½ã«ã¯çµæéåä¸ã + èªç±ã«ç§»åå¯è½ã§ããå"ã¹ã¯ãã¼ã«å"ã¯ã¨ãªã«é¢ãã¦ãã¹ã¯ãã¼ã«å + ã®ã°ãã¼ãã«ããã©ã«ãå¤(<literal>SESAM_SEEK_NEXT</literal>ã«åæ + åããã¦ãã¾ã)㨠<function>sesam_seek_row</function> ã«ããä¸åº¦ + è¨å®ãããã<function>sesam_fetch_row</function> ã使ç¨ãã¦ã¬ã³ã¼ + ããåå¾ãã度ã«è¨å®ããã¹ã¯ãã¼ã«ãªãã»ãããããã¾ãã </para> <para> - For "immediate" statements, the number of affected - rows is saved for retrieval by the - <function>sesam_affected_rows</function> function. + "峿å"å½ä»¤ã®å ´åãä½ç¨ãããã¬ã³ã¼ãã®æ°ãä¿åããã¾ãããã®æ° + ã¯ã<function>sesam_affected_rows</function> 颿°ã§åå¾å¯è½ã§ãã </para> <para> - See also: <function>sesam_fetch_row</function> and - <function>sesam_fetch_result</function>. + <function>sesam_fetch_row</function> ããã³ + <function>sesam_fetch_result</function> ãåç §ä¸ããã <example> <title> - Show all rows of the "phone" table as a html table + "phone"ãã¼ãã«ã®å ¨ã¦ã®ã¬ã³ã¼ããHTMLãã¼ãã«ã¨ãã¦è¡¨ç¤º </title> <programlisting role="php"> <?php if (!sesam_connect("phonedb", "demo", "otto")) - die("cannot connect"); + die("æ¥ç¶ã§ãã¾ãã"); $result = sesam_query("select * from phone"); if (!$result) { $err = sesam_diagnostic(); die($err["errmsg"]); } echo "<TABLE BORDER>\n"; -// Add title header with column names above the result: +// ä¸ã®çµæã«ã©ã åã§ã¿ã¤ãã«ãããã追å ãã if ($cols = sesam_field_array($result)) { echo " <TR><TH COLSPAN=".$cols["count"].">Result:</TH></TR>\n"; echo " <TR>\n"; for ($col = 0; $col < $cols["count"]; ++$col) { $colattr = $cols[$col]; - /* Span the table head over SESAM's "Multiple Fields": */ + /* SESAMã®"è¤æ°ãã¼ãã«"ã«ã¾ããããã¼ãã«ããããå±é: */ if ($colattr["count"] > 1) { echo " <TH COLSPAN=".$colattr["count"].">".$colattr["name"]. "(1..".$colattr["count"].")</TH>\n"; @@ -942,7 +932,7 @@ } do { - // Fetch the result in chunks of 100 rows max. + // æå¤§100ã¬ã³ã¼ãåã®çµæãåå¾ $ok = sesam_fetch_result($result,100); for ($row=0; $row < $ok["rows"]; ++$row) { echo " <TR>\n"; @@ -954,9 +944,9 @@ } echo " </TR>\n"; } -} while ($ok["truncated"]); // while there may be more data +} while ($ok["truncated"]); // ã¾ã ãã¼ã¿ãããå¯è½æ§ãããé echo "</TABLE>\n"; -// free result id +// çµæIDãéæ¾ sesam_free_result($result); ?> </programlisting> @@ -968,7 +958,7 @@ <refentry id="function.sesam-num-fields"> <refnamediv> <refname>sesam_num_fields</refname> - <refpurpose>Return the number of fields/columns in a result set</refpurpose> + <refpurpose>çµæéåã®ãã£ã¼ã«ã/ã«ã©ã æ°ãè¿ã</refpurpose> </refnamediv> <refsect1> <title>説æ</title> @@ -978,23 +968,20 @@ <paramdef>string <parameter>result_id</parameter></paramdef> </funcprototype> </funcsynopsis> + <para> + "selectå"ã¯ã¨ãªã§ <function>sesam_query</function>ãã³ã¼ã«ããå¾ã + ãã®é¢æ°ã«ããçµæã®ã«ã©ã æ°ãå¾ããã¨ãå¯è½ã§ããå ¨ä½ã®ã«ã©ã (ã¾ + ãã¯ãã£ã¼ã«ã)ã®æ°ãè¨è¿°ããæ´æ°ãè¿ãã¾ãã + </para> + <para> + "峿å"å½ä»¤ã®å ´åãå¤0ãè¿ããã¾ããSESAM"è¤æ°ãã£ã¼ã«ã"ã«ã©ã + ã¯ãããããã®æ¬¡å æ¯ã«æ°ãããã¾ããããªãã¡ã"è¤æ°ãã£ã¼ã«ã"ã®3 + ã«ã©ã ã¯ã«ã©ã 3ã¤ã¨ãã¦æ°ãããã¾ãã + </para> <para> - After calling <function>sesam_query</function> with a - "select type" query, this function gives you the - number of columns in the result. - Returns an integer describing the total number of columns (aka. - fields) in the current <parameter>result_id</parameter> result - set or <literal>FALSE</literal> on error. - </para> - <para> - For "immediate" statements, the value zero is returned. The SESAM - "multiple field" columns count as their respective dimension, - i.e., a three-column "multiple field" counts as three columns. - </para> - <para> - See also: <function>sesam_query</function> and - <function>sesam_field_array</function> for a way to distinguish - between "multiple field" columns and regular columns. + "è¤æ°ãã£ã¼ã«ã"ã«ã©ã ãæ¨æºã«ã©ã ãåºå¥ããã«ã¯ã + <function>sesam_query</function> ããã³ + <function>sesam_field_array</function> ãåç §ä¸ããã </para> </refsect1> </refentry> @@ -1003,7 +990,7 @@ <refnamediv> <refname>sesam_field_name</refname> <refpurpose> - Return one column name of the result set + çµæéåã®ã«ã©ã åãè¿ã </refpurpose> </refnamediv> <refsect1> @@ -1016,28 +1003,31 @@ </funcprototype> </funcsynopsis> <para> - Returns the name of a field (i.e., the column name) in the result - set, or <literal>FALSE</literal> on error. + çµæéåã®ä¸ã®ãã£ã¼ã«ãå(ããªãã¡ãã«ã©ã å)ã¾ãã¯ã¨ã©ã¼ã®éã« + <literal>FALSE</literal> ãè¿ãã¾ãã </para> <para> - For "immediate" queries, or for dynamic columns, an empty string - is returned. + "峿å"ã¯ã¨ãªã¾ãã¯åçãªã«ã©ã ã®å ´åãç©ºã®æååãè¿ããã¾ãã </para> - <note><para> - The column index is zero-based, not one-based as in SESAM. - </para></note> + <note> + <para> + ã«ã©ã ã®æ·»åã¯ãSESAMã®ããã«1ããå§ã¾ããã0ããå§ã¾ãã¾ãã + </para> + </note> <para> - See also: <function>sesam_field_array</function>. It provides an - easier interface to access the column names and types, and allows - for detection of "multiple fields". + <function>sesam_field_array</function> ãåç §ä¸ããããã®é¢æ°ã¯ã + ã«ã©ã åããã³åã«ããç°¡åã«ã¢ã¯ã»ã¹ããã¤ã³ã¿ã¼ãã§ã¼ã¹ãæä¾ãã + "è¤æ°ãã£ã¼ã«ã"ã®æ¤åºãå¯è½ã«ãªãã¾ãã </para> </refsect1> </refentry> - + <refentry id="function.sesam-diagnostic"> <refnamediv> <refname>sesam_diagnostic</refname> - <refpurpose>ç´è¿ã®SESAMã³ã¼ã«ã«é¢ããã¹ãã¼ã¿ã¹æ å ±ãè¿ã</refpurpose> + <refpurpose> + ç´è¿ã®SESAMã³ã¼ã«ã«é¢ããã¹ãã¼ã¿ã¹æ å ±ãè¿ã + </refpurpose> </refnamediv> <refsect1> <title>説æ</title> @@ -1048,48 +1038,53 @@ </funcprototype> </funcsynopsis> <para> - Returns an associative array of status and return codes for the - last SQL query/statement/command. - Elements of the array are: + ç´è¿ã®SQLã¯ã¨ãª/å½ä»¤/ã³ãã³ãã«é¢ããã¹ãã¼ã¿ã¹ããã³ã¨ã©ã¼ã³ã¼ã + ã飿³é åã¨ãã¦è¿ãã¾ããé åã®è¦ç´ ã¯æ¬¡ã®ããã«ãªãã¾ãã <table> <title> - Status information returned by <function>sesam_diagnostic</function> + <function>sesam_diagnostic</function>ã«ããè¿ãããã¹ãã¼ã¿ã¹æ å ± </title> <tgroup cols="2"> <thead> <row> - <entry>Element</entry> - <entry>Contents</entry> + <entry>è¦ç´ </entry> + <entry>å 容</entry> </row> </thead> <tbody> <row> - <entry>$array["sqlstate"]</entry> - <entry>5 digit SQL return code (see the SESAM manual for the - description of the possible values of SQLSTATE)</entry> + <entry>$array["sqlstate"]</entry> + <entry> + 5 æ¡ã® SQL ãªã¿ã¼ã³ã³ã¼ã (SQLSTATEã®å¤ã®èª¬æã«ã¤ãã¦ã¯ã + SESAMããã¥ã¢ã«åç §) + </entry> </row> <row> - <entry>$array["rowcount"]</entry> - <entry>number of affected rows in last update/insert/delete - (set after "immediate" statements only) + <entry>$array["rowcount"]</entry> + <entry> + ç´è¿ã®update/insert/deleteã¯ã¨ãªã§ä½ç¨ãããã¬ã³ã¼ãã®æ° + ("峿å"å½ä»¤ã®å¾ã§ã®ã¿è¨å®ããã¾ã) </entry> </row> <row> <entry>$array["errmsg"]</entry> - <entry>"human readable" error message string - (set after errors only) + <entry> + "å¯èªãª" ã¨ã©ã¼ã¡ãã»ã¼ã¸æåå + (ã¨ã©ã¼ã®å¾ã§ã®ã¿è¨å®ããã¾ã) </entry> </row> <row> <entry>$array["errcol"]</entry> - <entry>error column number of previous error - (0-based; or -1 if undefined. Set after errors only) + <entry> + 以åã®ã¨ã©ã¼ã®ã¨ã©ã¼ã«ã©ã çªå· + (0ããå§ã¾ããæªå®ç¾©ã®å ´åã¯-1ãã¨ã©ã¼ã®å¾ã§ã®ã¿è¨å®ããã¾ã) </entry> </row> <row> <entry>$array["errlin"]</entry> - <entry>error line number of previous error - (0-based; or -1 if undefined. Set after errors only) + <entry> + åã®ã¨ã©ã¼ã®ã¨ã©ã¼è¡çªå· + (0ããå§ã¾ããæªå®ç¾©ã®å ´åã¯-1ãã¨ã©ã¼ã®å¾ã§ã®ã¿è¨å®ããã¾ã) </entry> </row> </tbody> @@ -1097,20 +1092,18 @@ </table> </para> <para> - In the following example, a syntax error (E SEW42AE ILLEGAL - CHARACTER) is displayed by including the offending SQL statement - and pointing to the error location: + 次ã®ä¾ã§ã¯ãåé¡ãããSQLå½ä»¤ãå«ã¿ãã¨ã©ã¼ä½ç½®ãæãæ§æã¨ã©ã¼(E + SEW42AE ILLEGAL CHARACTER)ã表示ããã¾ãã <example> - <title>Displaying SESAM error messages with error position</title> + <title>ã¨ã©ã¼ä½ç½®ãä»ãã¦SESAMã¨ã©ã¼ã¡ãã»ã¼ã¸ã表示</title> <programlisting role="php"> <?php -// Function which prints a formatted error message, -// displaying a pointer to the syntax error in the -// SQL statement +// ãã©ã¼ããããããã¨ã©ã¼ã¡ãã»ã¼ã¸ãåºåãã颿° +// SQLå½ä»¤ã«ãããæ§æã¨ã©ã¼ã®å ´æã表示 function PrintReturncode($exec_str) { $err = Sesam_Diagnostic(); - $colspan=4; // 4 cols for: sqlstate, errlin, errcol, rowcount + $colspan=4; // sqlstate, errlin, errcol, rowcount ç¨ã®4ã¤ã®ã«ã©ã if ($err["errlin"] == -1) --$colspan; if ($err["errcol"] == -1) @@ -1124,7 +1117,7 @@ echo "<TR><TD COLSPAN=".$colspan."><PRE>\n"; $errstmt = $exec_str."\n"; for ($lin=0; $errstmt != ""; ++$lin) { - if ($lin != $err["errlin"]) { // $lin is less or greater than errlin + if ($lin != $err["errlin"]) { // $lin ã¯errlinããå°ãããã¾ãã¯å¤§ãã if (! ($i = strchr($errstmt, "\n"))) $i = ""; $line = substr($errstmt, 0, strlen($errstmt)-strlen($i)+1); @@ -1161,7 +1154,7 @@ } if (!sesam_connect("mycatalog", "phoneno", "otto")) - die("cannot connect"); + die("æ¥ç¶ã§ãã¾ãã"); $stmt = "SELECT * FROM phone\n". " WHERE@ LASTNAME='KRAEMER'\n". @@ -1173,8 +1166,8 @@ </example> </para> <para> - See also: <function>sesam_errormsg</function> for simple access to the - error string only + ã¨ã©ã¼æååã«ç°¡åã«ã¢ã¯ã»ã¹ããããã«ã¯ã + <function>sesam_errormsg</function> ãåç §ä¸ããã </para> </refsect1> </refentry> @@ -1198,9 +1191,10 @@ </funcprototype> </funcsynopsis> <para> - Returns a mixed array with the query result entries, optionally - limited to a maximum of <parameter>max_rows</parameter> rows. - Note that both row and column indexes are zero-based. + ã¯ã¨ãªçµæã®ã¨ã³ããªã種ã ã®åã®é åã¨ãã¦è¿ãã¾ãããªãã·ã§ã³ã§ + æå¤§ã¬ã³ã¼ãæ°ã <parameter>max_rows</parameter> ã«å¶éãããã¨ã + å¯è½ã§ããã¬ã³ã¼ãçªå·ããã³ã«ã©ã çªå·ã¯å ±ã«0ããå§ã¾ããã¨ã«æ³¨æ + ãã¦ä¸ããã <table> <title> <function>sesam_fetch_result</function>ã«ããè¿ããã種ã ã®çµæéå @@ -1215,57 +1209,59 @@ <tbody> <row> <entry>int $arr["count"]</entry> - <entry>number of columns in result set (or zero if this was an - "immediate" query)</entry> + <entry> + çµæéåã®ã«ã©ã æ° ("峿å"ã¯ã¨ãªã®å ´åã«0) + </entry> </row> <row> <entry>int $arr["rows"]</entry> - <entry>number of rows in result set (between zero and - <parameter>max_rows</parameter>)</entry> + <entry> + çµæéåã®ã¬ã³ã¼ãæ°(0ã¨<parameter>max_rows</parameter>ã®é) + </entry> </row> <row> <entry>boolean $arr["truncated"]</entry> - <entry><literal>TRUE</literal> if the number of rows was at least - <parameter>max_rows</parameter>, <literal>FALSE</literal> otherwise. Note - that even when this is <literal>TRUE</literal>, the next - <function>sesam_fetch_result</function> call may return - zero rows because there are no more result entries. - </entry> + <entry> + ã¬ã³ã¼ãæ°ã<parameter>max_rows</parameter>以ä¸ã®å ´åã« + <literal>TRUE</literal>ãããã§ãªãå ´åã« + <literal>FALSE</literal>ãããã <literal>TRUE</literal>ã§ãª + ãå ´åã§ããçµæã¨ã³ããªã¯ãããªãããã«æ¬¡ã® + <function>sesam_fetch_result</function> ã¯ã¬ã³ã¼ããè¿ããªã + å¯è½æ§ãããã¾ãã + </entry> </row> <row> <entry>mixed $arr[col][row]</entry> - <entry>result data for all the fields at - row(<literal>row</literal>) and - column(<literal>col</literal>), (where the integer - index <literal>row</literal> is - between 0 and <literal>$arr["rows"]-1</literal>, and - <literal>col</literal> is between 0 - and <literal>$arr["count"]-1</literal>). Fields - may be empty, so you must check for the existence of a - field by using the php <function>isset</function> - function. The type of the returned fields depend on the - respective SQL type declared for its column (see <link - linkend="ref.sesam">SESAM overview</link> for the - conversions applied). SESAM "multiple - fields" are "inlined" and treated like a sequence - of columns. + <entry> + ã¬ã³ã¼ã(<literal>row</literal>) ããã³ + ã«ã©ã (<literal>col</literal>)ã«ããå ¨ã¦ã®ãã£ã¼ã«ãã®çµæãã¼ + ã¿ã(æ´æ°ã®ã¬ã³ã¼ãçªå·<literal>row</literal>ã¯0ãã + <literal>$arr["rows"]-1</literal>ã®éã§ããã + <literal>col</literal> 㯠0 ãã + <literal>$arr["count"]-1</literal>ã®éã§ã)ããã£ã¼ã«ãã¯ç©º + ã§ããå¯è½æ§ãããããã®ãããPHPã® + <function>isset</function> 颿°ã使ç¨ãã¦ãã£ã¼ã«ããåå¨ã + ããã©ãã確èªããå¿ è¦ãããã¾ããè¿ããããã£ã¼ã«ãã®åã¯ã + ãã®ã«ã©ã ã®SQLå宣è¨(é©ç¨ããã夿ã«ã¤ãã¦ã¯<link + linkend="ref.sesam">SESAM æ¦è¦</link>åç §)ã«ä¾åãã¾ãã + SESAM "è¤æ°ãã£ã¼ã«ã" ã¯"ã¤ã³ã©ã¤ã³"ã§ãããã«ã©ã ã®çªå·ã¨ + åæ§ã«å¦çããã¾ãã </entry> </row> </tbody> </tgroup> </table> - Note that the amount of memory used up by a large query may be - gigantic. Use the <parameter>max_rows</parameter> parameter to - limit the maximum number of rows returned, unless you are - absolutely sure that your result will not use up all available - memory. + 大ããªã¯ã¨ãªã§ä½¿ç¨ãããã¡ã¢ãªã®æå¤§å¤ã¯ã巨大ãªãã®ã«ãªãå¯è½æ§ + ããããã¨ã«æ³¨æãã¦ä¸ãããçµæãå©ç¨å¯è½ãªå ¨ã¡ã¢ãªãæ¶è²»ããªã + ãã¨ã確å®ã§ããå ´å以å¤ã¯ãè¿ãããã¬ã³ã¼ãæ°ã®æå¤§å¤ãå¶éãã + ããã« <parameter>max_rows</parameter> ãã©ã¡ã¼ã¿ã使ç¨ãã¦ä¸ããã </para> <para> - See also: <function>sesam_fetch_row</function>, and - <function>sesam_field_array</function> to check for "multiple - fields". See the description of the - <function>sesam_query</function> function for a complete example - using <function>sesam_fetch_result</function>. + "è¤æ°ãã£ã¼ã«ã"ã確èªããããã« + <function>sesam_fetch_row</function>ããã³ + <function>sesam_field_array</function> ãåç §ä¸ããã + <function>sesam_fetch_result</function>ã®å®å ¨ãªä¾ã«ã¤ãã¦ã¯ã + <function>sesam_query</function> 颿°ã®èª¬æãåç §ä¸ããã </para> </refsect1> </refentry> @@ -1286,31 +1282,30 @@ </funcprototype> </funcsynopsis> <para> - <parameter>result_id</parameter> is a valid result id returned by - <function>sesam_query</function>. + <parameter>result_id</parameter> ã¯ã + <function>sesam_query</function> ã«ããè¿ãããæå¹ãªçµæIDã§ãã </para> <para> - Returns the number of rows affected by a query associated with - <parameter>result_id</parameter>. + <parameter>result_id</parameter> ã«é¢é£ããã¯ã¨ãªã«ããä½ç¨ããã + ã¬ã³ã¼ãæ°ãè¿ãã¾ãã </para> <para> - The <function>sesam_affected_rows</function> function can only - return useful values when used in combination with "immediate" SQL - statements (updating operations like <literal>INSERT</literal>, - <literal>UPDATE</literal> and <literal>DELETE</literal>) because - SESAM does not deliver any "affected rows" information for "select - type" queries. - The number returned is the number of affected rows. + <function>sesam_affected_rows</function> 颿°ã¯ã"峿å"SQLå½ä»¤ + (<literal>INSERT</literal>ã<literal>UPDATE</literal>ã + <literal>DELETE</literal>ã®ãããªæ´æ°å¦ç)ã®çµåãã§ä½¿ç¨ãããå ´ + åã«ã®ã¿æç¨ãªå¤ãè¿ãã¾ããããã¯ãSESAMã"selectå"ã¯ã¨ãªã«é¢ã + ã¦"ä½ç¨ãããã¬ã³ã¼ã"ã«é¢ããæ å ±ãè¿ããªãããã§ããè¿ãããæ° + ã¯ä½ç¨ãããã¬ã³ã¼ãã®æ°ã§ãã </para> <para> - See also: <function>sesam_query</function> and - <function>sesam_execimm</function> + <function>sesam_query</function> ããã³ + <function>sesam_execimm</function> ãåç §ä¸ããã </para> <informalexample> <programlisting role="php"> $result = sesam_execimm ("DELETE FROM PHONE WHERE LASTNAME = '".strtoupper($name)."'"); if (! $result) { - ... error ... + ... ã¨ã©ã¼ ... } print sesam_affected_rows($result). " entries with last name ".$name." deleted.\n" @@ -1333,8 +1328,7 @@ </funcprototype> </funcsynopsis> <para> - Returns the SESAM error message associated with the most - recent SESAM error. + ç´è¿ã®SESAMã¨ã©ã¼ã«é¢é£ãã SESAMã¨ã©ã¼ã¡ãã»ã¼ã¸ãè¿ãã¾ãã </para> <informalexample> <programlisting role="php"> @@ -1343,8 +1337,8 @@ </programlisting> </informalexample> <para> - See also: <function>sesam_diagnostic</function> for the full set - of SESAM SQL status information + SESAM SQLã¹ãã¼ã¿ã¹æ å ±ã®å®å ¨ãªéåã«ã¤ãã¦ã¯ã + <function>sesam_diagnostic</function> ãåç §ä¸ããã </para> </refsect1> </refentry> @@ -1365,180 +1359,172 @@ </funcprototype> </funcsynopsis> <para> - <parameter>result_id</parameter> is a valid result id returned by - <function>sesam_query</function>. + <parameter>result_id</parameter> ã¯ã + <function>sesam_query</function> ã«ããè¿ãããæå¹ãªçµæIDã§ãã </para> <para> - Returns a mixed associative/indexed array with meta information - (column name, type, precision, ...) about individual columns of the result after the - query associated with <parameter>result_id</parameter>. + <parameter>result_id</parameter>ã«é¢é£ããã¯ã¨ãªã®å¾ã§ãçµæã®åã + ã®ã«ã©ã ã«é¢ããã¡ã¿æ å ±(ã«ã©ã åãåã精度ã...)ãæãã飿³/æ·» + åé åãè¿ãã¾ãã </para> <para> <table> <title> - Mixed result set returned by <function>sesam_field_array</function> + <function>sesam_field_array</function> ã§è¿ãããçµæéå </title> <tgroup cols="2"> <thead> <row> - <entry>Array Element</entry> - <entry>Contents</entry> + <entry>é åè¦ç´ </entry> + <entry>宿°</entry> </row> </thead> <tbody> <row> <entry>int $arr["count"]</entry> - <entry>Total number of columns in result set (or zero if - this was an "immediate" query). SESAM "multiple - fields" are "inlined" and treated like the - respective number of columns. + <entry> + çµæéåã«ãããã«ã©ã æ°ã®åè¨ (ã¾ãã¯"峿å"ã¯ã¨ãªã®å ´åã« + 0)ã SESAM "è¤æ°ãã£ã¼ã«ã"ã¯ã¤ã³ã©ã¤ã³åããã¦ããã対å¿ã + ãã«ã©ã çªå·ã¨åæ§ã«å¦çããã¾ãã </entry> </row> <row> <entry>string $arr[col]["name"]</entry> - <entry>column name for column(<literal>col</literal>), - where <literal>col</literal> is between 0 and - <literal>$arr["count"]-1</literal>. The returned - value can be the empty string (for dynamically - computed columns). SESAM "multiple fields" are - "inlined" and treated like the respective number of - columns, each with the same column name. + <entry> + ã«ã©ã (<literal>col</literal>)ã®ã«ã©ã åããã ãã + <literal>col</literal> ã¯ã0 ãã + <literal>$arr["count"]-1</literal>ã®éã§ããè¿ãããå¤ã¯ã + (åçã«è¨ç®ãããã«ã©ã ã®å ´åã)ç©ºã®æååã¨ãªãå¯è½æ§ããã + ã¾ããSESAM "è¤æ°ãã£ã¼ã«ã" ã¯"ã¤ã³ã©ã¤ã³å"ããã¦ãããã« + ã©ã çªå·ã¨åæ§ã«åãã«ã©ã åã§å¦çããã¾ãã </entry> </row> <row> <entry>string $arr[col]["count"]</entry> - <entry>The "count" attribute describes the repetition - factor when the column has been declared as a - "multiple field". Usually, the "count" attribute is - 1. The first column of a "multiple field" column - however contains the number of repetitions (the - second and following column of the "multiple field" - contain a "count" attribute of 1). This can be used - to detect "multiple fields" in the result set. See - the example shown in the - <function>sesam_query</function> description for a - sample use of the "count" attribute. - </entry> + <entry> + 屿§ "count" ã¯ãã«ã©ã ã"è¤æ°ãã£ã¼ã«ã"ã¨ãã¦å®£è¨ãããå ´ + åã®ç¹°ãè¿ãæ°ãè¨è¿°ãã¾ããé常ã"count"屿§ã¯1ã§ãããããã + "è¤æ°ãã£ã¼ã«ã"ã«ã©ã ã®æåã®ã«ã©ã ã¯ç¹°è¿ãæ°ãæãã¾ãã + ("è¤æ°ãã£ã¼ã«ã"ã®2çªç®ä»¥éã®ã«ã©ã ã¯1ã¨ãã"count"屿§ãæ + ãã¾ã)ãã®å±æ§ã¯ãçµæéåã®ä¸ã§"è¤æ°ãã£ã¼ã«ã"ãæ¤åºãã + ããã«ä½¿ç¨å¯è½ã§ãã"count"屿§ã®ä½¿ç¨ä¾ã«ã¤ãã¦ã¯ã + <function>sesam_query</function> ã®èª¬æã«ç¤ºããã¦ããä¾ãå + ç §ä¸ããã + </entry> </row> <row> <entry>string $arr[col]["type"]</entry> - <entry>php variable type of the data for - column(<literal>col</literal>), where - <literal>col</literal> is between 0 - and <literal>$arr["count"]-1</literal>. The returned - value can be one of - <itemizedlist> - <listitem> - <simpara>"integer"</simpara> - </listitem> - <listitem> - <simpara>"double"</simpara> - </listitem> - <listitem> - <simpara>"string"</simpara> - </listitem> - </itemizedlist> - depending on the SQL type of the result. SESAM - "multiple fields" are "inlined" and treated like the - respective number of columns, each with the same php - type. - </entry> - </row> - <row> - <entry>string $arr[col]["sqltype"]</entry> - <entry>SQL variable type of the column data for - column(<literal>col</literal>), where - <literal>col</literal> is between 0 - and <literal>$arr["count"]-1</literal>. The returned - value can be one of - <itemizedlist> - <listitem> - <simpara>"CHARACTER"</simpara> - </listitem> - <listitem> - <simpara>"VARCHAR"</simpara> - </listitem> - <listitem> - <simpara>"NUMERIC"</simpara> - </listitem> - <listitem> - <simpara>"DECIMAL"</simpara> - </listitem> - <listitem> - <simpara>"INTEGER"</simpara> - </listitem> - <listitem> - <simpara>"SMALLINT"</simpara> - </listitem> - <listitem> - <simpara>"FLOAT"</simpara> - </listitem> - <listitem> - <simpara>"REAL"</simpara> - </listitem> - <listitem> - <simpara>"DOUBLE"</simpara> - </listitem> - <listitem> - <simpara>"DATE"</simpara> - </listitem> - <listitem> - <simpara>"TIME"</simpara> - </listitem> - <listitem> - <simpara>"TIMESTAMP"</simpara> - </listitem> - </itemizedlist> - describing the SQL type of the result. SESAM - "multiple fields" are "inlined" and treated like the - respective number of columns, each with the same SQL - type. + <entry> + ã«ã©ã (<literal>col</literal>)ã«é¢ãããã¼ã¿ã®PHP 夿°åãã + ã ãã<literal>col</literal> 㯠0 㨠+ <literal>$arr["count"]-1</literal> ã®éã§ããå¤ã¯ãçµæã®SQL + åã«åºã¥ã以ä¸ã®ã©ããã¨ãªãã¾ãã + <itemizedlist> + <listitem> + <simpara>"integer"</simpara> + </listitem> + <listitem> + <simpara>"double"</simpara> + </listitem> + <listitem> + <simpara>"string"</simpara> + </listitem> + </itemizedlist> + SESAM "è¤æ°ãã£ã¼ã«ã"ã¯"ã¤ã³ã©ã¤ã³å"ããã¦ãããåãã«ã©ã + æ°ãæããåãPHPåã®å ´åã¨åæ§ã«å¦çããã¾ãã + </entry> + </row> + <row> + <entry>string $arr[col]["sqltype"]</entry> + <entry> + SQL variable type of the column data for + ã«ã©ã (<literal>col</literal>)ã«é¢ããã«ã©ã ãã¼ã¿ã®SQL夿° + åããã ãã<literal>col</literal> 㯠0 ãã + and <literal>$arr["count"]-1</literal>ã®éã«ãªãã¾ããè¿ãã + ãå¤ã¯ãçµæã®SQLåãè¨è¿°ããæ¬¡ã®ã©ããã¨ãªãã¾ãã + <itemizedlist> + <listitem> + <simpara>"CHARACTER"</simpara> + </listitem> + <listitem> + <simpara>"VARCHAR"</simpara> + </listitem> + <listitem> + <simpara>"NUMERIC"</simpara> + </listitem> + <listitem> + <simpara>"DECIMAL"</simpara> + </listitem> + <listitem> + <simpara>"INTEGER"</simpara> + </listitem> + <listitem> + <simpara>"SMALLINT"</simpara> + </listitem> + <listitem> + <simpara>"FLOAT"</simpara> + </listitem> + <listitem> + <simpara>"REAL"</simpara> + </listitem> + <listitem> + <simpara>"DOUBLE"</simpara> + </listitem> + <listitem> + <simpara>"DATE"</simpara> + </listitem> + <listitem> + <simpara>"TIME"</simpara> + </listitem> + <listitem> + <simpara>"TIMESTAMP"</simpara> + </listitem> + </itemizedlist> + SESAM "è¤æ°ãã£ã¼ã«ã"ã¯"ã¤ã³ã©ã¤ã³å"ããã¦ãããåãã«ã©ã + æ°ãåãPHPåã®å ´åã¨åæ§ã«å¦çããã¾ãã </entry> </row> <row> <entry>string $arr[col]["length"]</entry> - <entry>The SQL "length" attribute of the SQL variable in - column(<literal>col</literal>), where - <literal>col</literal> is between 0 and - <literal>$arr["count"]-1</literal>. The "length" - attribute is used with "CHARACTER" and "VARCHAR" SQL - types to specify the (maximum) length of the string - variable. SESAM "multiple fields" are "inlined" and - treated like the respective number of columns, each with - the same length attribute. - </entry> + <entry> + ã«ã©ã (<literal>col</literal>)ã®SQL夿°ã®SQL "length" 屿§ã + ãã ãã<literal>col</literal> ã¯ã0 ãã + <literal>$arr["count"]-1</literal>ã®éã§ãã"length"屿§ã¯ã + æåå夿°ã®(æå¤§)é·ããæå®ããããã«"CHARACTER" ããã³ + "VARCHAR" SQLåãæå®ãã¦ä½¿ç¨ããã¾ãã + SESAM "è¤æ°ãã£ã¼ã«ã"ã¯"ã¤ã³ã©ã¤ã³å"ããã¦ãããåãã«ã©ã + æ°ãåãPHPåã®å ´åã¨åæ§ã«å¦çããã¾ãã + </entry> </row> <row> <entry>string $arr[col]["precision"]</entry> - <entry>The "precision" attribute of the SQL variable in - column(<literal>col</literal>), where - <literal>col</literal> is between 0 and - <literal>$arr["count"]-1</literal>. The "precision" - attribute is used with numeric and time data types. - SESAM "multiple fields" are "inlined" and - treated like the respective number of columns, each with - the same precision attribute. - </entry> + <entry> + ã«ã©ã (<literal>col</literal>ã«ããSQL夿°,ã® + "precision" 屿§ããã ãã<literal>col</literal> ã¯ã0ãã + <literal>$arr["count"]-1</literal>ã®éã§ãã"precision"屿§ + ã¯ãæ°å¤ããã³æéãã¼ã¿åã§ä½¿ç¨ããã¾ãã + SESAM "è¤æ°ãã£ã¼ã«ã"ã¯"ã¤ã³ã©ã¤ã³å"ããã¦ãããåãã«ã©ã + æ°ãåãPHPåã®å ´åã¨åæ§ã«å¦çããã¾ãã + </entry> </row> <row> <entry>string $arr[col]["scale"]</entry> - <entry>The "scale" attribute of the SQL variable in - column(<literal>col</literal>), where - <literal>col</literal> is between 0 and - <literal>$arr["count"]-1</literal>. The "scale" - attribute is used with numeric data types. - SESAM "multiple fields" are "inlined" and - treated like the respective number of columns, each with - the same scale attribute. - </entry> + <entry> + ã«ã©ã (<literal>col</literal>)ã«ããSQL夿°ã®"scale" 屿§ã + ãã ãã<literal>col</literal> ã¯ã0 ãã + <literal>$arr["count"]-1</literal>ã®éã§ãã"scale"屿§ã¯ã + æ°å¤ãã¼ã¿åã§ä½¿ç¨ããã¾ãã + SESAM "è¤æ°ãã£ã¼ã«ã"ã¯"ã¤ã³ã©ã¤ã³å"ããã¦ãããåãã«ã©ã + æ°ãåãPHPåã®å ´åã¨åæ§ã«å¦çããã¾ãã + </entry> </row> </tbody> </tgroup> </table> </para> <para> - See the <function>sesam_query</function> function - for an example of the <function>sesam_field_array</function> use. + <function>sesam_field_array</function> ã®ä½¿ç¨ä¾ã«ã¤ãã¦ã¯ã + <function>sesam_query</function> 颿°ãåç §ä¸ããã </para> </refsect1> </refentry> @@ -1546,7 +1532,7 @@ <refentry id="function.sesam-fetch-row"> <refnamediv> <refname>sesam_fetch_row</refname> - <refpurpose>ã¬ã³ã¼ãã1ä»¶é åã¨ãã¦åå¾</refpurpose> + <refpurpose>1ä»¶åã®ã¬ã³ã¼ããé åã¨ãã¦åå¾</refpurpose> </refnamediv> <refsect1> <title>説æ</title> @@ -1563,132 +1549,137 @@ </funcprototype> </funcsynopsis> <para> - Returns an array that corresponds to the fetched row, - or <literal>FALSE</literal> if there are no more rows. + åå¾ããã¬ã³ã¼ããå«ãé åã¾ãã¯ããã¬ã³ã¼ãããªãå ´åã« + <literal>FALSE</literal> ãè¿ãã¾ãã </para> - <para>The number of columns in the result set is returned in an - associative array element $array["count"]. Because some of the - result columns may be empty, the - <function>count</function> function can not be used on - the result row returned by - <function>sesam_fetch_row</function>. + <para> + çµæéåã®ã«ã©ã æ°ã飿³é åã®è¦ç´ $array["count"] ã§è¿ããã¾ãã + ããã¤ãã®ã«ã©ã ã¯ç©ºã§ããå¯è½æ§ãããããã + <function>sesam_fetch_row</function> ã«ããè¿ãããçµæã¬ã³ã¼ãã« + 対ã㦠<function>count</function> 颿°ã使ç¨ãããã¨ã¯ã§ãã¾ããã </para> <para> - <parameter>result_id</parameter> is a valid result id returned by - <function>sesam_query</function> (select type queries only!). + <parameter>result_id</parameter> ã¯ã + <function>sesam_query</function> (select åã¯ã¨ãªã®ã¿!)ã«ããè¿ã + ããæå¹ãªçµæIDã§ãã </para> <para> - <parameter><optional>whence</optional></parameter> is an - optional parameter for a fetch operation on "scrollable" - cursors, which can be set to the following predefined - constants: + <parameter><optional>whence</optional></parameter> ã¯ã"ã¹ã¯ãã¼ + ã«å"ã«ã¼ã½ã«ã§åå¾å¦çãè¡ãããã®ãªãã·ã§ã³ãã©ã¡ã¼ã¿ã§ã次ã®ã + ããªå®ç¾©æ¸ã¿ã®å®æ°ãè¨å®ãããã¨ãå¯è½ã§ãã <table> - <title>Valid values for <parameter>"whence"</parameter> parameter</title> + <title><parameter>"whence"</parameter> ãã©ã¡ã¼ã¿ã§æå¹ãªå¤</title> <tgroup cols="3"> <thead> <row> - <entry>Value</entry> - <entry>Constant</entry> - <entry>Meaning</entry> + <entry>å¤</entry> + <entry>宿°</entry> + <entry>æå³</entry> </row> </thead> <tbody> <row> - <entry>0</entry> - <entry><literal>SESAM_SEEK_NEXT</literal></entry> - <entry>read sequentially (after fetch, the internal default is - set to <literal>SESAM_SEEK_NEXT</literal>) - </entry> + <entry>0</entry> + <entry><literal>SESAM_SEEK_NEXT</literal></entry> + <entry> + é£ç¶çã«èªã¿è¾¼ã(åå¾å¾ãå é¨ããã©ã«ãå¤ã¯ + <literal>SESAM_SEEK_NEXT</literal>ã«è¨å®ããã¾ã) + </entry> + </row> + <row> + <entry>1</entry> + <entry><literal>SESAM_SEEK_PRIOR</literal></entry> + <entry> + é£ç¶çã«å¾åãã«èªã¿è¾¼ã (åå¾å¾ãå é¨ããã©ã«ãå¤ã¯ + <literal>SESAM_SEEK_PRIOR</literal>ã«è¨å®ããã¾ã) + </entry> + </row> + <row> + <entry>2</entry> + <entry><literal>SESAM_SEEK_FIRST</literal></entry> + <entry> + æåã®ã¬ã³ã¼ãã«ç§»å(åå¾å¾ãããã©ã«ãå¤ã¯ + <literal>SESAM_SEEK_NEXT</literal>ã«è¨å®ããã¾ã) + </entry> + </row> + <row> + <entry>3</entry> + <entry><literal>SESAM_SEEK_LAST</literal></entry> + <entry> + æå¾ã®ã¬ã³ã¼ãã«ç§»å (åå¾å¾ãããã©ã«ãå¤ã¯ + <literal>SESAM_SEEK_PRIOR</literal>ã«è¨å®ããã¾ã) + </entry> + </row> + <row> + <entry>4</entry> + <entry><literal>SESAM_SEEK_ABSOLUTE</literal></entry> + <entry> + <parameter>offset</parameter> (0ãå é ãåå¾å¾ãå é¨ããã©ã« + ãå¤ã¯ã<literal>SESAM_SEEK_ABSOLUTE</literal> ã«è¨å®ãã¦ä¸ + ãããå é¨ã®ãªãã»ããå¤ã¯ãèªåçã«å¢å ãã¾ã)ã§æå®ããçµ¶ + 対ã¬ã³ã¼ãçªå·ã«ç§»åãã¾ãã + </entry> + </row> + <row> + <entry>5</entry> + <entry><literal>SESAM_SEEK_RELATIVE</literal></entry> + <entry> + ã«ã¬ã³ãã®ã¹ã¯ãã¼ã«ä½ç½®ã«å¯¾ãã¦ç¸å¯¾ä½ç½®ã«ç§»åããã ãã + <parameter>offset</parameter> ã¯æ£ã¾ãã¯è² ã®å¤ãæå®å¯è½ã§ãã + </entry> </row> - <row> - <entry>1</entry> - <entry><literal>SESAM_SEEK_PRIOR</literal></entry> - <entry>read sequentially backwards (after fetch, the internal - default is set to <literal>SESAM_SEEK_PRIOR</literal>) - </entry> - </row> - <row> - <entry>2</entry> - <entry><literal>SESAM_SEEK_FIRST</literal></entry> - <entry>rewind to first row (after fetch, the default is set to - <literal>SESAM_SEEK_NEXT</literal>)</entry> - </row> - <row> - <entry>3</entry> - <entry><literal>SESAM_SEEK_LAST</literal></entry> - <entry>seek to last row (after fetch, the default is set to - <literal>SESAM_SEEK_PRIOR</literal>)</entry> - </row> - <row> - <entry>4</entry> - <entry><literal>SESAM_SEEK_ABSOLUTE</literal></entry> - <entry>seek to absolute row number given as - <parameter>offset</parameter> (Zero-based. After fetch, - the internal default is - set to <literal>SESAM_SEEK_ABSOLUTE</literal>, and the - internal offset value is auto-incremented)</entry> - </row> - <row> - <entry>5</entry> - <entry><literal>SESAM_SEEK_RELATIVE</literal></entry> - <entry>seek relative to current scroll position, where - <parameter>offset</parameter> can be a positive or - negative offset value.</entry> - </row> </tbody> </tgroup> </table> - This parameter is only valid for "scrollable" cursors. + ãã®ãã©ã¡ã¼ã¿ã¯ã"ã¹ã¯ãã¼ã«å"ã«ã¼ã½ã«ã§ã®ã¿æå¹ã§ãã </para> <para> - When using "scrollable" cursors, the cursor can be freely - positioned on the result set. If the - <parameter><optional>whence</optional></parameter> parameter - is omitted, the global default values for the scrolling type - (initialized to: <literal>SESAM_SEEK_NEXT</literal>, and - settable by <function>sesam_seek_row</function>) are used. If - <parameter><optional>whence</optional></parameter> is - supplied, its value replaces the global default. - </para> - <para> - <parameter><optional>offset</optional></parameter> is an - optional parameter which is only evaluated (and required) - if <parameter><optional>whence</optional></parameter> is - either <literal>SESAM_SEEK_RELATIVE</literal> or - <literal>SESAM_SEEK_ABSOLUTE</literal>. This - parameter is only valid for "scrollable" cursors. - </para> - <para> - <function>sesam_fetch_row</function> fetches one row of data - from the result associated with the specified result - identifier. The row is returned as an array (indexed by - values between <literal>0</literal> and - <literal>$array["count"]-1</literal>). Fields may be empty, - so you must check for the existence of a field by using the - php <function>isset</function> function. The type of the - returned fields depend on the respective SQL type declared for - its column (see <link linkend="ref.sesam">SESAM - overview</link> for the conversions applied). SESAM "multiple - fields" are "inlined" and treated like a sequence of columns. - </para> - <para> - Subsequent calls to <function>sesam_fetch_row</function> would - return the next (or prior, or n'th next/prior, depending on - the scroll attributes) row in the result set, or - <literal>FALSE</literal> if there are no - more rows. + "ã¹ã¯ãã¼ã«å"ã«ã¼ã½ã«ã使ç¨ãã¦ããå ´åãã«ã¼ã½ã«ã¯çµæéåãèª + ç±ã«ç§»åå¯è½ã§ãã + <parameter><optional>whence</optional></parameter> ãã©ã¡ã¼ã¿ãç + ç¥ãããå ´åãã¹ã¯ãã¼ã«ã®åã«ã¯ãã°ãã¼ãã«ãªããã©ã«ãå¤ + (<literal>SESAM_SEEK_NEXT</literal>ã«åæåããã¦ããã + <function>sesam_seek_row</function>ã§è¨å®å¯è½ã§ã) ã使ç¨ããã¾ãã + <parameter><optional>whence</optional></parameter> ãæå®ãããå ´ + åããã®å¤ã¯ã°ãã¼ãã«ããã©ã«ãå¤ã«ç½®æããã¾ãã + </para> + <para> + <parameter><optional>offset</optional></parameter> ã¯ããªãã·ã§ã³ + ã®ãã©ã¡ã¼ã¿ã§ããã + <parameter><optional>whence</optional></parameter> ã + <literal>SESAM_SEEK_RELATIVE</literal> ã¾ã㯠+ <literal>SESAM_SEEK_ABSOLUTE</literal> ã®ã©ã¡ããã§ããå ´åã«ã®ã¿ + è©ä¾¡ããã¾ã(ããã¦å¿ è¦ã¨ããã¾ã)ããã®ãã©ã¡ã¼ã¿ã¯ã"ã¹ã¯ãã¼ã« + å"ã«ã¼ã½ã«ã§ã®ã¿æå¹ã§ãã + </para> + <para> + <function>sesam_fetch_row</function> ã¯ãæå®ããçµæIDãæãçµæ + ãã1ä»¶åã®ã¬ã³ã¼ãã®ãã¼ã¿ãåå¾ãã¾ããã¬ã³ã¼ãã¯ã( + <literal>0</literal> ãã <literal>$array["count"]-1</literal> ã + æ·»åã¨ãã)é åã¨ãã¦è¿ããã¾ãããã£ã¼ã«ãã¯ç©ºã§ããå¯è½æ§ããã + ãããPHP ã® <function>isset</function> 颿°ã使ç¨ãã¦ãã£ã¼ã«ã + ã®åå¨ã確èªããå¿ è¦ãããã¾ããè¿ããããã£ã¼ã«ãã®åã¯ããã®ã« + ã©ã ã宣è¨ããSQLåã«ä¾åãã¾ãã(é©ç¨ããã夿ã«ã¤ãã¦ã¯ã<link + linkend="ref.sesam">SESAMã®æ¦è¦</link> ãåç §ä¸ããã + SESAM "è¤æ°ãã£ã¼ã«ã" 㯠"ã¤ã³ã©ã¤ã³å" ããã¦ãããé£ç¶ããã«ã© + ã ã®ããã«å¦çããã¾ãã + </para> + <para> + <function>sesam_fetch_row</function> ãé£ãã¦ã³ã¼ã«ããå ´åãçµæ + éåã®æ¬¡ã®(ã¹ã¯ãã¼ã«å±æ§ã«å¿ãã¦åã¾ãã¯nçªç®ã®å/å¾)ã¬ã³ã¼ãã¾ + ãã¯ã¬ã³ã¼ãããããªãå ´åã« <literal>FALSE</literal>ãè¿ãã¾ãã </para> <example> - <title>SESAM fetch rows</title> + <title>SESAM ã¬ã³ã¼ããåå¾</title> <programlisting role="php"> <?php $result = sesam_query ("SELECT * FROM phone\n". " WHERE LASTNAME='".strtoupper($name)."'\n". " ORDER BY FIRSTNAME", 1); if (! $result) { - ... error ... + ... ã¨ã©ã¼ ... } -// print the table in backward order +// éé ã«ãã¼ãã«ãåºå print "<TABLE BORDER>\n"; $row = sesam_fetch_row ($result, SESAM_SEEK_LAST); while (is_array($row)) { @@ -1697,7 +1688,7 @@ print " <TD>".htmlspecialchars($row[$col])."</TD>\n"; } print " </TR>\n"; - // use implied SESAM_SEEK_PRIOR + // æé»ã® SESAM_SEEK_PRIOR ãä½¿ç¨ $row = sesam_fetch_row ($result); } print "</TABLE>\n"; @@ -1706,9 +1697,9 @@ </programlisting> </example> <para> - See also: <function>sesam_fetch_array</function> which returns - an associative array, and <function>sesam_fetch_result</function> - which returns many rows per invocation. + 飿³é åãè¿ã <function>sesam_fetch_array</function>ãããã¦ã + ä¸åº¦ã«å¤ãã®ã¬ã³ã¼ããè¿ã + <function>sesam_fetch_result</function> ãåç §ä¸ããã </para> </refsect1> </refentry> @@ -1733,73 +1724,66 @@ </funcprototype> </funcsynopsis> <para> - Returns an array that corresponds to the fetched row, - or <literal>FALSE</literal> if there are no more rows. + åå¾ããã¬ã³ã¼ãã«å¯¾å¿ããé åã¾ãã¯ã¬ã³ã¼ãããããªãå ´åã«ã¯ + <literal>FALSE</literal> ãè¿ãã¾ãã </para> <para> - <function>sesam_fetch_array</function> is an alternative - version of <function>sesam_fetch_row</function>. Instead - of storing the data in the numeric indices of the result - array, it stores the data in associative indices, using the - field names as keys. + <function>sesam_fetch_array</function> ã¯ã + <function>sesam_fetch_row</function> ã®é£æ³é åçã§ãããã¼ã¿ãçµ + æé åã®æ°å¤æ·»åã«ä¿åãã代ããã«ããã¼ã¿ããã£ã¼ã«ãåããã¼ã¨ + ãã¦é£æ³é åã«ä¿åãã¾ãã </para> <para> - <parameter>result_id</parameter> is a valid result id returned by - <function>sesam_query</function> (select type queries only!). + <parameter>result_id</parameter> ã¯ã + <function>sesam_query</function> (select åã¯ã¨ãªã®ã¿!)ã«ããè¿ã + ããæå¹ãªçµæIDã§ãã </para> <para> - For the valid values of the optional - <parameter><optional>whence</optional></parameter>and - <parameter><optional>offset</optional></parameter> - parameters, see the <function>sesam_fetch_row</function> - function for details. + ãªãã·ã§ã³ã® <parameter><optional>whence</optional></parameter> + ããã³ <parameter><optional>offset</optional></parameter> ãã©ã¡ã¼ + ã¿ã®æå¹ãªå¤ã®è©³ç´°ã«ã¤ãã¦ã¯ã颿° + <function>sesam_fetch_row</function> ãåç §ä¸ããã </para> <para> - <function>sesam_fetch_array</function> fetches one row of data from - the result associated with the specified result identifier. The - row is returned as an associative array. Each result - column is stored with an associative index equal to its - column (aka. field) name. The column names are converted to lower case. - + <function>sesam_fetch_array</function> ã¯ã + æå®ããçµæIDãæãçµæãã1ä»¶åã®ã¬ã³ã¼ããåå¾ãã¾ããã¬ã³ã¼ã + ã¯ã飿³é åã¨ãã¦è¿ããã¾ããåçµæã«ã©ã ã¯ããã®ã«ã©ã (ã¾ã㯠+ ãã£ã¼ã«ã)åã«çãã飿³é åã®è¦ç´ ã«ä¿åããã¾ããã«ã©ã åã¯ãå° + æåã«å¤æããã¾ãã </para> <para> - Columns without a field name (e.g., results of arithmetic - operations) and empty fields are not stored in the array. - Also, if two or more columns of the result have the same - column names, the later column will take precedence. In - this situation, either call - <function>sesam_fetch_row</function> or make an alias for - the column. + ãã£ã¼ã«ãåããªãã«ã©ã (ä¾ãã°ãæ°å¤æ¼ç®ã®çµæ)ããã³ç©ºã®ãã£ã¼ + ã«ãã¯ãé åã«ä¿åããã¾ãããã¾ãã2ã¤ä»¥ä¸ã®çµæãã«ã©ã åã«åã + ã«ã©ã åãããå ´åãæå¾ã®ã«ã©ã ãåªå ããã¾ãããã®å ´åã + <function>sesam_fetch_row</function>ãã³ã¼ã«ããããã®ã«ã©ã ã¸ã® + ã¨ã¤ãªã¢ã¹ã使ãã¦ä¸ããã <informalexample> <programlisting> -SELECT TBL1.COL AS FOO, TBL2.COL AS BAR FROM TBL1, TBL2</programlisting> +SELECT TBL1.COL AS FOO, TBL2.COL AS BAR FROM TBL1, TBL2 + </programlisting> </informalexample> </para> <para> - A special handling allows fetching "multiple field" - columns (which would otherwise all have the same column - names). For each column of a "multiple field", the - index name is constructed by appending the string "(n)" - where n is the sub-index of the multiple field column, - ranging from 1 to its declared repetition factor. The indices - are NOT zero based, in order to match the nomenclature - used in the respective query syntax. - For a column declared as: + ç¹å¥ãªå¦çã«ãã"è¤æ°ãã£ã¼ã«ã"ã«ã©ã (ãããã¯åãã«ã©ã åãæã + ãã«ã©ã )ãåå¾ãããã¨ãå¯è½ã«ãªãã¾ãã"è¤æ°ãã£ã¼ã«ã"ã®åã«ã© + ã ã«é¢ãã¦ãæ·»ååã¯ãæåå"(n)"ãä»å ãããã¨ã«ããæ§ç¯ããã¾ãã + ãã ããn ã¯è¤æ°ãã£ã¼ã«ãã®ã«ã©ã ã®å¯æ·»åã§ããã1ããå®£è¨æ¸ã¿ã® + å復æ°ã¾ã§ã®ç¯å²ã¨ãªãã¾ããã¯ã¨ãªæ§æã§ä½¿ç¨ããã表è¨ã«ä¸è´ãã + ãããã«æ·»åã¯ã¼ããåºæºã«ãã¦ãã¾ããã + 次ã®ããã«å®£è¨ããã¦ããããã«ã©ã ã®å ´åã <informalexample> <programlisting role="sesam"> -CREATE TABLE ... ( ... MULTI(3) INT )</programlisting> +CREATE TABLE ... ( ... MULTI(3) INT ) + </programlisting> </informalexample> - the associative indices used for the individual "multiple field" - columns would be <literal>"multi(1)"</literal>, - <literal>"multi(2)"</literal>, and - <literal>"multi(3)"</literal> respectively. + åã ã®"è¤æ°ãã£ã¼ã«ã"ã«ã©ã ã«é¢ãã¦é£æ³æ·»åã¯ããããã + <literal>"multi(1)"</literal>,<literal>"multi(2)"</literal>, + <literal>"multi(3)"</literal> ã«ãªãã¾ãã </para> <para> - Subsequent calls to <function>sesam_fetch_array</function> would - return the next (or prior, or n'th next/prior, depending on - the scroll attributes) row in the result set, or - <literal>FALSE</literal> if there are no - more rows. + <function>sesam_fetch_array</function> ãç¶ãã¦ã³ã¼ã«ããå ´åãçµ + æéåã®æ¬¡ã®(ã¹ã¯ãã¼ã«å±æ§ã«å¿ãã¦åã¾ãã¯nçªç®ã®å/å¾)ã¬ã³ã¼ãã¾ + ãã¯ã¬ã³ã¼ãããããªãå ´åã« <literal>FALSE</literal>ãè¿ãã¾ãã </para> <example> <title>SESAM åå¾é å</title> @@ -1809,9 +1793,9 @@ " WHERE LASTNAME='".strtoupper($name)."'\n". " ORDER BY FIRSTNAME", 1); if (! $result) { - ... error ... + ... ã¨ã©ã¼ ... } -// print the table: +// ãã¼ãã«ãåºåãã¾ã print "<TABLE BORDER>\n"; while (($row = sesam_fetch_array ($result)) && count($row) > 0) { print " <TR>\n"; @@ -1826,8 +1810,7 @@ </programlisting> </example> <para> - See also: <function>sesam_fetch_row</function> which returns - an indexed array. + æ·»åé åãè¿ã <function>sesam_fetch_row</function> ãåç §ä¸ããã </para> </refsect1> </refentry> @@ -1857,79 +1840,90 @@ ããéã«"ã¹ã¯ãã¼ã«å¯è½ãª"ã«ã¼ã½ã«ãè¦æ±ãããå ´åã®ã¿) </para> <para> - <parameter>whence</parameter> sets the global default value - for the scrolling type, it specifies the scroll type - to use in subsequent fetch operations on "scrollable" - cursors, which can be set to the following predefined - constants: + <parameter>whence</parameter> ã¯ããã®å¾ã®"ã¹ã¯ãã¼ã«å"ã«ã¼ã½ã« + ã®åå¾å¦çã§ä½¿ç¨ãããã¹ã¯ãã¼ã«ã®åãæå®ããã¹ã¯ãã¼ã«åã®ã°ãã¼ + ãã«ãªããã©ã«ãå¤ãè¨å®ããæ¬¡ã®ãããªå®ç¾©æ¸ã¿ã®å®æ°ãè¨å®ãã¾ãã <table> - <title>Valid values for <parameter>"whence"</parameter> parameter</title> + <title><parameter>"whence"</parameter> ãã©ã¡ã¼ã¿ã®æå¹ãªå¤</title> <tgroup cols="3"> <thead> <row> - <entry>Value</entry> - <entry>Constant</entry> - <entry>Meaning</entry> + <entry>å¤</entry> + <entry>宿°</entry> + <entry>æå³</entry> </row> </thead> <tbody> <row> - <entry>0</entry> - <entry><literal>SESAM_SEEK_NEXT</literal></entry> - <entry>read sequentially - </entry> + <entry>0</entry> + <entry><literal>SESAM_SEEK_NEXT</literal></entry> + <entry> + é£ç¶çã«èªã¿è¾¼ã + </entry> + </row> + <row> + <entry>1</entry> + <entry><literal>SESAM_SEEK_PRIOR</literal></entry> + <entry> + é£ç¶çã«å¾åãã«èªã + </entry> + </row> + <row> + <entry>1</entry> + <entry><literal>SESAM_SEEK_PRIOR</literal></entry> + <entry> + é£ç¶çã«å¾åãã«èªã¿è¾¼ã (åå¾å¾ãå é¨ããã©ã«ãå¤ã¯ + <literal>SESAM_SEEK_PRIOR</literal>ã«è¨å®ããã¾ã) + </entry> + </row> + <row> + <entry>2</entry> + <entry><literal>SESAM_SEEK_FIRST</literal></entry> + <entry> + æåã®ã¬ã³ã¼ãã«ç§»å(åå¾å¾ãããã©ã«ãå¤ã¯ + <literal>SESAM_SEEK_NEXT</literal>ã«è¨å®ããã¾ã) + </entry> + </row> + <row> + <entry>3</entry> + <entry><literal>SESAM_SEEK_LAST</literal></entry> + <entry> + æå¾ã®ã¬ã³ã¼ãã«ç§»å (åå¾å¾ãããã©ã«ãå¤ã¯ + <literal>SESAM_SEEK_PRIOR</literal>ã«è¨å®ããã¾ã) + </entry> + </row> + <row> + <entry>4</entry> + <entry><literal>SESAM_SEEK_ABSOLUTE</literal></entry> + <entry> + <parameter>offset</parameter> (0ãå é ãåå¾å¾ãå é¨ããã©ã« + ãå¤ã¯ã<literal>SESAM_SEEK_ABSOLUTE</literal> ã«è¨å®ãã¦ä¸ + ãããå é¨ã®ãªãã»ããå¤ã¯ãèªåçã«å¢å ãã¾ã)ã§æå®ããçµ¶ + 対ã¬ã³ã¼ãçªå·ã«ç§»åãã¾ãã + </entry> + </row> + <row> + <entry>5</entry> + <entry><literal>SESAM_SEEK_RELATIVE</literal></entry> + <entry> + ã«ã¬ã³ãã®ã¹ã¯ãã¼ã«ä½ç½®ã«å¯¾ãã¦ç¸å¯¾ä½ç½®ã«ç§»åããã ãã + <parameter>offset</parameter> ã¯æ£ã¾ãã¯è² ã®å¤ãæå®å¯è½ã§ãã + </entry> </row> - <row> - <entry>1</entry> - <entry><literal>SESAM_SEEK_PRIOR</literal></entry> - <entry>read sequentially backwards - </entry> - </row> - <row> - <entry>2</entry> - <entry><literal>SESAM_SEEK_FIRST</literal></entry> - <entry>fetch first row (after fetch, the default - is set to - <literal>SESAM_SEEK_NEXT</literal>)</entry> - </row> - <row> - <entry>3</entry> - <entry><literal>SESAM_SEEK_LAST</literal></entry> - <entry>fetch last row (after fetch, the default is - set to - <literal>SESAM_SEEK_PRIOR</literal>)</entry> - </row> - <row> - <entry>4</entry> - <entry><literal>SESAM_SEEK_ABSOLUTE</literal></entry> - <entry>fetch absolute row number given as - <parameter>offset</parameter> (Zero-based. After - fetch, the default is set to - <literal>SESAM_SEEK_ABSOLUTE</literal>, and the - offset value is auto-incremented)</entry> - </row> - <row> - <entry>5</entry> - <entry><literal>SESAM_SEEK_RELATIVE</literal></entry> - <entry>fetch relative to current scroll position, where - <parameter>offset</parameter> can be a positive or - negative offset value (this also sets the default - "offset" value for subsequent fetches).</entry> - </row> </tbody> </tgroup> </table> </para> <para> - <parameter><optional>offset</optional></parameter> is an - optional parameter which is only evaluated (and required) - if <parameter>whence</parameter> is - either <literal>SESAM_SEEK_RELATIVE</literal> or - <literal>SESAM_SEEK_ABSOLUTE</literal>. + <parameter><optional>offset</optional></parameter> ã¯ããªãã·ã§ã³ + ã®ãã©ã¡ã¼ã¿ã§ããã<parameter>whence</parameter> ã + <literal>SESAM_SEEK_RELATIVE</literal> ã¾ã㯠+ <literal>SESAM_SEEK_ABSOLUTE</literal> ã®ã©ã¡ããã§ããå ´åã«ã®ã¿ + è©ä¾¡ããã¾ã(ã¾ãå¿ è¦ã¨ããã¾ã)ã </para> </refsect1> </refentry> - + <refentry id="function.sesam-free-result"> <refnamediv> <refname>sesam_free_result</refname>