DBI Question

dsb has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: DBI Question by jreades (Friar) on Jan 17, 2001 at 03:08 UTC
You can do this: `$sth = $dbh->prepare("SELECT name FROM people WHERE name LIKE ?"); $sth->execute('%foo%');` [download] Just, remember, as I said in chatterbox, to escape the wildcard character '%'.	[reply] [d/l]
Re: Re: DBI Question by dsb (Chaplain) on Jan 17, 2001 at 03:13 UTC
The value I will bind to the placeholder is SCALAR variable. Can this still be done like: `$sth = $dbh->prepare("SELECT name FROM people WHERE name LIKE ?"); $sth->execute( "$foo\%" );` [download]	[reply] [d/l]
Re: Re: Re: DBI Question by jreades (Friar) on Jan 17, 2001 at 03:15 UTC
You'll have to test it for yourself, but I don't see why not... An easier way, if you know that you're always doing wildcard searches, might be: `$sth->execute('%' . $foo . '%');` [download]	[reply] [d/l]
Re: Re: Re: Re: DBI Question by dsb (Chaplain) on Jan 17, 2001 at 03:35 UTC
Re: DBI Question by cadfael (Friar) on Jan 17, 2001 at 20:59 UTC
I am trying to find out if a SQL wildcard ('%') can be used in a DBI script next to a placeholder. Something like this: `$sth = $dbh->prepare( "SELECT name FROM people WHERE name LIKE ?%" );` I do this on a regular basis without needing to escape the '%' character, but in Sybase (and I assume MS SQL Server) , a string with a wildcard needs to be quoted: `$sth = $dbh->prepare( "SELECT name FROM people WHERE name LIKE 'Jones%'" );` [download] ----- "Computeri non cogitant, ergo non sunt"	[reply] [d/l] [select]
Re: Re: DBI Question by dsb (Chaplain) on Jan 18, 2001 at 19:45 UTC
Yes. Now how do i do it with a place holder and scalar variable. `$sth = $dbh->prepare( "SELECT name FROM people WHERE name like ?" ); $sth->execute( $name );` [download] how do include a wildcard in the where the placeholder is without appending it to the variable.	[reply] [d/l]