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-line .. string starting on line 118) String found where operator expected at ./select_n.pl line 120, near "first_name "CONSUMERFNAME"" (Do you need to predeclare first_name?) String found where operator expected at ./select_n.pl line 122, near "carrier_name "Service Provider"" (Do you need to predeclare carrier_name?) String found where operator expected at ./select_n.pl line 123, near "sys_creation_date "Initiation Date of the Request"" (Do you need to predeclare sys_creation_date?) Bareword found where operator expected at ./select_n.pl line 126, near "from" (Missing semicolon on previous line?) Bareword found where operator expected at ./select_n.pl line 131, near "carrier" (Might be a runaway multi-line ,, string starting on line 128) (Missing semicolon on previous line?) Bareword found where operator expected at ./select_n.pl line 137, near "and p.port_path" (Might be a runaway multi-line .. string starting on line 135) (Do you need to predeclare and?) Bareword found where operator expected at ./select_n.pl line 141, near "where S2.request_no" (Might be a runaway multi-line .. string starting on line 139) (Do you need to predeclare where?) Bareword found where operator expected at ./select_n.pl line 145, near "and anl.name_id" (Might be a runaway multi-line .. string starting on line 142) (Do you need to predeclare and?) syntax error at ./select_n.pl line 117, near "ban "BAN"" Execution of ./select_n.pl aborted due to compilation errors. Bob Showalter <[EMAIL PROTECTED]> wrote: 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 additional commands, e-mail: [EMAIL PROTECTED]
