p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Classic ASP Databases (http://p2p.wrox.com/forumdisplay.php?f=62)
-   -   Populate Array with SQL query string (http://p2p.wrox.com/showthread.php?t=30946)

nicoleh June 28th, 2005 04:56 PM

Populate Array with SQL query string
 
I need to dynamically build a multi-dimensional array with a set of records from a query string. I have the code to pull the data into a dataset but cannot quite figure out how to populate an array.
example:
strSql = "select fname, lname, phone from employee"
OpenDataSet(dsData2, strSql, "tblReportInfo", strDB)

How do I fill an array with that dataset?




om_prakash June 29th, 2005 08:34 AM

Please check the following tutorial:
http://samples.gotdotnet.com/quickst...ataaccess.aspx

Om Prakash

mkayombo July 6th, 2005 10:16 AM

Try using the split() and join() concepts in asp


happygv July 6th, 2005 02:55 PM

When you use GetRows() it populates the resultset into an array, rather than the usual recordset usage. Hope that helps.

_________________________
- Vijay G
Strive for Perfection


All times are GMT -4. The time now is 08:25 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.