ahhh sorry I should have mentioned - this app is stuck on 5 at the moment :) I've got an ugly workaround but I'll remember this for the upgrade, thanks
Toby Thursday, November 20, 2003, 12:36:45 PM, you wrote: S> Hi Toby, S> It should work using exactly that syntax. S> http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/using_27.htm S> Spike S> Toby Tremayne wrote: >> Hi All, >> >> when you're doing a QoQ, is there anyway to upper case something >> you're checking against? For instance in sql server I'd do this: >> >> where UPPER(status) = '#uCase(myVar)#' >> >> but I can't find an equivalent for QoQ - am I just stuck? >> >> cheers, >> Toby >> >> >> >> >> -------------------------------- >> >> Life is Poetry, >> write it in your own words >> >> -------------------------------- >> >> Toby Tremayne >> Cold Fusion Developer >> Code Poet and Zen Master of the Heavy Sleep >> Virtual Tours >> +61 416 048 090 >> ICQ: 13107913 >> >> >> --- >> You are currently subscribed to cfaussie as: [EMAIL PROTECTED] >> To unsubscribe send a blank email to [EMAIL PROTECTED] >> >> MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia >> http://www.mxdu.com/ + 24-25 February, 2004 >> -------------------------------- Life is Poetry, write it in your own words -------------------------------- Toby Tremayne Cold Fusion Developer Code Poet and Zen Master of the Heavy Sleep Virtual Tours +61 416 048 090 ICQ: 13107913 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
