gpdeering
Posts: 57
|
| Posted: 08/30/2007, 1:04 PM |
|
All:
I have a .NET app that has been successfully running for over a year. However, after upgrading the project to CCS 3.2 and making a change to a grid on my form, it seems that query execution is running prematurely (at least prematurely than from what I had been seeing before the changes).
<Begin Problem Description>
How it used to work:
1. user loads page with a form that is partially visible. (Visible components: two listboxes and several textboxes on form; Invisible components: grid outside of form, 5 panels on form, each of which contain various textboxes.)
2. user selects value from 1st listbox. Javascript refreshes the page with url containing parameter name and value from 1st list box. 2nd listbox is filtered by value of 1st listbox.
3. user selects value from 2nd listbox. Javascript refreshes the page with url containing parameter names and values from both listboxes. During refresh, query on DB executes and fills grid outside form. Based on specific values within one column in grid, the 5 panels on the form can be made visible.
4. (not important to the problem here). user fills in values within panels and submits. Data is sent by net socket ASCII string to third party system.
How it works now:
1. user loads page. Upon loading, query is executed on DB and all records fill the grid outside the form. As a result, all 5 panels are made visible.
2. user selects value from 1st listbox. Javascript refreshes page and grid is filtered down by value from 1st listbox. The panels' Visible attribute is updated by the new recordset.
3. user selects value from 2nd listbox. Javascript refreshes page and grid is futher filtered down by value from 2nd listbox. At this point, the result is identical to way it used to work.
<End Problem Description>
<Begin What I Changed>
Old Version
1. CSS 3.1
2. Grid: each label in the row is inside its own panel (I can't remember why I did that-- I think it came from builder options). The entire grid itself is inside an invisible panel.
New Version
1. Compiled for CSS 3.2
2. New grid generated from builder: No individual panels. The grid is inside an invisible panel.
<End What I Changed>
I understand why the new version app is querying when it does. What I can't understand is why the old version worked the way I wanted it to
--Glen
|
gpdeering
Posts: 57
|
| Posted: 08/30/2007, 1:17 PM |
|
All:
I think I solved my own problem. There is, in fact, a difference in auto-generated code between CCS 3.1 and CCS 3.2.
3.1 Code:
matchedResultsData.UrlProcessToolID = TextParameter.GetParam("ProcessToolID", ParameterSourceType.URL, "", -9999, false)
matchedResultsData.UrlProcessPPID = TextParameter.GetParam("ProcessPPID", ParameterSourceType.URL, "", -9999, false)
3.2 Code:
matchedResultsData.UrlProcessToolID = TextParameter.GetParam("ProcessToolID", ParameterSourceType.URL, "", Nothing, false)
matchedResultsData.UrlProcessPPID = TextParameter.GetParam("ProcessPPID", ParameterSourceType.URL, "", Nothing, false)
When I replace the "Nothing" in the GetParam argument list with "-9999", I get my desired query delay (i.e., the query seemingly is not executed and the grid not filled until after the second listbox has a selected value).
So, now that I fixed my problem, what does this argument mean?
Thanks,
--Glen
|
