RE: error DBI with quote

[Geoffrey Young]

this more properly belongs on the DBI list, but 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 quoting rules."   thus, no need to call quote()...   HTH   --Geoff -----Original Message----- From: Jesús Lasso Sánchez [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 05, 2000 2:27 PM To: [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"    when i try to do the insert, it produces an error: "not valid sentence". this is the code:         $sql=qq{INSERT INTO TABLE_NAME (PHRASE) VALUES (?)};       my $insert_phrase=$dbh->prepare($sql);       $sql->bind_param(1,$dbh->quote($phrase),SQL_VARCHAR);       $insert_phrase->execute();   Anybody know something about this     thanks   ______________________________________ Jesús Lasso - Ya.com Internet Factory [EMAIL PROTECTED] www.ya.com - www.globalya.com