Making a dynamic array in vbscript whose values are preserved

Question

What I want is an array which would store all the ID values coming from the database.How to do the same?

Can you fetch value from database. If it is post some codes what you've tried — polin
– polin, Commented Oct 20, 2012 at 10:38
Please provide more information. How exactly are the values "coming from the database"? What do you want to do with the values once you retrieved them from the database? — Ansgar Wiechers
– Ansgar Wiechers, Commented Oct 20, 2012 at 10:55

Jan Hansen · Accepted Answer · 2012-10-20 16:30:09Z

1

This is a task for the ADO GetRows method

<%
Dim aRs, oConn, oRS, sSQL
Set oConn=Server.CreateObject("ADODB.Connection")
oConn.Provider = Application("Provider")
oConn.Open Application("Database"), Application("UserName"), Application("Password")
sSQL="SELECT ID FROM yourtable ORDER by ID"
Set oRS = oConn.Execute(sSQL)
if not oRS.eof then
        aRS=oRS.GetRows()
end if
oRS.close
oConn.close
%>

edited Oct 20, 2012 at 16:30

Jan Hansen

2832 silver badges12 bronze badges

answered Oct 20, 2012 at 10:49

AardVark71

4,1042 gold badges33 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Making a dynamic array in vbscript whose values are preserved

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related