Re: [PHP-DEV] make status etc From: Dave Walton (walton <email protected>)
Date: 12/30/98

On 27 Dec 98, at 16:01, Rasmus Lerdorf wrote:

> genfunclist generates the function listing based on all functions in the
> code. genfuncsummary pulls out all the prototypes and generates a
> quick-reference type of blurb for each function. It would be very nice
> if the genfuncsummary functions covered every function that genfunclist
> covers. I'm working towards that by adding prototypes, but I would
> definitely appreciate any help people here could provide.

Uh-oh. I think you're looking at me when you say that. I better
clean up my mess...

[NOTE: I used this function way back in 3.0b5-dev. While I was
testing my examples on 3.0.3 just now, I found that it causes good
old Dr. Watson to pop up. Anyone (Shane?) have any ideas what
needs to get updated to work with the massive ODBC changes
since then?]

/* {{{ proto int odbc_setoption(int id, int function, int option, int
param)
   Adjust ODBC settings. Returns false if an error occurs,
otherwise true. */

This function allows fiddling with the ODBC options for a particular
connection or query result. It was written to help find work arounds
to problems in quirky ODBC drivers. You should probably only use
this function if you are an ODBC programmer and understand the
effects the various options will have. You will certainly need a good
ODBC reference to explain all the different options and values that
can be used. Different driver versions support different options.

Because the effects may vary depending on the ODBC driver, use
of this function in scripts to be made publicly available is strongly
discouraged. Also, some ODBC options are not available to this
function because they must be set before the connection is
established or the query is prepared. However, if on a particular job
it can make PHP work so your boss doesn't tell you to use a
commercial product, that's all that really matters.

id: The connection or result ID on which to change the settings.
  For SQLSetConnectOption(), this is a connection ID.
  For SQLSetStmtOption(), this is a result ID.

function: The ODBC function to use.
  value function
    1 SQLSetConnectOption()
    2 SQLSetStmtOption()

option: The option to set.

param: The value for the given option.

Examples:

1. odbc_setoption($conn, 1, 102, 1);
Option 102 of SQLSetConnectOption() is SQL_AUTOCOMMIT.
Value 1 of SQL_AUTOCOMMIT is SQL_AUTOCOMMIT_ON.
This example has the same effect as
  odbc_autocommit($conn, true);

2. $result = odbc_prepare($conn, $sql);
    odbc_setoption($result, 2, 0, 30);
    odbc_execute($result);
Option 0 of SQLSetStmtOption() is SQL_QUERY_TIMEOUT.
This example sets the query to timeout after 30 seconds.

----------------------------------------------------------------------
Dave Walton
Webmaster, Postmaster Nordic Entertainment Worldwide
walton <email protected> http://www.nordicdms.com
---------------------------------------------------------------------- 

--
PHP Development Mailing List   http://www.php.net/
To unsubscribe send an empty message to php-dev-unsubscribe <email protected>
For help: php-dev-help <email protected>