Wrox Programmer Forums
|
Classic ASP Professional For advanced coder questions in ASP 3. 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 Professional 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 April 6th, 2006, 12:32 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

It would help if you'd provide the real error message, and some code that causes the error.

Anyway, an EOF error is probably good. This means that the object returned from the array is indeed a recordset. So, all you need to do is check for EOF before you call MoveNext or MoveFirst.

Why do you need 11 recordsets in an array? Can't you execute 11 separate statements, or combine a few queries?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
 
Old April 6th, 2006, 01:10 AM
Friend of Wrox
 
Join Date: May 2005
Posts: 201
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to hastikeyvan
Default

Hi Imar
thank you for your Reply.I think if i explain what should i do it whould be better:
this is a project that has 11 type units.and each unit has some parts(about 200 part in each).I saved these parts for these 11 units and the way they should be in a table called a for example

these 11 type of units are 50 units in quantity.It means i have 50 unit with 11 different types.I saved the actual values of these 50 units in a table called b for example

and these units have date to finish that is saved in a table called c

I want to have 11 recordset for each of those 11 type of unit that contains the way that these units should be and the actual for calculating the delay of each part.

because of this i creat 11 recordset that inner join a and b with the part names and then innerjoin them with c with the unit numbers not unit types(because i should have the delay of each unit number)
that's the thing i should make .i hope I complained it in a way that I can get your helps.excuse me if i take you time so much
thank you for your helps


 
Old April 6th, 2006, 02:53 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

It must be me, but I have no idea what you're talking about.... ;)

Can't you just execute each recordset when you need it? Why do you need to store all this stuff in an array?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004









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