drerMoffRor
New Member
\[code\]<html><title>Test</title><body bgcolor="FFFFFF"><%sort = CStr(Request("sort"))search = CStr(Request("search"))Set conn = Server.CreateObject("ADODB.Connection")conn.open "Provider=SQLOLEDB.1;Password=123;Persist Security Info=True;User ID=sa;Initial Catalog=asdf;Data Source=WIN-123"Set rs = Server.CreateObject("ADODB.Recordset")If sort = "ascending" ThenSQL = "select top 50 * from asdf order by Name"ElseIf (search Is Not Nothing)SQL = "select * from asdf WHERE name = '" & search & "'"ElseSQL = "select top 50 * from asdf"End Ifrs.open SQL, conn%><center><form acion="index.asp">Search Name:<input name="search" /><input type="submit" value="http://stackoverflow.com/questions/12103155/Submit" /></form></center>\[/code\]I'm getting an error on my \[code\]Else If (search Is Not Nothing)\[/code\]line, from what I can tell it should work. and of course I also cannot for some reason browse my site on my server to see what the actual error is.