Need help with Search Function
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=14210
Printed Date: 30 March 2026 at 10:06am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Need help with Search Function
Posted By: mackers
Subject: Need help with Search Function
Date Posted: 12 March 2005 at 1:35am
|
I'm pullin my hair out here with a search and results function...
I have a search form on every page including the search results page:
<form name="frmSearch" action="searchResults.asp" method="post">
<input name="txtSearch" type="text" class="boxlook" id="txtSearch" value="search" size="14" onFocus="this.value=''">
<input name="btnSubmit" value="Submit" type="image" src="images/arrow2.gif"> </form>
The code on the search results page is:
<%
Dim SearchString SearchString = "" SearchString = Request.Form("frmSearch") %> <% Dim rstResults Dim rstResults_numRows Set rstResults = Server.CreateObject("ADODB.Recordset")
rstResults.ActiveConnection = MM_conn_STRING rstResults.Source = "SELECT * FROM Companies WHERE comName LIKE '%" & SearchString & "%'" rstResults.CursorType = 0 rstResults.CursorLocation = 2 rstResults.LockType = 1 rstResults.Open() rstResults_numRows = 0
%> No matter what is entered in the search box though, the same record (the first) is displayed every time.... I've probably overlooked something really simple but I can't see it... I've been staring at this for hours!!
Please help...
|
Replies:
Posted By: michael
Date Posted: 13 March 2005 at 10:40am
|
SearchString = Request.Form("frmSearch") should be
SearchString = Request.Form("txtSearch") ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: mackers
Date Posted: 13 March 2005 at 11:57am
Duhh
 Ty
|