I've never tried to use operators in Verity criteria--interesting. If you don't get it to work, you can use the verity results as a recordset and just requery it with a Query of Query.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 5:37 PM To: [EMAIL PROTECTED] Subject: Verity and relational operators (Sending this again, cause I do not get the confirmation) I have the following cfsearch: <cfsearch collection="verBV" type="SIMPLE" criteria="(CF_CUSTOM1 >= 10) AND (CF_CUSTOM1 <= 50000)" name="qSearchResults"> Regardless if I use one side or both of the above expressions, the result set returned is all records. If I use explicit instead of simple, it returns all records. I have verified with cfdump that there are numbers within, and out of, the above range of numbers in the cf_custom1 field. Any clues? Kevin Barber ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
