[PHP-DB] oci_bind_by_name, 'Unknown or unsupported datatype given'

2005-08-09 Thread Anton Channing
I am currently building a php-oracle application for the college I work for, and as part of that application I have cause to to create some insert/update procedures. My best solution for this is to have an input/output parameter representing the id of the field that needs to updated. This

[PHP-DB] mysql not valid resource

2005-08-09 Thread Marco Strullato
Hi all, I have a problem with mysql: this code produce a not valid mysq resource. $sql=select distinct des_riga, count ( des_riga ) as freq from k_riga where id_tabella= . $id_tabella . and id_colonna= . $id_colonna . group by des_riga order by des_riga; $query=mysql_query ($sql, $connessione);

RE: [PHP-DB] mysql not valid resource

2005-08-09 Thread Bastien Koert
try adding some debug code to the statement execution $query=mysql_query ($sql, $connessione) or die (error is .mysql_error()); to get an error message that can help debug the query bastien From: Marco Strullato [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] mysql not valid

RE: [PHP-DB] mysql not valid resource

2005-08-09 Thread Hutchins, Richard
Marco, Have you tried echoing out the sql statement to the browser before it gets sent to the database? That would show you the exact query string and give you a chance to see where the error might reside. $sql=select distinct des_riga, count ( des_riga ) as freq from k_riga where id_tabella= .

Re: [PHP-DB] mysql not valid resource. .

2005-08-09 Thread Martin Norland
A thought - if he's getting the 'not a valid resource' from just the code he posted, then his problem is with the $connessione variable, and not the query itself. Check to make sure the connection is up at all/etc. and *it* is a valid resource. Generally (well, in the simple case - which is

[PHP-DB] PDO Buffered / Unbuffered queries

2005-08-09 Thread Holografix
Hi all How does one do buffered queries with pdo? Any param in pdo-query(), pdo-executeQuery() ? Regards holografix -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php