Sorry to bother you again :(
I thought I had it but I now know I have goofed. I can't get this function to work. My page is does either of 2 searches so if Someone can search by either Plan No. Or By Designer.
Intdes=designer var
Intpn= Plan No var
When intdes = something its going thur the intpn comand. and getting kicked out. I know I have somthing with an if, else, else if But can't figure it out.
if intdes <> "" Then
If Not isNumeric(intdes) or trim(intdes) = "" Then
Response.Redirect("default.asp")
else
ForPlan = "Designers Plan"
sET rs_block_user = Server.CreateObject("ADODB.Recordset")
sql_block_user = "SELECT * FROM plan_details WHERE Plan_No LIKE '%" & (intdes) & "%' ORDER BY " & sortBy
end if
else if intpn <> "" Then
If Not isNumeric(intpn) or trim(intpn) = "" Then
Response.Redirect("default.asp")
else
ForPlan = CLng(intpn)
sET rs_block_user = Server.CreateObject("ADODB.Recordset")
sql_block_user = "SELECT * FROM plan_details WHERE Plan_No LIKE '%" & (intpn) & "%' ORDER BY " & sortBy
end if
else
Response.Redirect("default1.asp")
end if
end if
Topic Locked
Posted - 08 November 2005 : 15:35:52
