|
|
Posted by Petr Vileta on 10/04/06 04:35
"Mitch" <sumcoolgai@yahoo.com> píse v diskusním príspevku
news:1159933042.541890.95960@c28g2000cwb.googlegroups.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 email='me@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.)
Navigation:
[Reply to this message]
|