That fixed it. Had to use $dbh->{syb_quoted_identifier} = 1;
Thanks
On Fri, Sep 16, 2011 at 9:32 AM, tiger peng <tigerpeng2...@yahoo.com> wrote:
> check quote and quote_identifier method.
>
> ------------------------------
> *From:* Anthony Gerhardt <sirballsw...@gmail.com>
> *To:* dbi-users@perl.org
> *Sent:* Thursday, September 15, 2011 2:10 PM
> *Subject:* Unable to Query Column With Same Name as Keyword
>
> 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\".
>
>
>
>
