Re: Can't Set SQL_MODE?!

2004-01-20 Thread Paul DuBois
At 13:22 -0800 1/17/04, [EMAIL PROTECTED] wrote: Howdy all, I've tried to search for an answer to this on the lists (and on google), but I haven't been able to come up with anything, so I apologize in advance if this question is redundant. According to the docs

Can't Set SQL_MODE?!

2004-01-17 Thread mattb
Howdy all, I've tried to search for an answer to this on the lists (and on google), but I haven't been able to come up with anything, so I apologize in advance if this question is redundant. According to the docs (http://www.mysql.com/doc/en/SQL_mode.html): The MySQL server can operate in

Re: Can't Set SQL_MODE?!

2004-01-17 Thread mattb
By the way, I should point out that I *can* get it to work by adding: [mysqld] ansi Or: [mysqld] sql_mode=PIPES_AS_CONCAT But this is not what I want, since I'm going to be hosting this app where I won't have access to the server config. I need to be able to set it on a per

Re: Can't Set SQL_MODE?!

2004-01-17 Thread Jeremy March
Try this: mysql set @@session.sql_mode = 'ansi'; Query OK, 0 rows affected (0.00 sec) mysql select @@session.sql_mode; ++ | @@session.sql_mode |