Re: [PHP-DB] Problem with Oracle

2006-10-25 Thread Christopher Jones
[EMAIL PROTECTED] wrote: In Oracle you would write: insert into pts (pid, txt) values (1,'502a'); But in PHP you are going to do the following: $conn = oci_connect('scott','tiger','my_db'); $sql = insert into pts (pid, txt) values (1,'502a'); $cursor = oci_parse($conn, $sql); if (! $cursor) {

Re: [PHP-DB] Problem with Oracle

2006-10-24 Thread roy . a . jones
In Oracle you would write: insert into pts (pid, txt) values (1,'502a'); But in PHP you are going to do the following: $conn = oci_connect('scott','tiger','my_db'); $sql = insert into pts (pid, txt) values (1,'502a'); $cursor = oci_parse($conn, $sql); if (! $cursor) { $err = oci_error($conn);

Re: [PHP-DB] Problem with Oracle

2006-10-23 Thread Chris
Rosen wrote: Hi, I have a problem with PHP and Oracle 10 Database. I read sql script from file and execute it. Files are something like this: insert into pts (pid, txt) values (1,'502a'); insert into pts (pid, txt) values (2,'502b'); . I receive a message: ORA-00911: invalid character When

Re: [PHP-DB] Problem with Oracle query

2006-10-13 Thread roy . a . jones
Try this ... SELECT m.id ,m.text FROM main m ,recs r WHERE m.id = r.id AND r.log like '%sometext%' ORDER BY m.id / Roy A. Jones Rick [EMAIL PROTECTED] 13-Oct-2006 10:53 To php-db@lists.php.net cc Subject Re: [PHP-DB] Problem with Oracle query Brad Bonkoski

Re: [PHP-DB] Problem with Oracle query

2006-10-13 Thread Rosen
' in the Recs table Roy A. Jones Rick [EMAIL PROTECTED] 13-Oct-2006 10:53 To php-db@lists.php.net cc Subject Re: [PHP-DB] Problem with Oracle query Brad Bonkoski [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Rosen wrote: Hi, I have a problem with PHP and Oracle SQL

Re: [PHP-DB] Problem with Oracle query

2006-10-13 Thread roy . a . jones
'%sometext%' ORDER BY m.id / Roy A. Jones Rosen [EMAIL PROTECTED] 13-Oct-2006 11:09 To php-db@lists.php.net cc Subject Re: [PHP-DB] Problem with Oracle query [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Try this ... SELECT m.id ,m.text FROM main m

Re: [PHP-DB] Problem with Oracle connection

2001-11-27 Thread B. PERRINE
le ven 23-11-2001 à 02:18, Jonathan B. Bayer a écrit : -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello php-db, We have a RedHat 7.1 server with a stock install. I recompiled PHP from the source RPM in order to add oracle support. It mostly works, but we are having a problem where