ODBC String Quoting in odbc_exec

[Mitch]

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 em*******@something.com'
doesn't work.

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

Thanks,

Mitch

[Petr Vileta]

"Mitch" <su********@yahoo.compíse v diskusním príspevku
news:11*********************@c28g2000cwb.googlegro ups.com...

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 em*******@something.com'
doesn't work.

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.)