when i run the code on my ho0me pc it works fine but when i upload the same file it gives this error io could nto get it why plz help
Microsoft VBScript compilation error '800a0401'
Expected end of statement
Erorr in this search file name is Search.asp

<FORM action="Search_Result.asp" method=POST id=form1 name=form1>
<select name="nm">
<%
dim objConn,my_sql,Rs
my_sql="Select name from Teaching order by name"

Set objConn=Server.CreateObject("ADODB.Connection")
objConn.Open ("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("School.mdb"))

Set Rs=objConn.Execute(my_sql)
do while not Rs.EOF
Response.Write "<option value='" & Rs("Name")& "'>"
Response.Write Rs("Name")
Rs.MoveNext
loop
Rs.Close
Set objRs=nothing
objConn.close
Set objConn=nothing

%>

no if statements yeah it gives errors somthing like this or on this line i mean
Microsoft VBScript compilation error '800a0401'

Expected end of statement

Search.asp, line 19

Response.Write ( objRs("Name") ) objRs.MoveNext
------------------------------------^
eriler it was givening error on braces which i included after response.write ok thanx in advance for lookign into the problmes

Are you using RS or objRs? _________________________
- Vijay G
Strive for Perfection

Vijay is right, you need to use RS, because you have RS defined throughout. However, the code that it's giving you the error for is not the code you posted. The code you posted should be Rs not objRS, and it is in different form than the code posted.

Brian

Has that been resolved?

_________________________
- Vijay G
Strive for Perfection