perl-modperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jesús Lasso Sánchez <jla...@ya.com>
Subject error DBI with quote
Date Wed, 05 Jul 2000 18:27:17 GMT
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
jlasso@ya.com
www.ya.com - www.globalya.com

Mime
View raw message