var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: ASP Newbie
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"?
<!--#include file="../Connections/audit.asp" -->
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_numRows = 0
Set Recordset1 = Nothing
Google is a wonderful thing:
If NOT Recordset_1.BOF AND NOT Recordset_1.EOF Then
While NOT Recordset_1.EOF
Response.Write Recordset_1("Cand_First_Name") & "<BR>"
Response.Write "No Records Found"
That which does not kill me postpones the inevitable.
Here is the reference book:
Beginning ASP Databases, by John Kauffman, Wrox
I know it must be a pain... but people have got to start somewhere!