Hi everyone,
I�ve read a number of posts regarding the find mechanism and have ended up making myself more uncertain than before.
I�ve tried to make my database layer as generic as possible, therefore I written my find method to support searching of criteria against all fields, and limit the search to name/location within the GUI layer.
The doubt that I�ve got ringing in the back of my head is do we need to support logical �AND� and �OR� conditions. I�ve currently only implemented the �AND� condition, so any records must match criteria for all fields that are not null.
My reason for this is that I can not see a sensible (or simple) way of implementing the �OR� condition with the current find method signature, and from an application point of view it doesn�t make sense to me to support a search where you could allow the user to select a name of a hotel OR and location.
However one of my
must requirements is :
Must allow the user to search data for all records, or for records where the name and/or location.
To me this requirement just means that the user can select :
Just the nameJust the locationBoth name and location Is this how you have interpreted the requirement? I�m trying to keep everything as simple as possible, and feel that the find method signature does enable the support of a complex search that you may find in a SQL database.
Thanks
Jason
[ March 13, 2006: Message edited by: Jason Moors ]