Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlWhat
Starting Member
12 Posts |
 Posted - 2006-10-09 : 13:25:53
|
| I have this function that gets data from the DB and inserts into an array for use later. The funny thing is that if you take the same sql statement from the asp page and try it in sql server it gets the correct number of records but the asp page only gets 2 out of the 10 there should be. Exactly the same sql statements. just a copy and paste here is the statementSELECT Title, Contents, Element FROM FolioPages WHERE (Type='css') AND (IVID='1000') AND (Page='home')any thoughtsthanks for the help in advance |
|
|
sqlWhat
Starting Member
12 Posts |
Posted - 2006-10-09 : 14:22:34
|
It seems that I am actually having a problem with my asp code. I use this statement to insert the recordset into an array. All the examples and my previous work is like this so what is the problem?????if not rsCss.EOF then arrayCss = rsCss.GetRows end if inserting it into the array i only get 2 records where if I just iterate through the recordset i get 10 really strange. Thanks for the help |
 |
|
|
|
|
|
works correctly in server 2005 but not in asp page