I need a bit help for solving this issue.
Theoretically the code is correct ( think), but is does not works properly.
I have 2 files: 1 html file
<form type="GET" action="DROPDOWNDATABASEX.asp">
<input type="text" name="look_for" value="http://www.filosofia.org/rev/bas/bas10115.htm">
<input type="submit" value="Submit">
and 1 .asp file:
strKeyword = Request.QueryString("look_for")
response.write strKeyword & "<br>"
rs.open "SELECT * FROM add0 where url like 'strKeyword' ",con
The message I read after running:
response.write strKeyword = http://www.filosofia.org/rev/bas/bas10115.htm
So it understand what is "strkeyword", but when I use SELECT it does the following message:
Sorry, no matching record was found.
BUT IN DATABASE THE THERE IS A REGISTER = THIS URL !!!
If I use
rs.open "SELECT * FROM add0 where url = 'strKeyword' ",con
= Sorry, no matching record was found.
However, evidently If I use
rs.open "SELECT * FROM add0 where url = "'&strKeyword&'" ",con
It gives all entries with urls of the database, but I need the exactly url I entered!!!
Please, could someone help me?