<2> Hi, I have a query like strSearch = "select * from MainTable where title like '%" & strQuery & "%' OR author like '%" & strQuery & "%' ... but when strQuery= d'hooghe it does not work ok, how can I solve this ?? <2> ah bigal'll know it :) <2> Hi, I have a query like strSearch = "select * from MainTable where title like '%" & strQuery & "%' OR author like '%" & strQuery & "%' ... but when strQuery= d'hooghe it does not work ok, how can I solve this ?? <3> escape ' any strings in queries you build with '' (2 x ') <3> strQuery=replace(strQuery,"'","''") <2> thx
<4> why isnt my server.htmlencode(string) doing anything here > http://torg.vphb.se/getcategories.asp?categoryID=0 < (using FireFox if that has anything to do with things) <4> all <li>whatever</li> should be htmlencoded <5> paste your code up there