On Mon, Apr 14, 2008 at 7:11 PM, Jenda Krynicky <[EMAIL PROTECTED]> wrote: snip > > my $sql = q/SELECT Account,Last_Name,First_Name,Email_Address FROM > > prospects WHERE Email_Address='?'/; > > Drop the singlequotes. This way your SQL searches for a literal > questionmark in the Email_Address column. snip
Are you certain? DB2, for instance, requires the use of single quotes for strings (double quotes are for system objects). Are you confusing placeholders and Perl/shell interpolation? -- Chas. Owens wonkden.net The most important skill a programmer can have is the ability to read. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] http://learn.perl.org/
