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