Mark, The error was thrown precisely where the error is!
You can only have CFCASE (and an optional CFDEFAULTCASE) inside CFSWITCH. It's a nesting issue: try putting <cfcase value="Company"> <cfif VARIABLES.searchCompanyShow EQ 1> AND company <cfif #SESSION.EmailList.searchModifier# IS "containing">LIKE '%#SESSION.EmailList.ffText#%' <cfelseif #SESSION.EmailList.searchModifier# IS "beginning with">LIKE '#SESSION.EmailList.ffText#%' <cfelseif #SESSION.EmailList.searchModifier# IS "equal to">= '#SESSION.EmailList.ffText#'</cfif> </cfif> </cfcase> i.e. put the CFIF nested inside the CFCASE (this needs correcting for the last few statements). Also, a "tidy code" tip - leave off the hash marks round your variable references inside CF tags, e.g.: <cfcase value="Company"> <cfif VARIABLES.searchCompanyShow EQ 1> AND company <cfif SESSION.EmailList.searchModifier IS "containing">LIKE '%#SESSION.EmailList.ffText#%' <cfelseif SESSION.EmailList.searchModifier IS "beginning with">LIKE '#SESSION.EmailList.ffText#%' <cfelseif SESSION.EmailList.searchModifier IS "equal to">= '#SESSION.EmailList.ffText#'</cfif> </cfif> </cfcase> HTH! Gyrus [EMAIL PROTECTED] work: http://tengai.co.uk play: http://norlonto.net PGP key available ----- Original Message ----- From: "Mark Leder" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, March 06, 2003 3:56 PM Subject: RE: Cfcase > Thanks for having a look - I'm really stumped. It's in the area further > down starting <cfif VARIABLES.searchCompanyShow EQ 1> ... The error was > thrown at that point. > ========================= > <cfset VARIABLES.searchCompanyShow = 1> > <cfset VARIABLES.searchStateProvinceShow = 1> > <cfset VARIABLES.searchCountryShow = 1> > > <!--- Retrieve records from database ---> > <CFQUERY NAME="qEmailList" DATASOURCE=#REQUEST.dsn1# > CACHEDWITHIN="#CreateTimeSpan(0,0,15,0)#"> > SELECT emailID, firstname, lastname, subscribeDate, emailaddress, > subscriber > FROM e1_EmailAdr > WHERE subscriber = 1 > > <!--- If the user provided a filter string, ---> > <!--- Also filter on fieldSelect drop down, if provided ---> > <cfif SESSION.EmailList.ffText IS NOT ""> > <cfswitch expression="#SESSION.EmailList.fieldSelect#"> > <cfcase value="All Fields"> > AND firstname <cfif #SESSION.EmailList.searchModifier# IS > "containing">LIKE '%#SESSION.EmailList.ffText#%' > <cfelseif #SESSION.EmailList.searchModifier# IS > "beginning with">LIKE '#SESSION.EmailList.ffText#%' > <cfelseif #SESSION.EmailList.searchModifier# IS "equal to">= > '#SESSION.EmailList.ffText#'</cfif> > > OR lastname <cfif #SESSION.EmailList.searchModifier# IS > "containing">LIKE '%#SESSION.EmailList.ffText#%' > <cfelseif #SESSION.EmailList.searchModifier# IS > "beginning with">LIKE '#SESSION.EmailList.ffText#%' > <cfelseif #SESSION.EmailList.searchModifier# IS "equal to">= > '#SESSION.EmailList.ffText#'</cfif> > > OR emailaddress <cfif #SESSION.EmailList.searchModifier# IS > "containing">LIKE '%#SESSION.EmailList.ffText#%' > <cfelseif #SESSION.EmailList.searchModifier# IS > "beginning with">LIKE '#SESSION.EmailList.ffText#%' > <cfelseif #SESSION.EmailList.searchModifier# IS "equal to">= > '#SESSION.EmailList.ffText#'</cfif> > > </cfcase> > > <cfcase value="First Name"> > AND firstname <cfif #SESSION.EmailList.searchModifier# IS > "containing">LIKE '%#SESSION.EmailList.ffText#%' > <cfelseif #SESSION.EmailList.searchModifier# IS > "beginning with">LIKE '#SESSION.EmailList.ffText#%' > <cfelseif #SESSION.EmailList.searchModifier# IS "equal to">= > '#SESSION.EmailList.ffText#'</cfif> > </cfcase> > > <cfcase value="Last Name"> > AND lastname <cfif #SESSION.EmailList.searchModifier# IS > "containing">LIKE '%#SESSION.EmailList.ffText#%' > <cfelseif #SESSION.EmailList.searchModifier# IS > "beginning with">LIKE '#SESSION.EmailList.ffText#%' > > <cfelseif #SESSION.EmailList.searchModifier# IS > "equal to">= '#SESSION.EmailList.ffText#'</cfif> > </cfcase> > > <cfcase value="Email address"> > AND emailaddress <cfif #SESSION.EmailList.searchModifier# IS > "containing">LIKE '%#SESSION.EmailList.ffText#%' > <cfelseif #SESSION.EmailList.searchModifier# IS > "beginning with">LIKE '#SESSION.EmailList.ffText#%' > <cfelseif #SESSION.EmailList.searchModifier# IS "equal to">= > '#SESSION.EmailList.ffText#'</cfif> > </cfcase> > > <cfif VARIABLES.searchCompanyShow EQ 1> > <cfcase value="Company"> > AND company <cfif #SESSION.EmailList.searchModifier# IS > "containing">LIKE '%#SESSION.EmailList.ffText#%' > <cfelseif #SESSION.EmailList.searchModifier# > IS "beginning with">LIKE '#SESSION.EmailList.ffText#%' > > <cfelseif #SESSION.EmailList.searchModifier# > IS "equal to">= '#SESSION.EmailList.ffText#'</cfif> > </cfcase> > </cfif> > > <cfif VARIABLES.searchStateProvinceShow EQ 1> > <cfcase value="State/Province"> > AND state <cfif #SESSION.EmailList.searchModifier# IS > "containing">LIKE '%#SESSION.EmailList.ffText#%' > <cfelseif #SESSION.EmailList.searchModifier# IS > "beginning with">LIKE '#SESSION.EmailList.ffText#%' > > <cfelseif #SESSION.EmailList.searchModifier# IS > "equal to">= '#SESSION.EmailList.ffText#'</cfif> > </cfcase> > </cfif> > > <cfif VARIABLES.searchCountryShow eq 1> > <cfcase value="Country"> > AND country <cfif #SESSION.EmailList.searchModifier# IS > "containing">LIKE '%#SESSION.EmailList.ffText#%' > <cfelseif #SESSION.EmailList.searchModifier# > IS "beginning with">LIKE '#SESSION.EmailList.ffText#%' > <cfelseif #SESSION.EmailList.searchModifier# IS "equal to">= > '#SESSION.EmailList.ffText#'</cfif> > </cfcase> > </cfif> > </cfwsitch> > ======================== > > Thanks, Mark > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
