Member Avatar for cool5a1321 
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
  • 1 Contributor
  • 1 Reply
  • 108 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by cool5a1321
Member Avatar for cool5a1321 
''HERE ALL THE DATA IS IN ARRAY IN ONE HIT TO DATABASE
''USE THIS WITH AJAX CONTROLS AND SEE THE DIFFERENCE IN RESPONSE TIME
''MAILME ON:- cool5a1321@gmail.com
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.