|Perl: the Markov chain saw|
Re: DBI Frustrationsby gmax (Abbot)
|on Sep 16, 2004 at 17:43 UTC||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.
_ _ _ _ (_|| | |(_|>< _|