Response script with tracking infomation

dmaldonado · September 29th, 2005, 11:39 AM

I have created a script that would allow someone to track their order status, ie. ups tracking number. However I am having trouble writing the right code to send to their browser. This is what I have so far:

Orderno = Trim(Request.Form("Ordernumber"))

Set adoRS = Server.CreateObject("ADODB.Recordset")

sSql = "SELECT * from otracking where orderno='" & Ordernumber & "'"
Set adoRS = db.Execute(sSQL)

If adoRS.EOF THEN
Response.Write "<BODY BGColor=beige>"
Response.Write "<CENTER><H1>Your Customer Number has not been found.</H1></CENTER><BR>"

Else Response.Write "<b>Your Order Tracking Infomation is as follows:<b><br>"
      Response.Write "<BR>"
      Response.Write adoRS("trackingid")' This is where I am having the trouble.
      adoRS.MoveNext

End if

IF Err.number <> 0 then
Response.Write "Error loading information<BR>" & vbcrlf
Response.Write "Please check the number and try again"
Response.Write "Description:" & err.Description
err.Clear
Response.End
End If