Lars P
|
Posted: 10/13/2003, 10:34 PM |
|
Hello all
I am trying to make a search from where I need two of the same search fields like this:
[Min.height] and [Max.Height)
The result of this query return of the group of people between those heights. It seem to me that it is impossible to do this in Codecharge(2.2) without writing code myself.
Has anyone got an idea about this ??
Thanks in advance.
Lars
|
|
|
ryan
|
Posted: 10/14/2003, 12:25 AM |
|
SELECT FieldWhereHeightIs
FROM TableWHEREFieldWhereHeightIs
WHERE (FieldWhereHeightIs>=[Min.height])
AND (FieldWhereHeightIs<=[Min.height])
SELECT FieldWhereHeightIs
FROM TableWHEREFieldWhereHeightIs
WHERE FieldWhereHeightIs
BETWEEN [Min.height] AND [Max.Height]
?
|
|
|
|