Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #11 (permalink)  
Old April 6th, 2006, 12:32 AM
Imar's Avatar
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 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
Reply With Quote
  #12 (permalink)  
Old April 6th, 2006, 01:10 AM
Friend of Wrox
 
Join Date: May 2005
Location: tehran, tehran, Iran.
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


Reply With Quote
  #13 (permalink)  
Old April 6th, 2006, 02:53 PM
Imar's Avatar
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 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
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off




All times are GMT -4. The time now is 07:23 PM.


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