|P is for Practical|
SQL through perl is giving errorby ksublondie (Friar)
|on Aug 31, 2011 at 21:22 UTC||Need Help??|
ksublondie has asked for the
wisdom of the Perl Monks concerning the following question:
I'm stumped and need help.
I am trying to execute a MS sql command through a perl cgi interface that works from the management console, but dies through my script.
For the transactions that are failing on the update statement and running the insert statement instead, I'm getting the following error relating to the $statement command:
BUT if I directly copy/paste the exact generated sql command from the management console query window, it succeeds w/no errors. Why is one generating an error and the other is fine?
UPDATE: If I make my 2nd do statement to be in the 1st eval:
It works. Something wrong with my eval statements???