Ack! I can't find the string "not valid sentence" in DBI.pm, Apache/DBI.pm, or
in Oracle.pm, so I'll ignore it.
Here's your code:
$phrase = "Mike's car"
$sql=qq{INSERT INTO TABLE_NAME (PHRASE) VALUES (?)};
my $insert_phrase=$dbh-prepare($sql);
Hi,
I probed:
s/'/''/g
yesterday but it did'nt work, will try with HTML code. I think is the
solution.
Thanks
the easiest way is
s/'/''/g
or
s/'/#39;/g
this more properly belongs on the DBI list,
Ok, this is a question for the perl-DBI list, but
i'm working with Apache::DBI.
see page 122 of the cheetah book:
"Bind values are passed to the database seperately
from the SQL statement, so there's no need to 'wrap up' the value in SQL
On Thu, 6 Jul 2000, Jesús Lasso Sánchez wrote:
Hi,
I probed:
s/'/''/g
yesterday but it did'nt work, will try with HTML code. I think is the
solution.
Thanks
the easiest way is
s/'/''/g
or
s/'/#39;/g
Hi,
AFAIK DBI's bind_param method should call
Hi,
I have a problem with DBI and Oracle. I have
an input form where i insert a phrase like
"Mike's
car"
when i try to do the insert, it produces an
error: "not valid sentence". this is the code:
$sql=qq{INSERT
INTOTABLE_NAME (PHRASE) VALUES (?)}; my
Jesús Lasso Sánchez wrote:
Part 1.1Type: Plain Text (text/plain)
Encoding: quoted-printable
yes ! because ' is a start or end of sql statement you
have to escape it
either convert to html equiv
#39; i think
or convert ' to '' in postgresql i dont know what it is in mysql
--Original Message-From: Jesús Lasso Sánchez
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 05, 2000 2:27
PMTo: [EMAIL PROTECTED]Subject: error DBI with
quote
Hi,
I have a problem with DBI and Oracle. I
have an input form where i insert a phrase like
"Mike's
car&q