Need help creating a table search

Tifa · Mar 9, 2003

I am trying to create a table search where when you type in a person's last name, the form will search the table and display the listings with the matching last name. However, I can't get it to display the results. Here is my ASP:

<body>
<% FindName = Request.Form("LastName&quot

%>

<p align="center"><b>Database Search</b></p>
<form method="POST" name="search" action="database.asp">

<p align="center">
<b>Last name :</b>
<input type="text" name="Name" size="20"><input type="submit" value="Find" name="B1"></p>
</form>

<%
Set CNObj=Server.CreateObject("ADODB.Connection&quot

CNObj.Open "DBQ=e:\ajord461\4280\contacts.mdb;DRIVER=Microsoft Access Driver (*.mdb)"
Set RSObj=Server.CreateObject("ADODB.Recordset&quot

SQLString = "SELECT * FROM Personal WHERE LastName = '" & FindName & "'"
RSObj.Open SQLString,CNObj

Do While Not RSObj.EOF %>

<table>
<tr>
<td><%=RSObj.Fields("LastName&quot

%></td>
<td><%=RSObj.Fields("FirstName&quot

%></td>
<td><%=RSObj.Fields("MiddleName&quot

%></td>
<td><a href="mailto:<%=RSObj.Fields("Email&quot

%>">
<%=RSObj.Fields("Email&quot

%></a></td></tr>

<% RSObj.MoveNext
Loop

RSObj.Close
CNobj.Close
%>

</table>

</body>

It is searching the table but not displaying the results. Anyone know what could be wrong? Thanks for the help!

khazmir · Mar 9, 2003

I think to display the values you either need to add ".value"

<%=RSObj.Fields("LastName&quot

.value%>

or remove ".Fields"

<%=RSObj("LastName&quot

%>

medic · Mar 10, 2003

Try modifying your SELECT statement into something like:

Code:

SELECT * FROM Personal WHERE Trim(LastName) = '&quot; & Trim(FindName) & &quot;'&quot;

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Need help creating a table search

Tifa

Programmer

khazmir

Programmer

medic

Programmer

Similar threads

Part and Inventory Search

Sponsor