DRW date Default Value

[Guest]

FP2002 web with Access 2002 DB

I have a DBR section that displays results based on 2 drop down criteria
fields - a text field and a date field. I'm having trouble setting an "all"
default value for the date field. I've tried the % and "1 OR 1" but neither
worked.

Can you please tell me the syntax to use to set an all values default value
for the date field which is used as a criteria for the Database Results
displayed? I've searched for the proper syntax to use but have not been able
to find the solution.

 

[Kathleen Anderson [MVP - FrontPage]]

Hi Maureen:
When you are querying a date field, you need to change the apostrophes to
number signs in the SQL SELECT statement:
http://support.microsoft.com/default.aspx?scid=kb;en-us;284843 That said,
I think you would then use the % sign.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

 

[Guest]

Maureen,
I had the same problem with a number field (instead of a date field). I
tried removing the apostrophes :number:: instead of '::number::'), using
the number sign # instead, but nothing worked. Somewhere on the microsoft
site I read that you can only use the LIKE % to compare it with a text field
not a number or date field.

In the end I solved it by redefining the number field in my Access database
as a text field. However I did have to rerun the DBRW after that. Good luck!

Margot

 

[Guest]

Thanks again Kathleen for good direction. I had seen this article before but
wasn't reading it correctly until now...at least I think I've read it
correctly this time. I made the change described in the KB article - ost of
the code follows:

s-sql="SELECT * FROM tblSchdScores WHERE (Division LIKE '%:ivision::%' AND
Dte = #:te::#) ORDER BY Dte ASC,GTime ASC,Division ASC"

I have the default values set to % in the DBR drop down box named DTE that
serves as the criteria submitted via a form above the DBR area

Database Results Error
Unable to find operator in query string. Query string currently is SELECT *
FROM tblSchdScores WHERE (Division LIKE ? AND Dte = #:te::#) ORDER BY Dte
ASC,GTime ASC,Division ASC

Can you offer any further direction to assist me in this? THANKS VERY MUCH!

Unfortunatley, I'm getting the following error message in the DBR area when
I try to let the default value of % pass with the DTE field (If I select a
valid date from the drop down list it works, but I can't get the option of
select all = % to work).

 

[Kathleen Anderson [MVP - FrontPage]]

I am going create a database with your table and fields in it and see if I
can get it to work.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

 

[Kathleen Anderson [MVP - FrontPage]]

So far, I am not having any luck adding an "All Values" Item to the date
dropdown list. The two options listed in this KB article
http://support.microsoft.com/kb/825453 % (for Text fields) and 1 OR 1
(for numeric fields), do not work.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others