search page

boo · July 23rd, 2003, 03:35 PM

I must key in FirstName, LastName and IcNo to searching, and it will display the data from member, how to do it? Can u please modify my coding? It display nothing and why display the admin MemberId? Pls show me clearer..
My coding showing below:

<%
'open the database connection
Set con=Server.CreateObject("ADODB.Connection")
'con.open "Provider=SQLOLEDB.1; Password=; UserID=BOO; Initial Catalog=dta; Data Source=webserver;"
con.open "DSN=dta"

Set rs=Server.CreateObject("ADODB.Recordset")
rs.CursorType=adOpenStatic
rs.CursorLocation=adUseServer
rs.LockType=adLockBatchOptimistic

if trim(request.form("FirstName"))<> " " and _
   trim(request.form("LastName"))<> " " and _
   trim(request.form("IcNo"))<> " " then

sql= "Select * from Member where FirstName=' " &_
    trim(request.form("SFirstName")) &_
    "' and LastName='" & trim(request.form("SLastName")) &_
    "' and IcNo='" & trim(request.form("SIcNo")) & "'"
else
    response.redirect "Error_no_record.asp"
end if

con.close
set con=nothing
set rs=nothing
%>

NotNowJohn · July 24th, 2003, 04:56 AM

You never populate the recordset object in your code. You have to use this statement after you have assigned a value to sql variable:

Code:

rs.Open sql,con

And then I suppose you would like to display retreived records. The following code piece show one way to realize:

Code:

Do Until rs.EOF
    Response.Write rs("MemberID")
    Response.Write ", "
    Response.Write rs("MemberName")
    Response.Write ", "
    Response.Write rs("OtherField")
    Response.Write "<br>"
    rs.MoveNext
Loop

Of course, you have to use your table fileld's names instead.
HTH.

...but the Soon is eclipsed by the Moon