cvs: phpdoc /en/reference/pgsql/functions pg-result-error-field.xml

chriskl Tue Mar 22 03:59:00 2005 EDT Modified files: /phpdoc/en/reference/pgsql/functions pg-result-error-field.xml Log: List possible diagnostic codes http://cvs.php.net/diff.php/phpdoc/en/reference/pgsql/functions/pg-result-error-field.xml?r1=1.1&r2=1.2&ty=u Index: phpdoc/en/reference/pgsql/functions/pg-result-error-field.xml diff -u phpdoc/en/reference/pgsql/functions/pg-result-error-field.xml:1.1 phpdoc/en/reference/pgsql/functions/pg-result-error-field.xml:1.2 --- phpdoc/en/reference/pgsql/functions/pg-result-error-field.xml:1.1 Sun Mar 20 03:54:31 2005 +++ phpdoc/en/reference/pgsql/functions/pg-result-error-field.xml Tue Mar 22 03:58:58 2005 @@ -1,5 +1,5 @@ <?xml version="1.0" encoding="iso-8859-1"?> -<!-- $Revision: 1.1 $ --> +<!-- $Revision: 1.2 $ --> <!-- splitted from ./en/functions/pgsql.xml, last change in rev 1.58 --> <refentry id='function.pg-result-error-field'> <refnamediv> @@ -28,7 +28,38 @@ <function>pg_get_result</function> to get the result handle. </para> <para> - Possible <parameter>fieldcode</parameter> values are: + Possible <parameter>fieldcode</parameter> values are: <literal>PGSQL_DIAG_SEVERITY</literal>, + <literal>PGSQL_DIAG_SQLSTATE</literal>, <literal>PGSQL_DIAG_MESSAGE_PRIMARY</literal>, x + <literal>PGSQL_DIAG_MESSAGE_DETAIL</literal>, + <literal>PGSQL_DIAG_MESSAGE_HINT</literal>, <literal>PGSQL_DIAG_STATEMENT_POSITION</literal>, + <literal>PGSQL_DIAG_INTERNAL_POSITION</literal> (PostgreSQL 8.0+ only), + <literal>PGSQL_DIAG_INTERNAL_QUERY</literal> (PostgreSQL 8.0+ only), + <literal>PGSQL_DIAG_CONTEXT</literal>, <literal>PGSQL_DIAG_SOURCE_FILE</literal>, + <literal>PGSQL_DIAG_SOURCE_LINE</literal> or + <literal>PGSQL_DIAG_SOURCE_FUNCTION</literal>. + </para> + </refsect1> + + <refsect1 role="examples"> + &reftitle.examples; + <para> + <example> + <title><function>pg_result_error_field</function> example</title> + <programlisting role="php"> +<![CDATA[ +<?php + $dbconn = pg_connect("dbname=publisher") or die("Could not connect"); + + if (!pg_connection_busy($dbconn)) { + pg_send_query($dbconn, "select * from doesnotexist;"); + } + + $res1 = pg_get_result($dbconn); + echo pg_result_error_field($res1, PGSQL_DIAG_SQLSTATE); +?> +]]> + </programlisting> + </example> </para> </refsect1>