ASP Newbie

130213 · #1 (**permalink**) 05-13-04, 10:43

Hello all,

Ok, i have now finally got my connection to my server..... how can i display the records from thetable?

The code below is as far as i have got , how can i display one of the fields in the table. for example "Cand_First_Name"?

Thankyou.

JNR

<%@LANGUAGE="VBSCRIPT"%>

<%
Dim Recordset1
Dim Recordset1_numRows

Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_audit_STRING
Recordset1.Source = "SELECT * FROM dbo.Adv_Candidates_AUD"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()

Recordset1_numRows = 0
%>

<body>
hello
<% %>

</body>
<%
Recordset1.Close()
Set Recordset1 = Nothing
%>

Seppuku · #2 (**permalink**) 05-13-04, 11:04

Google is a wonderful thing:
http://www.google.com/search?hl=en&l...cordset+object

Code:

If NOT Recordset_1.BOF AND NOT Recordset_1.EOF Then
  While NOT Recordset_1.EOF
    Response.Write Recordset_1("Cand_First_Name") & "<BR>"
    Recordset_1.MoveNext
  WEnd
Else
  Response.Write "No Records Found" 
End If