|
| |
|
|
gmac
Posts: 16
From: Novato, CA, USA
Status: offline
 |
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 :-)
|
|
|
|
Elecia
Posts: 68
From: orlando
Status: offline
|
RE: Passing Date Values - 3/9/2001 20:01:00
Could you post the whole SQL string and I'm unclear about how you are passing the variables if you could post the url so I could get a look at the interface that would help me.
EE
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 