Re: Date Range filtering trouble

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Thanasis \(sch\) (thanasis_gr_at_hotmail.com)
Date: 06/23/04 

Date: Wed, 23 Jun 2004 12:06:49 +0300

Dear Jim thanks for your response,
i have pasted the SQL statement you provided
SELECT * FROM NEWS
WHERE (PUBLISH_DATE >= #::date1::#)
AND (PUBLISH_DATE <= #::date2::#)
in Custom Query window and i clicked on verify query.Then i got an error
message.
However when i ommited the # character my query work
Why does this happen?
And another question.
When in a text box of my search form i type whatever but a date (i.e a
string), in results page i got an error message from DRW.
Cheers
thanasis

SELECT * FROM NEWS
 WHERE (PUBLISH_DATE >= #::date1::#)
 AND (PUBLISH_DATE <= #::date2::#)

"Jim Buyens" <news@interlacken.com> wrote in message
news:2046e01c458a9$1289baf0$a001280a@phx.gbl...
> Howdy.
>
> Your SQL statement needs to look like:
>
> SELECT * FROM NEWS
> WHERE (PUBLISH_DATE >= #::date1::#)
> AND (PUBLISH_DATE <= #::date2::#)
>
> Jim Buyens
> Microsoft FrontPage MVP
> http://www.interlacken.com
> Author of:
> *----------------------------------------------------
> |\---------------------------------------------------
> || Microsoft Office FrontPage 2003 Inside Out
> ||---------------------------------------------------
> || Web Database Development Step by Step .NET Edition
> || Microsoft FrontPage Version 2002 Inside Out
> || Faster Smarter Beginning Programming
> || (All from Microsoft Press)
> |/---------------------------------------------------
> *----------------------------------------------------
>
> >-----Original Message-----
> >Hello to everyone,
> >
> >i am going to built a database application with DataBase
> Interface Wizard
> >and FrontPage 2003.My DataBase will be Access 2000.
> >Inside my database (mdb file) there is a table whose name
> is NEWS.A field of
> >the table is called PUBLISH_DATE(type DATE).
> >
> >I want the user of my application to provide 2 dates, in
> order to filter the
> >records according to values of the PUBLISH_DATE field.
> >i have followed the steps below:
> >1) i have created a search form with 2 text boxes with
> names DATE1 and
> >DATE2.I save the form as asp page SEARCH.ASP.The method
> parameter is POST
> >and the action is RESULTS.ASP.
> >
> >2)I have created a RESULTS.ASP page which actually
> filters the records
> >according to the user input (from DATE1 to DATE2).
> >I click Insert-->DataBase-->Results-->I choose my
> database and i click on
> >Next-->then i click on Custom Query (Edit) and i type
> >SELECT * FROM NEWS WHERE (PUBLISH_DATE>= date1 AND
> PUBLISH_DATE<= date2).
> >I click next..next and the wizard is closed.
> >Also i tried something like that:
> >SELECT * FROM NEWS WHERE (PUBLISH_DATE>= request.form
> ("date1" AND
> >PUBLISH_DATE<= request.form("date2").
> >
> >However i got an error message from the Wizard.I didn't
> get the filtering i
> >expected.
> >
> >How this can be done with SQL or DIW?
> >Wishes
> >Thanasis
> >
> >
> >.
> >