ahhh absolutley....t'was alot easier to spot when i pasted it all into studio and cleaned it up a little gj. told you it made my head hurt..... : )
so basically, you can have the structure of a cfswitch <cfswitch expression=""> <cfcase value=""> </cfcase> <cfcase value=""> </cfcase> <cfcase value=""> </cfcase> <cfdefaultcase> </cfdefaultcase> </cfsiwtch> you can put prretty much anything you want within the <cfcase> and <cfdefaultcase> tags but not outside of them ----- Original Message ----- From: "Gyrus" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, March 06, 2003 11:33 AM Subject: Re: Cfcase > 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
