Re: 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.

Comment on Re: I seek DBI wisdom concerning bind parameters

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...	[reply]