[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)
ove the trailing comma from the parsed
SQL or remove it from the file.
Roy 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
"Chris" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> 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 (p
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"
Whe
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 manu
ot;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 thi
'%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 ...
>
>
me so much rows as many are the appearance the
'sometext' 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 O
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
"Brad Bonkoski" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Rosen wrote:
>> 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 numb
Rosen wrote:
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 ta
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), th
-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 probl
-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. It
15 matches
Mail list logo