It is keying on the fact that you left a field blank on the request. If you have that in there it will pull all records with your search criteria and disregard the fact that a field is empty.
Doug ----- Original Message ----- From: "Richard Colman" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, November 29, 2001 8:34 PM Subject: What does like '%%' mean > The studio drill-down wizard is generating SQL code that has a where clause > like: > > Members.First LIKE '%%' AND Members.Last LIKE '%#lastname#%' AND > Members.Company LIKE '%%' AND Members.City LIKE '%%' AND Members.State LIKE > '%%' AND Members.Country LIKE '%%' AND Members.MemberType LIKE '%%' > > I am not getting the results that I expected to get. What exactly does a > condition: > > field like '%%' > > actually filter on? > > Rick Colman > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
