|
gmac -> Passing Date Values (3/9/2001 20:55:00)
|
I have loaded all the complex processing into an Access Query prior to creating my DB page. There are two dates I need from the page to produce results. In Access, I can simply create the variables within the query like [date_1],[date_2] and Access will prompt me for the values when the query is executed. Along that train of thought, I created a DRW page based on the query/view and sure enough .. the two "prompt" variables showed up via the "defaults" option. When I published the page and the DRW page, the form and default values are displayed correctly in the form area .. but I get the following error in the results area:
"Database Results Error
Description: The application has improperly defined a Parameter object.
Number: 3708 (0xE7C)
Source: ADODB.Recordset"If I look at the SQL view of my query, here is the portion of code that references the variables...DateValue("[beg_date]") AS BEG_DT, DateValue([end_date]) AS END_DT,
Thanks,
Greg
I searched everywhere prior to post :-)
|
|
|
|
