Jillian Carroll wrote: > I have this query (that doesn't work):
What is the rror? > 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 > > > How can I specify: Where 'any' of these fields equals 1? In a stored procedure or a parameterized view. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Get the mailserver that powers this list at http://www.coolfusion.com
