Re: [PHP-DB] No resultset with ocibindbyname

2008-02-25 Thread Christopher Jones
Manuel Schölling wrote: Hi guys, sorry for spamming your mailing list. I have a strange problem with ocibindbyname(): I use this simple code to start an SQL query: But this query doesn't give me any data record (no error; empty resultset). I couldn't reproduce your problem. What does

Re: [PHP-DB] No resultset with ocibindbyname

2008-02-25 Thread Manuel Schölling
Hi Christopher, thanks for caring about my problem. ;) I couldn't reproduce your problem. What does your table look like? What version of PHP OCI8? What version of Oracle? I using PHP 5.2.5 on a Linux 2.6.9 machine. The version of OCI8 is 1.2.4 (Revision 1.269.2.16.2.38, Oracle Instant

[PHP-DB] INSERT query with Primary and foreign key

2008-02-25 Thread Nasreen Laghari
Hi, I need help to insert date into two tables when tables have primary and foreign key relationship using php. I tried simple INSERT query but foreign key colum is storing NULL. Regards Nasreen Be a

[PHP-DB] pg_escape with copy

2008-02-25 Thread blackwater dev
I have data that I'm running through pg_escape_sting in php and then adding to stdin for a copy command. The problem is O'reilly is being changed to O''Reilly in the string and then in the db. I saw with the copy command I can specify the escape but it isn't working for me. Should this command