This topic is locked

How can we use between in the search

6/8/2007 8:30:42 PM
ASPRunnerPro General questions
Alberto author

Sergey, is it posible to expan the search posibilities to include:
Between: So the user can see the date range the have entered
IN or Exists: in the seacch and advanced search, so the can type several values separetd by "," and the Where can work like this

where Field1 IN ('Value1', Value2', 'Value3') for example?
Thanks

Sergey Kornilov admin 6/9/2007

Alberto,
if you have a personal question to me - drop me an email.
Between search is implemented already.
IN search can be implemented as a Lookup wizard with multiple selection.

This option builds the following WHERE clause:

where Field1 = 'Value1' or Field1 = Value2' or Field1 = 'Value3'