[thelist] plz help with Getrows()
Brian Delaney
brian.delaney at mccmh.net
Wed Jul 19 08:30:38 CDT 2006
I am using this code to convert a SQL recordset rsServiceList1 to an
array for comparison.
Set rsServiceList1 = Server.CreateObject("ADODB.Recordset")
strSQL1 = "Select * from Services where catagoryid = " & "'" &
mid(rsCatagoryList("ID"),2,36) & "'" & " order by name "
rsServiceList1.Open strSQL1, ResourceCatalogDBConn
rsServiceList1 could contain 4 or up to 20 rows. Example - ID,Name for
each row. The first time it returns the correct amount of 4.
The problem is that this repeats 12 times and it only returns 4 every time.
DBServicesArray1 = rsServiceList1.GetRows
Please Advise.
thanks
*
*
*
This message, including any attachments, is intended solely for the use of the named recipient(s) and may contain confidential and/or privileged information. Any unauthorized review, use, disclosure or distribution of this communication(s) is expressly prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy any and all copies of the original message.
More information about the thelist
mailing list