Your query looks fine. What do you mean it doesn't work? Are you getting an error message or just not getting the results you expected?
-- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ > -----Original Message----- > From: Jillian Carroll [mailto:jillian@;koskie.com] > Sent: Thursday, October 17, 2002 5:44 PM > To: CF-Talk > Subject: Query Question > > > I have this query (that doesn't work): > > <cfquery name="provadmin" datasource="#DSN#"> > SELECT pa_ab, pa_sk, pa_mb, pa_on, pa_nb, pa_pei, pa_ns, pa_nf, pa_bc, > pa_bc, pa_pq, pa_yk, pa_nwt, pa_nu > FROM USERS > WHERE pa_ab=1 OR pa_sk=1 OR pa_mb=1 OR pa_on=1 OR pa_nb=1 OR pa_pei=1 OR > pa_ns=1 OR pa_nf=1 OR pa_bc=1 OR pa_bc=1 OR pa_pq=1 OR pa_yk=1 OR pa_nwt=1 > OR pa_nu=1 > </cfquery> > > How can I specify: Where 'any' of these fields equals 1? > > -- > Jillian > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
