Hayward
|
| Posted: 11/11/2002, 4:20 AM |
|
I have a Grid MyGrid and it has one Parameter MyDate.
I need the grid to start off with a default of todays date if it does not get a date in the URL.
Can anyone tell me which event and how I change the SQLParameter.
I have tried the BeforeExecuteSelect Event and added
----------------------------------------------
If IsEmpty(Request.QueryString("MyDate") Then
LocalMyDate = Date
MyGrid.DataSource.Parameters("urlMyDate") = LocalMyDate
End If
----------------------------------------------
But that doesn't seem to have an effect.
TIA Hayward
|
|
|
 |
Edd
|
| Posted: 11/11/2002, 11:46 PM |
|
The problem is that the SQL is already contructed by the time you execute the BeforeExecuteSelect event.
To change a parameter move it the BeforeBuildSelect and it should work.
Also according to Adam at CCS watch out that the date formats are exactly the same as the URL's format.
|
|
|
|
|
