Database Results Criteria

[neenmarie]

I'm using FronPage 2003 and have a database that customer's input
information to from a form on line. I download the DB with FTP; but would
like to be able to check results on line first to see if there is any new
info since the last time I downloaded.

The results to show all the data worked fine. I tried to add 'criteria' so
I can enter a date in and have only any submissions show that have a date
greater than the one I entered.

I when in to 'modify criteria'
Field Name: Date
Comparison: Greater Than
Value: ????????? what do I put here?
and/or: ???????? which do I choose?

I get the following error:
====================================
Database Results Error
Description: Data type mismatch in criteria expression.
Number: -2147217913 (0x80040E07)
Source: Microsoft JET Database Engine

One or more form fields were empty. You should provide default values for
all form fields that are used in the query.
====================================
Thank you for your help!

 

[Kathleen Anderson [MVP - FrontPage]]

First, the field in your database should not be named "Date"; that's a
reserved word. - see:
http://support.microsoft.com/default.aspx?scid=kb;en-us;286335

Assuming you rename it to date_entered, your SQL should look something like
this:

SELECT * FROM yourtable where (date_entered >= #::date_entered::#)

Here's a related KB article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;284843&Product=fp2002

--

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

 

[neenmarie]

Thank you for your response. I went to the link you included and changed the
HTML code around the date field I'm submitting from ':ateEntered::' to
#:ateEntered::# ---- but each time I save the page in FrontPage, it
automatically changes it back???? How can I stop it?

 

[Kathleen Anderson [MVP - FrontPage]]

In Code View, make the change in the gray colored code (not the maroon
colored code) and save your change while you're still in Code View.

--

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

 

[neenmarie]

I finally got it right....thank you for your help.

 

[Kathleen Anderson [MVP - FrontPage]]

You're welcome

--

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