View Full Version : Request for txtbox value in SQLquerry...

06-07-2006, 10:01 PM
I create RS querry qrysearch in MS Access DB file. And I put one textbox and one button SUBMIT on web page. How to send value of txtbox for request in querry?
Example... if I enter word CARS in txtbox an push Button SUBMIT I want see all RS CARS in tabel AutoMoto…how to change parametar (value)qrysearch__MMColParam using textbox?
This must be some type of search engine but I' not sure… here is the some of code that my be important for answer… please HELP!!!!!….

Dim qrysearch__MMColParam
qrysearch__MMColParam = "Cars"
If (Request("MM_EmptyValue") <> "") Then
qrysearch __MMColParam = Request("MM_EmptyValue")
End If
Dim qrysearch
Dim qrysearch _numRows

qrysearch = Server.CreateObject("ADODB.Recordset")
qrysearch.ActiveConnection = MM_CONNAM_STRING
qrysearch.Source = "SELECT * FROM qrysearch WHERE AutoMoto LIKE '%" + Replace(qrysearch __MMColParam, "'", "''") + "%'"
qrysearch.CursorType = 0
qrysearch.CursorLocation = 2
qrysearch.LockType = 1

qrysearch _numRows = 0