by shannah » Mon Apr 24, 2006 3:19 pm
Hi Jerry,
Sadly the current "Find Form" is pretty weak on Dataface. I was going to try to do a quick hack just now to get you to be able to do range searches on date fields, but it will require me to make some changes to the QueryBuilder class, so I would prefer to make the changes more carefully and include them with the 0.6.0 release (early May).
In general, you can do range searches using the '..' notation. I.e., if you want to search for products with Prices between 200 dollars and 500 dollars you could put "200 .. 500" in the 'Price' field on the find form. Unfortunately, even if I get the Date field to show up on the find form (which is a simple change), this won't work because MySQL doesn't seem to support searches of the form :
WHERE `DateField` < '2004-04-05' and `DateField` > '2003-04-05' (which is how a query for DateField='2003-04-05 .. 2004-04-05' would be rendered).
As I'll be working on the find form in the next couple of weeks, I'm open to suggestions on how it should work (i.e., what kind of interface would work the best).
-Steve