select * from table where id=!&" and mysql complains!
all you need to do is to enclose the "strange id strings" in single quotes,
and watch out for special characters, of which there are several in mysql
I'm sorry, but my last post should have said MS sql and not mysql!
in that case, the only character that you need to worry about is the single
quote
make sure you use a fixed width font to view the following...
all of these have no problem at all --
WHERE id = '!#^'
WHERE id = '$%"'
WHERE id = '!!"'
WHERE id = '#"&'
the only time you'd need to worry is when one of the 3 characters in the ID
is a single quote
WHERE id = '!''^'
see that? the enclosed single quote needs to be represented by two single
quotes in succession
by the way, this is the Standard SQL approach -- two consecutive single
quotes inside a string represents one single quote character
rudy
http://r937.com/
____ The WDVL Discussion List from WDVL.COM ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
Send Your Posts To: wdvltalk@lists.wdvl.com
To change subscription settings, add a password or view the web interface:
http://intm-dl.sparklist.com/read/?forum=wdvltalk
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.