by C. David Johnson (2 Submissions)
Category: Databases/Data Access/DAO/ADO
Compatability: VB Script
Difficulty: Unknown Difficulty
Originally Published: Fri 10th November 2000
Date Added: Mon 8th February 2021
Rating: (1 Votes)
ADO include file for Easy ADO calls Set the Recordset name and Call for the array sSQL = "Select * from Authors" GetData vArray Now Contains
Const sDSN = Application("ConncetionString")
Dim vArray
Dim cnADO
Dim rsADO
Dim sSQL
Set cnADO = Server.CreateObject("ADODB.Connection")
Set rsADO = Server.CreateObject("ADODB.Recordset")
Sub GetData
cnADO.Open sDSN
rsADO.Open sSql ,cnADO
vArray = rsADO.GetRows
rsADO.Close
cnADO.Close
set rsADO = Nothing
set cnADO = Nothing
end sub
%>
No comments have been posted about ADO include file for Easy ADO calls Set the Recordset name and Call for the array sSQL = Select * . Why not be the first to post a comment about ADO include file for Easy ADO calls Set the Recordset name and Call for the array sSQL = Select * .