Thanks to both Michael Dawson and Michael Tangorre. I ended up using the following and it worked great. filter = "(&(sn=#form.name#*)(|(ou=*vet*)(ou=VM*)))"
Chris _______ Chris Brandt, DVM, MS Instructional Media Development Specialist http://vetpda.ucdavis.edu (530) 754-4452 > -----Original Message----- > From: Dawson, Michael [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 14, 2005 8:14 AM > To: CF-Talk > Subject: RE: cfldap and multiple filters > > As MT said in another post, you can check that link. > > Basically, the filter would look something like: > > FILTER="(|(first=#form.name#)(last=#form.name#))" > > Place each attribute in parenthesis. Then, wrap all alternate > attributes with another set of parenthesis. If your query is an "OR", > use a pipe "|" character. If your query is an "AND" use the "&" > ampersand. > > You can change you "OR" query to an "AND" query by changing a single > character like this: > > FILTER="(&(first=#form.name#)(last=#form.name#))" > > The filters can get very confusing if there are many of them. > > M!ke > > -----Original Message----- > From: Brandt, Chris M. [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 13, 2005 5:18 PM > To: CF-Talk > Subject: cfldap and multiple filters > > Is it possible to filter on multiple items in a ldap query using either > AND or OR? > > > > eg > > > > <cfldap ... > > filter="last=#form.name# OR first=#form.name" > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218447 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
