[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)
{
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
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
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
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),
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
' 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
'%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
-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
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
-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.
11 matches
Mail list logo