What does these means?

can anyone tell me what this means? please!!


Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open Application("strConnect")
strList = "select tbl_dep.ch_depid, ch_depname from tbl_dep ORDER by ch_depname"
Set objRs = Server.CreateObject ("ADODB.Recordset")
objRs.Open strList, objConn

while not objRs.eof

Response.Write "<li><a href='#"&objRs("ch_depid")&"'>"&objRs("ch_depname")&"</a></li>"

objRs.movenext
wend

This is an ASP code snippet that opens a connection to a database, then queries that database to return a recordset of data which is then looped though to display as a list on the browser.

What does 'wend' means? its at the end of the code...

It close the WHILE loop and is short for WHILE END.

You would be better off visiting a tutorial site than asking questions about language syntax here. Try visiting w3schools.com for a start.

Thanks for the tips. Will come back if i still got problem with asp.

No problem. Happy to help, but there are better resouces for you out there for questions like this.

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/medical/viewStaffInfo_1.asp, line 4


-----------------------------------------------------------
line 4 is ( conn.open Application("strConn") )
How to fix this? What driver to install?

What's the connection string value in the application variable strConn?

Line2 dim conn,rs
Line3 set conn=Server.CreateObject("ADODB.Connection")
Line4 conn.open Application("strConn")
.
.
.
sql = " select * from staff"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open sql, conn

something like this....

OK, this line:
conn.open Application("strConn")
says:

If you do not have an application level variable called strConn then you are going to get errors like the one you have.