classic ASP
-
Hi there i write a simple query in MS ACCESS .. query is working fine in Access Query Pane.. but when i m trying to access data from classic ASP code then recordset is return -1 .. i m surprized why?... query is below SELECT question, faqid FROM ALLQUestions WHERE question Like '*hello*' if i use same query without "like" then it s working. i dont know why? thanks in advance
-
Hi there i write a simple query in MS ACCESS .. query is working fine in Access Query Pane.. but when i m trying to access data from classic ASP code then recordset is return -1 .. i m surprized why?... query is below SELECT question, faqid FROM ALLQUestions WHERE question Like '*hello*' if i use same query without "like" then it s working. i dont know why? thanks in advance
Hi Just replace '*' with '%' This will solve your problem Regards
Tushar kothari
-
Hi Just replace '*' with '%' This will solve your problem Regards
Tushar kothari