Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 8th, 2004, 09:01 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: , , .
Posts: 347
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Adam H-W
Default simple loop question

Hi there

I'm using SQL server 2000 and asp and am using a SELECT statement. I'm looping through the statement and pulling out the records.

I want to pull out the same records furhter on down the page again but it's pulling out only the first record. However, it pulls out the first record and loops it the amount of times records appear in the table.

I'm almost there but not quite.

can anyone help me here?

thanks

Adam

 
Old July 8th, 2004, 01:47 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Hi Adam,

Can you post that part of the code where you feel it goes wrong?

Cheers!

_________________________
- Vijay G
Strive for Perfection
 
Old July 9th, 2004, 01:22 AM
Friend of Wrox
 
Join Date: Nov 2003
Location: Johannesburg, , South Africa.
Posts: 141
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to acdsky
Default

Hi

From experience I normally set variables with the recordset fields. Also in the same order as they appear in the tables. The reason for this is that I have experienced stuff like empty recordset when u move back to a previous field even though u on the same line or only being able to access fileds with Datatypes text once! This might not be ur problem but would be worth having a look at.

Have a look at cursor types:
http://msdn.microsoft.com/library/de...dobjodbrec.asp

Regards
Marnus




Similar Threads
Thread Thread Starter Forum Replies Last Post
not at all simple question petergoodman XSLT 0 July 18th, 2008 08:37 AM
Simple question VBAprutser VB How-To 2 August 20th, 2007 06:00 AM
Simple Nesting Loop PommyTom XSLT 2 June 9th, 2006 02:16 AM
Simple Question JEHalm BOOK: Beginning Access VBA 0 December 29th, 2005 10:42 AM
Select box for loop(probably really simple) interrupt Javascript How-To 2 March 18th, 2005 12:25 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.