Need Help please
Does the Server.URLEncode can't deal with the apostrophe '
I have a catalogue with some items having in its name an '
It gives error when trying to read it from database
please try clicking on any item with an ' in its name here:
http://www.american-balloons.com/
The Item name is Yes! I'm a girl,
I use this code while reading its name from database
<%=server.URLEncode(RSpecial("ItemE"))%>
it is translated to:
Yes%21+I%27m+a+Girl
but when read i get this error
Syntax error (missing operator) in query expression 'Show = 'y' AND CategoryE = 'Microfoil Balloons' AND ItemE = 'Yes! I'm a Girl' ORDER BY ID DESC;'.
so, it is again back to the ' while getting read from the database and not %27
any help
n.b. i'm using Access Database
Edited by zMaestro
Topic Options
Post Options
Thanks(0)
