MarkM
|
| Posted: 01/25/2005, 1:14 PM |
|
I have tried everything I have found in the forums but I still cannot get a date search to work. I used the Search Builder and linked it to the correct database table (mySql). All other search fields work and the displays correctly in the results/detail page. A search for a date always fails. I changed the dbformat to match the field in the database. I have the database date field set to "DATE" (although I tried all the others).
Any help would be greatly appreciated.
PS - I love this product!
|
|
|
 |
mrachow
Posts: 509
|
| Posted: 01/26/2005, 3:58 AM |
|
Two thoughts (only).
Are you sure the entered date will match the stored date (including timestamp)?
If I have a date as parameter for the DataSource of a grid I specify the complete format as well for the database field as for the paramter field on the parameter dialog of the DataSource.
_________________
Best regards,
Michael |
 |
|
MarkM
Posts: 1
|
| Posted: 01/26/2005, 11:55 AM |
|
Yes I believe I have it correct. I am using the DATE type in mysql formatted as 0000-00-00. I have that selected for the dbformat in properties tab. The date format in the properties tab is actually 00-00-0000 and it does display correctly on the screen. When I add a new record, the date is saved correct and formatted correctly in mysql. When I display the data back in detail for the record, the date field is correct. The search string looks like this:
http://localhost/project/NewPage1.php?s_brand=&s_street...storesPageSize=
Does any of this help?
Thanks for the reply!
|
|
|
|
|
