[thelist] plz help with Getrows()
Peter Brunone (EasyListBox.com)
peter at easylistbox.com
Wed Jul 19 10:19:48 CDT 2006
> Please Advise.
Please show us more of your code :)
What repeats 12 times? Your GetRows? The query? Are you looping? What does the loop look like? Is the category ID what you expect it to be, and if you Response.Write the query and run it against your database, do you get the expected result?
Cheers,
Peter
From: Brian Delaney brian.delaney at mccmh.net
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
More information about the thelist
mailing list