Re: Problem with Javascript with TDC control
- From: sheldonlg <sheldonlg>
- Date: Tue, 02 Sep 2008 07:57:54 -0400
sheldonlg wrote:
I have inherited code with a TDC control. In this file, there are two javascripts of interest. One of these is a function, filter(), which is inside
<script language=javascript></script>.
The other is code inside
<script language=javascript FOR=inquiry
event=ondatasetcomplete()></script>
where inquiry is the TDC.
The table displays correctly. The problem is in getting the total after doing a display and then refreshing the TDC (which invokes the script filter() ). That calculation is done in the second script. What happens in there is:
var rs = inquiry.recordset;
extcosttot = 0;
num = rs.Fields.Count;
while(rs.EOF != true)
{
extcosttot += parseFloat(rs(9).value);
rs.moveNext;
}
When I alert inside the while loop, the very first record from before the sorting -- even though the table display properly with the new one.
I tried to put similar looping code at the end of filter() to examine what I get from the TDC refresh, but I got a messages of "Operation is not allowed when the object is closed". When I added an open() for I got "The connection cannot be used to perform this operation. It is either closed or invalid in this context".
I am at a bit of a loss. I have no idea what happens between the end of filter() and the inline script and I have no idea on how to successfully put in code to see what is at the end of filter().
Since there is no code in the generator file for how the sorting is taking place, the problem must be after retrieving the recordset, observing somehow that it was left at a certain column being sorted, and then sorting it accordingly.
I worked my way around to avoid the problem (not by fixing it), but I would still like to know what caused this problem in the first place.
The call of a filter is done in a javascript routine with setting the DataURL and doing inquiry.Reset() where inquiry is the name of the dataset object. When it is complete, it calls another javascript (via using ondatasetcomplete). The getting of this refreshed dataset has no knowledge of any sorting that may have taken place on the columns prior to doing the refresh, and the ondatasetcomplete is done automatically upon getting the refreshed data.
What I would like to know is this:
*************
Why does the looping through the dataset give all the proper records (sorted) except for the first record which is from the unsorted set?
*************
For anyone who may be interested, the way I avoided the problem was to add an extra field to the dataset. In the display page, I set the style of that column to "display:none". In that field, I place the cumulative total for all the records, and all records hold the same total. In the DataURL, I delayed writing of the records by putting them into an array, and at the end of the fetching, modifying all the lines in the array by setting the same cumulative total into that last field. Then I print out the entire array in the appropriate format.
.
- References:
- Problem with Javascript with TDC control
- From: sheldonlg
- Problem with Javascript with TDC control
- Prev by Date: Re: Opera, For In Loop, Same Key Appears Twice
- Next by Date: Re: Struggling with setting iframe height dynamically
- Previous by thread: Problem with Javascript with TDC control
- Next by thread: Re: Modify String.prototype?
- Index(es):
Relevant Pages
|
