Help in Writing a Query|
webmagi | Posted 4:06pm 14. July 2009 Server Time |
I need help in writing VB query script to search for an exact item such as id=10 in an Access database. I don't want it to come up with results such as 110, 210, etc.
I just need it to locate a record associated with a specfic number.
Thank you in advance!
ronmuir | Posted 0:28am 20. July 2009 Server Time ||
Are you just looking for the SQL statement?
MYSQL = "SELECT * " &_
"FROM myDatabase " &_
"WHERE ID = 10"
webmagi | Posted 8:50am 22. July 2009 Server Time |
ronmuir, thank you for your reply. Actually what I am trying to accomplish is to do a query of a database using a search term in a URL.
It would then search an Access database and come back with a single or exact result. It currently searches the database and comes back with several results that includes "10" such as "110", "100", "310" etc.
Thank you for your assistance.
GhostWolf | Posted 10:30am 30. July 2009 Server Time |
A minor modification of ronmuir's suggestion above:
mySQL = "select * from TheDataBase where ID=" + request.querystring("id")
Unless the ID field is alpha, then you'd use:
mySQL = "select * from TheDataBase where ID='" + request.querystring("id") + "'"
webmagi | Posted 3:44pm 20. August 2009 Server Time |
The suggestions above sound like what I need. I am somewhat of a novice when it comes to writing scripts. I have basically modified some code that I inherited but I can't quite figure out how this new code fits in. Is there a chance that I could email my current code to someone to see if anyone could lend me a hand? My email address is posted on my profile. Thank you!
Reply to Post Help in Writing a Query