Have you tried to run your sql statement in sqlplus? Does it work there?
Thanks, Sam Gold -----Original Message----- From: deadtwoU wishUknew [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2003 1:01 PM To: Ronald J Kimball; deadtwoU wishUknew Cc: [EMAIL PROTECTED] Subject: Re: DECODE in(DBI) Nope thats not it... DBI also works like that, if you check the MANUAL. Actually by adding "{}", removes most of my errors, and its functionally correct. Its something else, with the DECODE function. Thanks alot though :) Any other ideas? On Thu, 5 Jun 2003 12:35:53 -0400 Ronald J Kimball <[EMAIL PROTECTED]> wrote: > On Thu, Jun 05, 2003 at 06:32:16PM +0200, deadtwoU > wishUknew wrote: > > > I've been working with my code for a while, and it > seems, > > perl DBI does not seem to like my query when combined > with > > SQL DECODE. > > DECODE isn't important. You have an extraneous quote in > your SQL: > > > $yth = $dbh->prepare(q{"select nolo "Batch Number", > ^^^ > > Ronald == Download ringtones, logos and picture messages at Ananzi Mobile Fun. http://www.ananzi.co.za/cgi-bin/goto.pl?mobile
