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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
