ODBC String Quoting in odbc_exec

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
I'm moving a script from MySQL to MS Access (yuck).  Anyway, when I do
an insert or select with an email address as a field value in
odbc_exec, ODBC barfs on me.

Is there some special quoting required for the '@' in an email?

Cause now,  SELECT * FROM mytable WHERE email='me@something.com'
doesn't work.

Also, INSERT INTO mytable (uid, email, arbstring) VALUES (1,
'me@something.com', 'abc') also doesn't work.



Re: ODBC String Quoting in odbc_exec

Quoted text here. Click to load it
use SELECT * FROM mytable WHERE email='me\@something.com'
this work for MySQL and must work for ODBC too.


Petr Vileta, Czech republic
(My server rejects all messages from Yahoo and Hotmail. Send me your mail  
from another non-spammer site please.)

Site Timeline