Of course the quote_identifier() method and related attributes will also
help provide an independent method for building "generic" SQL statements:
my $sql = 'SELECT * from ' .
$dbh->quote_identifier('my_table') .
' WHERE id=?';
For example, I recently tried to reference a table named "Publication"
in a Sybase ASA database and hit a problem because 'Publication' is a
reserved word.
--
Simon Oliver
- DBI::tables() Simon Oliver
- Re: DBI::tables() Simon Oliver
- Re: DBI::tables() Steffen Goeldner
- Re: DBI::tables() Simon Oliver
- Re: DBI::tables() Steffen Goeldner
- Re: DBI::tables() Simon Oliver
- Re: DBI::tables() Steffen Goeldner
- Re: DBI::tables() Simon Oliver
