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.

Reply via email to