in reply to Re: Capturing warnings from DBD:PG
in thread Capturing warnings from DBD:PG

Yes I know however in the past I have had trouble with creating sql cmds that involve geometry entries using placeholders It is thought due to escaping internal quotes this method works for this kind of SQL. For all other SQL commands I use placeholders

Replies are listed 'Best First'.
Re^3: Capturing warnings from DBD:PG
by Pope-O-Matik (Pilgrim) on Nov 29, 2015 at 14:11 UTC

    Hmm... I guess that could be a problem. But, it's still worthwhile to use placeholders. Better to escape characters than to escape security.

    A function may do you well though. A little longer just once, and more secure in every script.

[reply]

In Section Seekers of Perl Wisdom