more useful options | |
PerlMonks |
Re: DBI Frustrationsby gmax (Abbot) |
on Sep 16, 2004 at 17:43 UTC ( [id://391518]=note: print w/replies, xml ) | Need Help?? |
You are mixing a statement handler with its result.
This instruction returns the execution result, i.e. if the query was executed correctly. (See the DBI docs). For your fetch statement you need to use $subs_str, i.e.the statement handler. As a side note, be aware that the execute method DOES NOT return the number of rows for a SELECT query. Moreover (this is not related to your problem, but it can create other unpleasant side effects) you should not interpolate variables in your queries, but use placeholders instead. Update _ _ _ _ (_|| | |(_|>< _|
In Section
Seekers of Perl Wisdom
|
|