Unable to Query Column With Same Name as Keyword
Anthony Gerhardt <[email protected]>
| Newsgroups | gmane.comp.lang.perl.modules.dbi.general |
|---|---|
| Organization | http://groups.google.com |
| Message-ID | <[email protected]> |
I've got a query in Sybase IQ 15.1:
SET quoted_identifier on
SELECT col."default"
FROM systabcol col
Which runs fine in my query tool (QTODBC 70). However the same query
in PerlDBI is return an error:
DBD::Sybase::db selectcol_arrayref failed: Server message number=102
severity=15 state=0 line=0 text=SQL Anywhere Error -131: Syntax error
near 'default' on line 2
[for Statement "
SET quoted_identifier on
SELECT col."default"
FROM systabcol col
"]
I've also tried \"default\".