|
Re: change date parameter value from script [message #1075666 is a reply to message #1075293] |
Mon, 29 July 2013 20:55 |
|
You can modify your query in the beforeOpen script method. So, one thing you could do would be to set the query to "select your_fields from your_tables" then in the beforeOpen, do something like:
this.queryText = this.queryText + " where myDate between '" + formattedStartDateString + "' and '" + formattedEndDateString + "'";
Prior to this script, you could check your parameter values to be sure they are correctly done and format the date string.
Michael
Developer Evangelist, Silanis
|
|
|
|
Re: change date parameter value from script [message #1076010 is a reply to message #1075704] |
Tue, 30 July 2013 14:12 |
|
Okay. So, you just need to compare the entered start parameter to the system date returned by the first dataSet? Then based on that, determine which value to show in your masterpage? If so, there are several things you could do, probably. One would be to bind the text box that you're displaying the date in your masterpage with to your systemdate dataSet. You'll have access to the data then and can compare this date and the parameter value to determine which one to show.
Hope this helps.
Michael
Developer Evangelist, Silanis
|
|
|
Powered by
FUDForum. Page generated in 0.02925 seconds