Why no use the NOCASE functions ? > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: 12 September 2003 15:03 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] Help again.... > > > > Ok so I have sorted out its the case thats not working...... > > When the query returns all the Report Types the case is > looking for the word PANDA in there. > > Do I need any wild cars or does case look at all values in > the list ??? Or..... Maybe its because the value keeps > getting set each time the query loops...... Aha! > > Anyway how do I fix this ..... > > Please select a report from the list below<p></p> > <cfoutput query="get_report_type"> > <cfswitch expression="#report_name#"> > <cfcase value="Panda"> > <cfset ext=".pdf"> > </cfcase> > <cfdefaultcase> > <cfset ext=".abc"> > </cfdefaultcase> > </cfswitch> > <a href > ="http://marge/prfmrep/#url.year#/#url.phase#/#report_name#/#u > rl.school##ext#"> > #Report_Name#</a><br> > </cfoutput> > > > > > ************************************************************** > *********************************** > The information contained within this e-mail (and any > attachment) sent by Birmingham City Council is confidential > and may be legally privileged. It is intended only for the > named recipient or entity to whom it is addressed. If you are > not the intended recipient please accept our apologies and > notify the sender immediately, or telephone +(44) 121 303 > 6666. Unauthorised access, use, disclosure, storage or > copying is not permitted and may be unlawful. Any e-mail > including its content may be monitored and used by Birmingham > City Council for reasons of security and for monitoring > internal compliance with the office policy on staff use. > E-mail blocking software may also be used. Any views or > opinions presented are solely those of the originator and do > not necessarily represent those of Birmingham City Council. > We cannot guarantee that this message or any attachment is > virus free or has not been intercepted and amended. > > ************************************************************** > *********************************** > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] For human help, e-mail: > [EMAIL PROTECTED] > >
-- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
