How to save SQL Query Results into an Array Variable

• HookSQLDBA7

  SSChampion

  Points: 10709

  More actions

  June 14, 2005 at 12:40 pm

  #74933

  Does anyone have an example of using an ActiveX Script to query a SQL Database and save the result set into an array variable? Can you save the results into an array variable? Do you have to save the results into a record set? Please provide a simple example.

  Thanks in advance, Kevin

   

• mike gercevich

  SSCrazy

  Points: 2961

  More actions

  June 15, 2005 at 8:09 am

  #565704

  Have you looked at the ADODB.RecordSet methods GetRows() and GetString()?

  I think this functionality is what you need.  The only question is how do you want to structure your receiving array...

  -Mike Gercevich