RE: DBI Failure with certain types of queries

2004-07-23 Thread jason corbett
Yes I do. Here THEY are :( PS. Do you think binding will help? String found where operator expected at ./select_n.pl line 117, near "ban "BAN"" (Do you need to predeclare ban?) Bareword found where operator expected at ./select_n.pl line 120, near "n.first_name" (Might be a runaway multi-

RE: DBI Failure with certain types of queries

2004-07-23 Thread Bob Showalter
jason corbett wrote: > ... > When I get the query into the variable, I try to prepare it using > $sth=$dbh->prepare($sql); > > It is failing and I am not sure why. Do you have RaiseError set to 1? What is the error message after the prepare? -- To unsubscribe, e-mail: [EMAIL PROTECTED] For add

DBI Failure with certain types of queries

2004-07-23 Thread jason corbett
I have a the query below that I am reading from a file and placing in the $sql variable. i.e. [snipet]---reads any query in a file to the variable $sql if (open(FOURDAYQ, $fourdayquery)){ while (){ chomp(@myquery=);} close(FOURDAYQ); return "@myquery"; } else { die open(ERRORLOG, ">>