Then if it's only an AND after the 1=0, it always fails because 1=0 evaluates as false, and the query will always return NO rows.
Both scenarios are possible the way the code is written. > -----Original Message----- > From: Mingo Hagen [mailto:[EMAIL PROTECTED] > Sent: Friday, December 01, 2006 9:22 AM > To: CF-Talk > Subject: Re: Query WHERE separation > > so he should use 1=0 > > Mingo. > > Doug Bezona wrote: > > The only problem I see is that if you end up with only an OR after the > > 1=1, the OR becomes essentially meaningless. 1=1 is always true, so all > > rows with the right id will be returned regardless of the OR clause. > > > > > >> -----Original Message----- > >> From: daniel kessler [mailto:[EMAIL PROTECTED] > >> Sent: Friday, December 01, 2006 8:02 AM > >> To: CF-Talk > >> Subject: Re: Query WHERE separation > >> > >> That seems to have worked. I did it with a 1=1 because there might > >> > > not be > > > >> anything in the brackets, but I dunno if it's needed. Here's what I > >> > > ended > > > >> up with (below), please tell me if I need to make any corrections. > >> And thanks both of ya for the assistance. > >> > >> SELECT meeting_name,type,note_date,id,n_r_id, ROWNUM AS r, > >> COUNT(meeting_name) OVER() AS rowcount > >> FROM notes_to_the_record > >> WHERE ID = #session.user.id# AND > >> (1=1 > >> <cfif url.meeting_name neq ""> > >> AND UPPER(meeting_name) LIKE <cfqueryparam > >> value="%#UCase(url.meeting_name)#%" cfsqltype="cf_sql_varchar"> > >> </cfif> > >> <cfif url.type neq ""> > >> #url.and_or_1# UPPER(type) LIKE <cfqueryparam > >> value="%#UCase(url.type)#%" cfsqltype="cf_sql_varchar"> > >> </cfif> > >> <cfif url.notes neq ""> > >> #url.and_or_2# UPPER(notes) LIKE <cfqueryparam > >> value="%#UCase(url.notes)#%" cfsqltype="cf_sql_varchar"> > >> </cfif> > >> > >> ) > >> ORDER BY UPPER(meeting_name) ASC > >> ) > >> > >> > >>> Use brackets to split the where clause up: > >>> WHERE > >>> id_field=id > >>> and ( > >>> a=1 > >>> or > >>> b=2 > >>> or > >>> c=3 > >>> ) > >>> > >>> -- > >>> Tom Chiverton > >>> > >> > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262404 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
