Programming Forums - accessing data in recordset

Programming Forums (http://www.programmingforums.org/forumindex.php)

- ASP (http://www.programmingforums.org/forum32.html)

- - accessing data in recordset (http://www.programmingforums.org/showthread.php?t=7923)

paulchwd

Jan 11th, 2006 10:20 PM

accessing data in recordset

Herees the problem...

I have a recordset (recset) that holds the result of an sql query. The query returned 9 items

I only want to include the first five of those 9 in a table (and the rest of thme in another table later on ) so i did this

sql="select rate from mort"

set recset = adocon.execute(sql) 'note adocon is the connection string



 do while (not recset.eof)



   for i=0 to recset.fields.count-4



    response.write recset(i)



    next



recset.moveNext



loop

When i do this it loads a completely blank page.

can anyone help? :banana:

java_roshan

Jan 22nd, 2006 4:01 AM

I am not sure this, but somewhere at the back of my mind, I remember one of our professor's mentioning about using recset.fields.count is not valid and would not work as it is expected to ...for specific "CONNECTION TYPES"....will try to confirm once I am able to recall that

asp1	Feb 19th, 2006 4:26 PM

I would recommend modifying your query to achieve this.
eg. SELECT TOP 4 * FROM...
However if this isn't possible for any reason try

sql="select rate from mort"

set recset = adocon.execute(sql) 'note adocon is the connection string



 do while (not recset.eof)



   if n<5

   response.write recset(i)

   n=n+1

   end if

   next



recset.moveNext



loop

All times are GMT -5. The time now is 2:14 PM.