Reading and Displaying Multiple Fields
The first script showed only one field, to simplify the process and focus on what needed to be done for connection. The following script looks at all nine fields and all the records in the fields. Save the script in your root directory or subdirectory in the root directory.
ReadDB2.asp
<%
Dim hookUp, Conn, ViewRecord, ID, Lname, Fname, Address, City, State, Zip, Phone, Email, display, SQL hookUp= "Driver={Microsoft Access Driver (*.mdb)}; DBQ=d:\Inetpub\Wwwroot\hotJava\javaS.mdb;" Set Conn = Server.CreateObject("ADODB.Connection") Set ViewRecord = Server.CreateObject("ADODB.Recordset") Conn.Open hookUp SQL="SELECT * FROM JavaStable" ViewRecord.Open SQL, Conn Do While Not ViewRecord.EOF ID=ViewRecord("ID") ... |
Get JavaScript Design now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
