Re: Re: Quoting problem in DBI:ODBC


laziness, impatience, and hubris
	PerlMonks

Re: Re: Quoting problem in DBI:ODBC

by Seumas (Curate)

on Jun 27, 2003 at 15:49 UTC ( #269633=note: print w/replies, xml )

Need Help??

in reply to Re: Quoting problem in DBI:ODBC
in thread Quoting problem in DBI:ODBC

Another option is to use placeholders, which is even cleaner than using $dbh->quote(). It isn't the right fit for 100% of your queries and statements, but it is for 99% of them. Check the DBI:: docs for details on how to use it. It would be something like.

eval {
   my $sth = $dbh->prepare("INSERT INTO users (fname, lname, phone) VA
+LUES(?, ?, ?)");
   $sth->execute($fname, $lname, $phone);
   $dbh->commit();
[download]

Comment on Re: Re: Quoting problem in DBI:ODBC Download Code

In Section Seekers of Perl Wisdom

Domain Nodelet^?

www.com | www.net | www.org

Node Status^?

node history
Node Type: note [id://269633]
help

Chatterbox^?

How do I use this? • Last hour • Other CB clients

Other Users^?

Others chilling in the Monastery: (6)

As of 2023-12-11 21:36 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

Notices^?