Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re: I seek DBI wisdom concerning bind parameters

by graff (Chancellor)
on Oct 22, 2015 at 16:39 UTC ( [id://1145660]=note: print w/replies, xml ) Need Help??


in reply to I seek DBI wisdom concerning bind parameters

While it was kind of you to snip out irrelevant details, the obvious risk is that the problem lies in the parts you've left out - e.g. an extra quote mark or unescaped apostrophe or some such thing in the assignment to $fieldquery, or maybe some code that prepares another query and assigns that to $fieldquery (update: or rather, to $sth_fields) before your "execute" call.

For that matter, we don't actually know whether the line number reported in the error message (whatever it was) actually corresponds to the particular "execute" call you showed us.

Replies are listed 'Best First'.
Re^2: I seek DBI wisdom concerning bind parameters
by campbell (Beadle) on Oct 23, 2015 at 13:35 UTC

    Thanks for the replies, people. You're correct - I did, in fact snip out the piece of code that was creating the problem. Basically, as part of a systems upgrade, we are moving from Sybase (using trans-SQL) to MS-SQL, and there were some functions embedded into the query that caused it fall over before it got as far as resolving the bind parameters. So I've straightened it out and all is well...

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1145660]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others perusing the Monastery: (7)
As of 2024-03-28 21:57 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found