dim m_sdata
con.open
set rsDynQuery=con.execute(sqlQuery)
if not rsDynQuery.eof then
m_sdata = rsDynQuery.getrows()
end if
set rsDynQuery=nothing
con.close
''ALL THE DATA IS IN ARRAY NAMED m_sdata.THIS TECHNIQUE IS VERY POWERFUL TRY THIS IF ''YOU ARE GETTING SICK WITH SCRIPT TIMEOUT ERRORS ON CLASSIC ASP
''IT WILL HIT ONLY 3 TIMES TO DATABASE WHATEVER NO OF RECORDS YOU CALL
''USE IT AND SEE THE PAGE LOADING TIME YOU WILL FEEL THE DIFFERENCE
''CONNECTION REMAINS OPEN TILL YOU ITERATE THROUGH RECORD SET
if IsArray(m_sdata) then
for i = LBound(m_sdata,2) To UBound(m_sdata,2)
response.write m_sdata(0,i) & "MULTIDIMENSIONAL_ARRAY" &m_sdata(1,i)& "ONLY_THREE_HITS_TO_DATABASE_UNDER_ANY_NO_OF_COLUMNS_OR_ROWS" &m_sdata(2,i)
next
end if
Erase m_sdata
cool5a1321
0
Newbie Poster
cool5a1321
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.