From: "Pat Rice" <[EMAIL PROTECTED]> > Hi all > I'm looking for some good ideas on trouble shooting SQL. > > as in I have wrote thsi code, but I wondering if there is any way we > can a debug level, so that it would tell me if the query failed. > eg. > 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. Jenda ===== [EMAIL PROTECTED] === http://Jenda.Krynicky.cz ===== When it comes to wine, women and song, wizards are allowed to get drunk and croon as much as they like. -- Terry Pratchett in Sourcery -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] http://learn.perl.org/
