Programming Forums > Web Development and Design > ASP

paulchwd · Jan 11th, 2006, 10:20 PM

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

(Toggle Plain Text)

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

(Toggle Plain Text)

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

Jan 11th, 2006, 10:20 PM	#1
paulchwd Hobbyist Programmer Join Date: Mar 2005 Posts: 139 Rep Power: 4	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 (Toggle Plain Text) 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 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:

Jan 22nd, 2006, 4:01 AM	#2
java_roshan Professional Programmer Join Date: Mar 2005 Location: Student of University of Mumbai, Maharashtra State, India Posts: 344 Rep Power: 4	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 __________________ Visit: http://www.somaiya.edu

Feb 19th, 2006, 4:26 PM	#3
asp1 Newbie Join Date: Feb 2006 Posts: 7 Rep Power: 0	I would recommend modifying your query to achieve this. eg. SELECT TOP 4 * FROM... However if this isn't possible for any reason try (Toggle Plain Text) 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 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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Programming Forums > Web Development and Design > ASP

accessing data in recordset