Re: QueryBrowser do not allow "..."

Hi Michael
Thanks for fast answer , but

It did clearify some of the problem , but why is
QueryBrowser the only tool /component which do complain.

I use Zeos Component / old MysqlCC - They have no problem.

Can it have something to do with the ClientLib I am using ??
1) zeos is running with libMysqlClient.so.10.0.0 on linux.
2) MysqlCC is running windows lastest version

Best regards
kim

> Kim,
>
> from http://dev.mysql.com/doc/mysql/en/string-syntax.html
>
> "If the server SQL mode has ANSI_QUOTES enabled, string literals can be
> quoted only with single quotes. A string quoted with double quotes is
> interpreted as an identifier."
>
> Best regards,
> Mike
>
> Kim G. Pedersen wrote:
>> Hi
>> Just try a
>> Select ... where factorydate< UNIX_TIMESTAMP("2005-07-06")
>> failing with an error :
>> unknow column '2005-07-06' in where clause  errorno 1054
>>
>> But will only accept
>> Select ... where factorydate< UNIX_TIMESTAMP('2005-07-06')
>>
>> " and ' ,,, should that not be the same ??
>>
>> Best Regards
>>
>> Kim G. Pedersen
>> macaos/elprint R&D
>> +45 35373808
>> +45 20464108 (Cell)
>>
>>
>
> --
> Michael Zinner, GUI Developer
> MySQL AB, www.mysql.com
> Office: +43 676 753 26 30
>
> Are you MySQL certified?  www.mysql.com/certification
>
> --
> MySQL GUI Tools Mailing List
> For list archives: http://lists.mysql.com/gui-tools
> To unsubscribe:    http://lists.mysql.com/gui-tools?unsub=kim@xxxxxxxxxx
>


Best Regards

Kim G. Pedersen
macaos/elprint R&D
+45 35373808
+45 20464108 (Cell)


-- 
MySQL GUI Tools Mailing List
For list archives: http://lists.mysql.com/gui-tools
To unsubscribe:    http://lists.mysql.com/gui-tools?unsub=gcdmm-mycc@xxxxxxxxxxx