For my app i am making i need more then one sql querry so how would i go about doing that with out having to keep making the ado con and stuff?
One of my sql querrys is:
<%
'Dimension variables
Dim adoConmaintence 'Holds the Database Connection Object
Dim rsportalmaintence 'Holds the recordset for the records in the database
Dim SQLmaintence 'Holds the SQL query for the database
Dim dblocmaintence
dblocmaintence = "fpdb/jdemirdjian.mdb"
Set adoConmaintence = Server.CreateObject("ADODB.Connection")
adoConmaintence.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath(dbloctop)
Set rsportalmaintence = Server.CreateObject("ADODB.Recordset")
SQLmaintence = "Select * from section where section.ID=1"
rsportalmaintence.Open SQLmaintence, adoConmaintence
%>