Re: PerlDBI and quoting

in reply to PerlDBI and quoting

However, when I look at the data content in SQL Developer, or when I then perform a 'select' on the table to extract the data later, it has enclosing quotes i.e. I don't get " CONTENT " - I get " 'CONTENT' ", which then interferes with string matching downstream. What have I missed?

You don't need both ->quote and placeholders (?, ?). Placeholders are The Right Way, so just use only those.

Comment on Re: PerlDBI and quoting Select or Download Code

Replies are listed 'Best First'.
Re^2: PerlDBI and quoting by jerryhone (Sexton) on Feb 05, 2021 at 14:20 UTC
Thanks haukex - that works nicely! I was clearly being a a bit overprotective!	[reply]
Re^3: PerlDBI and quoting by haukex (Archbishop) on Feb 05, 2021 at 14:33 UTC
I was clearly being a a bit overprotective! Better than not knowing Little Bobby Tables at all! `:-)`	[reply] [d/l]
Re^4: PerlDBI and quoting by LanX (Saint) on Feb 05, 2021 at 15:24 UTC
Tangential: at last Germany.pm online meeting we were discussing using emojis inside passwords. Since then I'm trying to register a properly named unicode character for little Bobby ... ;D Cheers Rolf _{(addicted to the Perl Programming Language :) Wikisyntax for the Monastery}	[reply]
Re^5: PerlDBI and quoting by bliako (Monsignor) on Feb 05, 2021 at 19:59 UTC
Re^6: PerlDBI and quoting by LanX (Saint) on Feb 05, 2021 at 20:06 UTC
Some notes below your chosen depth have not been shown here

In Section Seekers of Perl Wisdom