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
A. Jones Rosen [EMAIL PROTECTED] 23-Oct-2006 19:21 To php-db@lists.php.net cc Subject [PHP-DB] Problem with Oracle 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

[PHP-DB] Problem with Oracle

2006-10-23 Thread Rosen
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 I remove

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

[PHP-DB] Problem with Oracle query

2006-10-13 Thread Rosen
Hi, I have a problem with PHP and Oracle SQL query. I have 2 tables : Table Main: --- id number text varchar2(100) Table Recs --- id number pos number log varchar2(200) I need to make query to select a list from first table(Main), where somewhere in the second table (Recs),

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[2]: [PHP-DB] Problem with Oracle connection

2001-11-28 Thread Jonathan B. Bayer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello B., This happens with either 4.0.4 or 4.0.6. What did you do to solve it? JBB Tuesday, November 27, 2001, 2:37:17 PM, you wrote: BP le ven 23-11-2001 à 02:18, Jonathan B. Bayer a écrit : -BEGIN PGP SIGNED MESSAGE- Hash: SHA1

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

[PHP-DB] Problem with Oracle connection

2001-11-22 Thread Jonathan B. Bayer
-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 it apparently randomly loses the connection to the database.