[PHP-DB] CLOB->load() error (OCI8 against Oracle 10G )

I have an OCI-Lob Object (in this case a clob) on which I am calling load(). I have identical code for a blob that works perfectly fine. I can't find any documentation or notes about this function or my error... Code that produces error: // i get here after succesfully executing // a

Re: [PHP-DB] [PDO] Number of rows found by Select

So would it be possible to write a select() function to handle the wierdness? I'm attempting to write one but I'm getting buffered query errors. This function is part of a Database Manager class and is supposed to return a PDO::Statement with the number of rows being stored in a referenced para

Re: [PHP-DB] [PDO] Number of rows found by Select

Ick.. this is why I don't use OOP DBA libraries.. Uhm.. without spending a bit of time learning more about PDO, I'd be hard pressed to answer this one. Why are you getting issues with asynchronous unbuffered queries? If they're unbuffered, how is the code execution continuing before you get d

[PHP-DB] mssql_query returns a boolean false instead an empty recordset when the query doesn't match any record

Hi all, Maybe I didn't explain myself quite wel, so I wil repeat the queestion in other words. I would like to know which is the correct answer I should obtain from mssql_query. I have a server in which mssql_query is returning a false boolean when it should return an empty recordset (a

Re: [PHP-DB] [PDO] Number of rows found by Select

Cracked it! The buffer command (setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, TRUE)) needs to be sent to the PDO object, not PDO::Statement objects. The documentation is wrong here, in a number of ways. This is the function that (fingers crossed) runs a SELECT query and returns the stateme

[PHP-DB] MYSQL IN A PHP LOOP

I have a php function that creates the following SQL below with this statement in the loop: ~~~ $myQuery .= " UPDATE page SET page_order_id = \"$page_order_id\" WHERE page_i

RE: [PHP-DB] mssql_query returns a boolean false instead an empty recordset whenthe query doesn't match any record

According to the php docs, the mssql call should return 'TRUE' on empty recordset. Are you sure there is no problem with the query? Bastien From: "Pablo F. Díaz Anzalone"<[EMAIL PROTECTED]> To: php-db@lists.php.net Subject: [PHP-DB] mssql_query returns a boolean false instead an empty record

RE: [PHP-DB] MYSQL IN A PHP LOOP

You can't stack queries this way. PHPMyAdmin parses out the queries based on the ';'. You will need to run the query after each one is created. Bastien From: "Malcolm JC Clark" <[EMAIL PROTECTED]> Reply-To: <[EMAIL PROTECTED]> To: Subject: [PHP-DB] MYSQL IN A PHP LOOP Date: Wed, 9 Nov 2005 1

Re: [PHP-DB] CLOB->load() error (OCI8 against Oracle 10G )

What line of code is 1546? How are you binding/executing/fetching? Are you using OCI_B_CLOB? If you post a complete (small) testcase we may can look at it. Please include DDL to create any table. Most importantly, use the refactored OCI8 driver: http://pecl.php.net/package/oci8 -- cj Script

[PHP-DB] Login Auth help? | Handling pages help? (2 questions)

Hi, Need some ideas/opinions on a project I have. The project is for a Radio Station (online one) where DJ's can login to the site and do stuff and listeners can listen in live to the live feeds. Now I downloaded a password protected code that uses MySQL to store the info but it fails each

[PHP-DB] Login Auth help? | Handling pages help? (2 questions)

Hi, Need some ideas/opinions on a project I have. The project is for a Radio Station (online one) where DJ's can login to the site and do stuff and listeners can listen in live to the live feeds. Now I downloaded a password protected code that uses MySQL to store the info but it fails each