Re: (Fwd) DBI Dilemma

[email protected] (Dagfinn Ilmari Mannsåker) Tue, 18 Aug 2015 09:55:39 +0100

Newsgroups	gmane.comp.lang.perl.modules.dbi.general
Message-ID	<[email protected]>

Ron Savage <[email protected]> writes:

> Hi
>
> $quote = $dbh -> get_info(29); # SQL_IDENTIFIER_QUOTE_CHAR.

Even better:

    my $quoted_column_name =  $dbh->quote_identifier($column_name);

This takes care of escaping any ocurrences of the quote character in the
column name.

-- 
"I use RMS as a guide in the same way that a boat captain would use
 a lighthouse.  It's good to know where it is, but you generally
 don't want to find yourself in the same spot." - Tollef Fog Heen