In your SQL WHERE statement you handle that:
WHERE someField >= '#FORM.fieldNumber#'
Dave
=================================
"Always Drink Upstream From The Herd!"
David Hannum
Web Analyst/Programmer
Ohio University
[EMAIL PROTECTED]
(740) 597-2524
----- Original Message -----
From: Tim Bahlke <[EMAIL PROTECTED]>
To: CFTalk <[EMAIL PROTECTED]>
Sent: Tuesday, April 11, 2000 12:46 PM
I have a field with numbers ranging from 1-5 that I would like my users to
be able to use as a search criteria. If the user wishes to search by 3, for
example, I would like to return anything that was 3 or greater.
Can this be done?
Thanks,
Tim
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to
[EMAIL PROTECTED] with 'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.