valueweb
Posts: 8
|
| Posted: 06/09/2006, 2:01 AM |
|
I have a grid and search form. (php/mysql/linux)
The grid table has a integer field. I want to search for records where that field contains GT x and LT y. With the user obviously supplying x and y.
What's the simplest way to do this ?
|
 |
 |
valueweb
Posts: 8
|
| Posted: 06/09/2006, 2:41 AM |
|
Sorry ! Worked it out for myself...
Just in case it helps anyone else who is a learner, I manually inserted an additional TH/TD in the Search Form HTML , right next to the original, which then gave me two search boxes to use for the same field. I provided new captions, Min (GT) and Max (LT).
I then went into the datasource property for the grid, changed the original sql element relating to the field from "=" to ">=" for the Minimum Range and inserted another element into the sql query comparing the integer field in the record to the new search variable (as inserted in the html) and selected <= from the drop down.
Voila! It works fine
|
|
|
|
|
