|
 |
asp_database_setup thread: Exception error -Help
Message #1 by "Crystal Georgia" <crystal43@h...> on Mon, 29 Oct 2001 21:48:59 +0000
|
|
Hi
I need to write code to go thru' some loop statements while
objr1("a") = varb
objr1.movenext
the first recordset is printed correctly ,but in the second round, the error
occurs. sometimes the error occurs even the first time.please help.
Thanks
Crystal
Message #2 by "Ken Schaefer" <ken@a...> on Tue, 30 Oct 2001 13:37:53 +1100
|
|
What is the error? (or are we supposed to guess?)
Are you checking for .EOF?
Secondly, you say "the first recordset is printed correctly", but I don't
see any code here that prints anything...
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Crystal Georgia" <crystal43@h...>
Subject: [asp_database_setup] Exception error -Help
: Hi
: I need to write code to go thru' some loop statements while
: objr1("a") = varb
: objr1.movenext
:
: the first recordset is printed correctly ,but in the second round, the
error
: occurs. sometimes the error occurs even the first time.please help.
: Thanks
: Crystal
:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
:
Message #3 by "Crystal Georgia" <crystal43@h...> on Tue, 30 Oct 2001 16:13:50 +0000
|
|
Hi
I am getting an exception error.
I have 2 recordsets objr1 & objr2.
i am comparing objr1(dist_id) with objr2(dist_id)
That's when I get the exception error.
Thanks
Crystal
>From: "Ken Schaefer" <ken@a...>
>Reply-To: "ASP Database Setup" <asp_database_setup@p...>
>To: "ASP Database Setup" <asp_database_setup@p...>
>Subject: [asp_database_setup] Re: Exception error -Help
>Date: Tue, 30 Oct 2001 13:37:53 +1100
>
>What is the error? (or are we supposed to guess?)
>Are you checking for .EOF?
>
>Secondly, you say "the first recordset is printed correctly", but I don't
>see any code here that prints anything...
>
>Cheers
>Ken
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>From: "Crystal Georgia" <crystal43@h...>
>Subject: [asp_database_setup] Exception error -Help
>
>
>: Hi
>: I need to write code to go thru' some loop statements while
>: objr1("a") = varb
>: objr1.movenext
>:
>: the first recordset is printed correctly ,but in the second round, the
>error
>: occurs. sometimes the error occurs even the first time.please help.
>: Thanks
>: Crystal
Message #4 by "Ken Schaefer" <ken@a...> on Thu, 1 Nov 2001 13:33:23 +1100
|
|
I'll ask once more:
Question 1:
What error are you getting? Please cut and paste the *exact* error message
you are seeing on the screen.
Question 2:
Are you checking for .EOF?
Question 3:
You say you are "printing the 2nd record" - where is the code that prints
the record? I don't see any code that prints a record
Question 4:
You say " I have 2 recordsets objr1 & objr2.i am comparing objr1(dist_id)
with objr2(dist_id) That's when I get the exception error." - where is the
code that compares the two records? All I see is this:
: >: objr1("a") = varb
This code *updates* a field in a recordset, so that the field now equals the
value in the variable called varb. There is no comparison code here
If you want help, please *post* relevant code. Please answer questions that
are asked. Please be as clear as possible on the problem you are having.
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
----- Original Message -----
From: "Crystal Georgia" <crystal43@h...>
To: "ASP Database Setup" <asp_database_setup@p...>
Sent: Wednesday, October 31, 2001 3:13 AM
Subject: [asp_database_setup] Re: Exception error -Help
: Hi
: I am getting an exception error.
: I have 2 recordsets objr1 & objr2.
: i am comparing objr1(dist_id) with objr2(dist_id)
: That's when I get the exception error.
: Thanks
: Crystal
:
:
: >From: "Ken Schaefer" <ken@a...>
: >Reply-To: "ASP Database Setup" <asp_database_setup@p...>
: >To: "ASP Database Setup" <asp_database_setup@p...>
: >Subject: [asp_database_setup] Re: Exception error -Help
: >Date: Tue, 30 Oct 2001 13:37:53 +1100
: >
: >What is the error? (or are we supposed to guess?)
: >Are you checking for .EOF?
: >
: >Secondly, you say "the first recordset is printed correctly", but I don't
: >see any code here that prints anything...
: >
: >Cheers
: >Ken
: >
: >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: >From: "Crystal Georgia" <crystal43@h...>
: >Subject: [asp_database_setup] Exception error -Help
: >
: >
: >: Hi
: >: I need to write code to go thru' some loop statements while
: >: objr1("a") = varb
: >: objr1.movenext
: >:
: >: the first recordset is printed correctly ,but in the second round, the
: >error
: >: occurs. sometimes the error occurs even the first time.please help.
: >: Thanks
: >: Crystal
Message #5 by "Crystal Bradley" <crystal43@h...> on Wed, 31 Oct 2001 15:59:07 +0000
|
|
Hello
Here is a more detailed version:
Recordset objr1 -parent
objr2 - child
objr3- grandchild
From objr1 - get the group_id
from objr2 - get the lineitem_uid
there are 1 or many lineitem_uid fro every group_id
from objr3 - get distribution_id
for every lineitem_uid there are 1 or more distribution_id.
from objr3 - need to display code/ values .
there are exactly 6 codes .
code value
1 100
2 5
3 1001
4 61000
5 0188
6 1000
I'm writing ASP code and accessing data from SQL server. I'm relatively new
to this and truly stuck. any help would be greatly appreciated.
Thanks
Crystal
>From: "Ken Schaefer" <ken@a...>
>Reply-To: "ASP Database Setup" <asp_database_setup@p...>
>To: "ASP Database Setup" <asp_database_setup@p...>
>Subject: [asp_database_setup] Re: Exception error -Help
>Date: Thu, 1 Nov 2001 13:33:23 +1100
>
>I'll ask once more:
>
>Question 1:
>What error are you getting? Please cut and paste the *exact* error message
>you are seeing on the screen.
>
>Question 2:
>Are you checking for .EOF?
>
>
>Question 3:
>You say you are "printing the 2nd record" - where is the code that prints
>the record? I don't see any code that prints a record
>
>
>Question 4:
>You say " I have 2 recordsets objr1 & objr2.i am comparing objr1(dist_id)
>with objr2(dist_id) That's when I get the exception error." - where is the
>code that compares the two records? All I see is this:
>: >: objr1("a") = varb
>
>This code *updates* a field in a recordset, so that the field now equals
>the
>value in the variable called varb. There is no comparison code here
>
>
>If you want help, please *post* relevant code. Please answer questions that
>are asked. Please be as clear as possible on the problem you are having.
>
>Cheers
>Ken
>
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>----- Original Message -----
>From: "Crystal Georgia" <crystal43@h...>
>To: "ASP Database Setup" <asp_database_setup@p...>
>Sent: Wednesday, October 31, 2001 3:13 AM
>Subject: [asp_database_setup] Re: Exception error -Help
>
>
>: Hi
>: I am getting an exception error.
>: I have 2 recordsets objr1 & objr2.
>: i am comparing objr1(dist_id) with objr2(dist_id)
>: That's when I get the exception error.
>: Thanks
>: Crystal
>:
>:
>: >From: "Ken Schaefer" <ken@a...>
>: >Reply-To: "ASP Database Setup" <asp_database_setup@p...>
>: >To: "ASP Database Setup" <asp_database_setup@p...>
>: >Subject: [asp_database_setup] Re: Exception error -Help
>: >Date: Tue, 30 Oct 2001 13:37:53 +1100
>: >
>: >What is the error? (or are we supposed to guess?)
>: >Are you checking for .EOF?
>: >
>: >Secondly, you say "the first recordset is printed correctly", but I
>don't
>: >see any code here that prints anything...
>: >
>: >Cheers
>: >Ken
>: >
>: >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>: >From: "Crystal Georgia" <crystal43@h...>
>: >Subject: [asp_database_setup] Exception error -Help
>: >
>: >
>: >: Hi
>: >: I need to write code to go thru' some loop statements while
>: >: objr1("a") = varb
>: >: objr1.movenext
>: >:
>: >: the first recordset is printed correctly ,but in the second round, the
>: >error
>: >: occurs. sometimes the error occurs even the first time.please help.
>: >: Thanks
>: >: Crystal
|
|
|
View Cart
