PDA

View Full Version : HELLP!!!!


proTEH
06-09-2006, 07:29 PM
Hello!!
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.Open()

qrysearch _numRows = 0
%>