Yeah....it runs perfectly in SQl*plus. Just add an ';' at the end, and *bam* its done. Its something with the decode, I'm not sure whether its having a problem with the inverted commas as its parsing. Hmm....*bug or poor code* *sigh*
I've just got the code for OracleTool, which is fully coded in perl, cgi + DBI. So will have a look and see how it was done there, if he used DECODE *sigh* *prays* On Thu, 5 Jun 2003 13:06:15 -0400 "Gold, Samuel (Contractor)" <[EMAIL PROTECTED]> wrote: > 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 > > == Download ringtones, logos and picture messages at Ananzi Mobile Fun. http://www.ananzi.co.za/cgi-bin/goto.pl?mobile
