Help! Help! ASP Form

I've a form that request data from a remote SQL sever when a user enters a
starting date and a ending date on the form. I am not sure why but when the
form opens I get the following error:

Database Results Wizard Error
Description: [Microsoft][ODBC SQL Server Driver]Invalid use of default
parameter
Number: -2147467259 (0x80004005)
Source: Microsoft OLE DB Provider for ODBC Drivers

One or more form fields were empty. You should provide default values for
all form fields that are used in the query.

But the Form works, how can I fixs this problem??

Jim

Kathleen
Fri Mar 31 18:32:54 CST 2006

You could split it up, so the search form is on one page and the results are
on another:
http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp#return

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/


"hrider1@comcast.net" <hrider1comcastnet@discussions.microsoft.com> wrote in
message news:3576E2B1-47C2-47C3-8490-1FA7C9D7D646@microsoft.com...
> I've a form that request data from a remote SQL sever when a user enters a
> starting date and a ending date on the form. I am not sure why but when
> the
> form opens I get the following error:
>
> Database Results Wizard Error
> Description: [Microsoft][ODBC SQL Server Driver]Invalid use of default
> parameter
> Number: -2147467259 (0x80004005)
> Source: Microsoft OLE DB Provider for ODBC Drivers
>
> One or more form fields were empty. You should provide default values for
> all form fields that are used in the query.
>
> But the Form works, how can I fixs this problem??
>
> Jim

p
Fri Mar 31 21:39:19 CST 2006

I prefer Kathleen's suggestion. It is simpler to debug and keep it clean
when you separate the form form the processing page.

You are using a combined page that is includes the form that gets
submitted and also proceses the the form results. If you want to stay
with a single page, you need to provide default dates or logic (code) to
not submit the form if either of the date fields are empty.

..PC

Kathleen Anderson [MVP - FrontPage] wrote:
> You could split it up, so the search form is on one page and the results are
> on another:
> http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp#return
>

Stefan
Sat Apr 01 03:49:07 CST 2006

You don't need to add defaults (or use multiple pages)
All you need to do is wrap the DBRW in a conditional statement that will prevent it from running until you have a value from the
form

In code view

... your query form is here
(with say the form field name is "Search")

<% IF Len(Request.Form("Search") > 0 THEN %>

...DBRW goes here

<% End IF %>
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


"p c" <nospam@nospam.com> wrote in message news:EYmdnZANCOJ6aLDZRVn-sw@comcast.com...
|I prefer Kathleen's suggestion. It is simpler to debug and keep it clean
| when you separate the form form the processing page.
|
| You are using a combined page that is includes the form that gets
| submitted and also proceses the the form results. If you want to stay
| with a single page, you need to provide default dates or logic (code) to
| not submit the form if either of the date fields are empty.
|
| ..PC
|
| Kathleen Anderson [MVP - FrontPage] wrote:
| > You could split it up, so the search form is on one page and the results are
| > on another:
| > http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp#return
| >

p
Sat Apr 01 08:38:28 CST 2006

I agree, Stefan. Thanks for clarifcation.

Isn't a conditional statement "code that prevents submision of the form"?

..PC

Stefan B Rusynko wrote:
> You don't need to add defaults (or use multiple pages)
> All you need to do is wrap the DBRW in a conditional statement that will prevent it from running until you have a value from the
> form
>
> In code view
>
> ... your query form is here
> (with say the form field name is "Search")
>
> <% IF Len(Request.Form("Search") > 0 THEN %>
>
> ...DBRW goes here
>
> <% End IF %>

Stefan
Sat Apr 01 13:23:43 CST 2006

Conditional Statement is anything you want it to be

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


"p c" <nospam@nospam.com> wrote in message news:brKdnQtkY_j5DbPZnZ2dnUVZ_s2dnZ2d@comcast.com...
|I agree, Stefan. Thanks for clarifcation.
|
| Isn't a conditional statement "code that prevents submision of the form"?
|
| ..PC
|
| Stefan B Rusynko wrote:
| > You don't need to add defaults (or use multiple pages)
| > All you need to do is wrap the DBRW in a conditional statement that will prevent it from running until you have a value from the
| > form
| >
| > In code view
| >
| > ... your query form is here
| > (with say the form field name is "Search")
| >
| > <% IF Len(Request.Form("Search") > 0 THEN %>
| >
| > ...DBRW goes here
| >
| > <% End IF %>

garip
Mon Apr 03 09:40:04 CDT 2006

lan oglum adam türkçe yazarda anlarız yav
> not submit the form if either of the date fields are empty.
>
> ...PC
>
> Kathleen Anderson [MVP - FrontPage] wrote:
> > You could split it up, so the search form is on one page and the results are
> > on another:
> > http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp#return
> >
>