On Fri, 11 Jan 2002, Simon Oliver wrote:
> > According to the docs Simon quoted, for DBD::AnyData
> Actually, it's due to SQL::Statement which is used by a number of DBD modules
> including DBD::AnyData and DBD::CSV
It is what I thought.
>
> > you need to escape a
> > single quote with a backslash, not with another single quote, as you would
> > for most other DBDs.
>
An yeas that is the answer. Thank You.
> Which is why it is better to use the $dbh->quote method or placeholders - they
> are more portable!
I agree 102%, but for some reason the dbh is now longer around?
the the statement handle is fine.
Once I figure that out I use the quote.
As for placeholders, <sigh> I cannot seem to wrap my tiny
brain around them. It would also mean redoing some things and
rocking the basis of my world-view (well maybe not that drastic,
but I would have the change the way I look at things...not a
bad thing, just, well inertia - :) )
Once again thank you for your patience and helpfulness and
if I can ever repay the kindness please let me know.
As Always
r
