Response script with tracking infomation
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 adoRS("trackingid")' This is where I am having the trouble.
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