jav
Posts: 8
|
| Posted: 03/29/2007, 12:11 PM |
|
I am trying to dynamically edit my datasource properties for my record, however, it doesn't seem to update the SQL the first time I link to the page.
My recordset defaults its parameters to session variables, but, I want to be able to also access the page via a link, by putting parameters in the url.
My code is as follows on the before build select on for the record
if CCGetParam("xParameter", Empty) <> Empty then
Dim meetingID
meetingID = CCGetParam("xParameter", Empty)
sqlMeeting = "SELECT * FROM table WHERE KeyID = " + cstr(MeetingID)
Record.DataSource.SQL = sqlMeeting
session("sesParameter") = meetingID
end if
I placed the following code on the beforeExecuteSelect section for the record
response.Write("ChangeTest" + cstr(Record.DataSource.SQL))
And the when I enter the page with the xParameter in the url for the first time, the page doesn't populate and the response.write in the beforeExecuteSelect doesn't appear. However, everything works and the reponse.write poulates when I refresh the page in my browser.
Any help would be appreciated.
Thanks.
Jon
|
 |
 |
|
