criteria Find method

[poornima sudharshan]

Can the String I pass to the criteria Find method be in this fashion -
"Origin airport = 'SFO', Destination airport = 'DEN'";
Why is there a neccessity to use Carrier since the user gets the option to choose only the Origin & Destination from the UI.
Also can I get the 'Origin airport' string & the 'destination airport' string from the database instead of hard coding it?
Please reply,
poornima.

[Matt Cannata]

The idea is to have the Data class be a usable database for different applications. For example, if I was making a clothing inventory system I'd want to be able to pass in something like "Color='Blue'". In order for the search to be successful, you have to be able to match the query columns with something that exists in the database schema (as defined in the FieldInfo[], description)

[poornima sudharshan]

Thanks for the reply Matt,
Can u please clear this for me -
If my task now is to match the String in the query column with the values in the database,
first I get the String in the Query column,then with what String do I concatenate this with?
The Query column might be a String representing Origin,or Destination or carrier,or anything else.

[SMK Reddy]

Hi Poornima
In your comment,
"If my task now is to match the String in the query column with the values in the database, first I get the String in the Query column, then with what String do I concatenate this with?"
Why are you concatenating?, did I missed what you are trying to say?
A criterion represents the matching criteria for single record. Your query string represents tokens of <Column name>=< 'value' >.
Parse these tokens to separate the column names and its value.
Next compare the column value with corresponding DB record column value.
A suggestion is, you can implement a method in the record (DataInfo) object to get the value of a column by passing the column name as an argument. This helps you to sort out the matching records easily.
May be this will help.
[This message has been edited by SMK Reddy (edited June 17, 2001).]
[This message has been edited by SMK Reddy (edited June 17, 2001).]