fafa
Posts: 27
|
| Posted: 05/01/2004, 5:59 AM |
|
I am using a gird builder to create a grid table with where condition.
Where condition
In the Data Source property of the grid, add a URL Where parameter: appointment_date greater than or equals(=) date().
It does not retreive the record on or after today?
|
 |
 |
peterr
Posts: 5971
|
| Posted: 05/01/2004, 12:05 PM |
|
Date() is not a URL parameter but an expression, therefore it should be an Expression parameter.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
fafa
Posts: 27
|
| Posted: 05/01/2004, 12:30 PM |
|
I have changed to Expression parameter but it doesn't work.
|
|
|
|
peterr
Posts: 5971
|
| Posted: 05/01/2004, 1:03 PM |
|
This may not be enough information...
What are all the properties of your parameter? How doesn't it work? What are the symptoms of the issue?
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
fafa
Posts: 27
|
| Posted: 05/01/2004, 1:39 PM |
|
I have a "appointment" table with a "appointment_date" field
WHERE condition
appointment_date greater than or equals(=) date().
Field Name : appointment_date
Field Type : Date
Condition : greater than or equal (>=)
Parameter source Name : Date()
Parameter source Type : Expression
Result
It will show the incorrect recordset (i.e. the recordset is less than today).
|
|
|
|
peterr
Posts: 5971
|
| Posted: 05/01/2004, 9:37 PM |
|
Don't know why it wouldn't work then. Here are more questions though:
What is the database type?
What is the programming language? (in case the Date() function doesn't exist in such programming language)
What is the format of the field specified in the database?
What is the database type selected in the Connection -> Design?
What is the database type selected in the Connection -> Server?
What was the SQL when you debugged the code ( http://docs.codecharge.com/studio/html/ProgrammingTechn...yingOutput.html ) ?
Thanks
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
fafa
Posts: 27
|
| Posted: 05/01/2004, 10:41 PM |
|
I am using ASP3.0 and ACCESS 2000.
I find the problem...
Date() returns the incorrect date. It returns 02-Feb-2003
Any idea?
|
|
|
|
peterr
Posts: 5971
|
| Posted: 05/01/2004, 11:30 PM |
|
OK, maybe this will help:
1. Set the "Locale Identifier" property of the CCS project to your language, if not English (click on the project name in Project Explorer then look in the Properties window/panel).
I suspect that this would fix the problem only if your date formatting was wrong and I'm not sure if it can help when the date is completely wrong.
2. You may want to try these links to research your problem:
http://www.google.com/search?q=vbscript+date+function+s...t.microsoft.com
http://www.google.com/search?q=vbscript+functions+date+...t.microsoft.com
3. Examine your Windows system date and regional settings in detail.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
fafa
Posts: 27
|
| Posted: 05/02/2004, 12:49 AM |
|
THANKS FOR YOUR SUGGESTION.
|
|
|
|
