anyone can help? my this code not working
<%
'Declare variables'
Dim objConnection
Dim objRecordset 'Create objects'
Set objConnection = Server.CreateObject('ADODB.Connection')
Set objRecordset = Server.CreateObject('ADODB.Recordset') 'Open connection and run query'
objConnection.open "database"
objRecordset.Open 'SELECT * FROM STUDENTS', objConnection While Not ObjRecordset.EOF
Response.Write( objRecordset ('Adm_No') & ' ')
Response.Write( objRecordset ('Name') & '<br>' )
Response.Write( objRecordset ('HomeTel') & '<br>' )
Response.Write( objRecordset ('Course_Code') & '<br>' )
Response.Write( objRecordset ('Race') & '<br>' )
Response.Write( objRecordset ('Sex') & '<br>' )
objRecordset.MoveNext
Wend
%>
</body>
</html>
Code:
<html><body> <%
'Declare variables'
Dim objConnection
Dim objRecordset 'Create objects'
Set objConnection = Server.CreateObject('ADODB.Connection')
Set objRecordset = Server.CreateObject('ADODB.Recordset') 'Open connection and run query'
objConnection.open "database"
objRecordset.Open 'SELECT * FROM STUDENTS', objConnection While Not ObjRecordset.EOF
Response.Write( objRecordset ('Adm_No') & ' ')
Response.Write( objRecordset ('Name') & '<br>' )
Response.Write( objRecordset ('HomeTel') & '<br>' )
Response.Write( objRecordset ('Course_Code') & '<br>' )
Response.Write( objRecordset ('Race') & '<br>' )
Response.Write( objRecordset ('Sex') & '<br>' )
objRecordset.MoveNext
Wend
%>
</body>
</html>