Posted by Mitch on 10/04/06 03:37

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.

Thanks,

Mitch

• Next in forum: Re: secure server-to-server transmissions
• Prev in forum: Re: issues writing a image path to mysql database
• Thread view: ODBC String Quoting in odbc_exec

[Reply to this message]