Can you expand why you need to do this in the QoQ? I'm not saying you shouldn't be, but by explaining the requirement, it might make it easier to come up with the solution.
Firstly... you can't do what you want in QoQ, so stop trying. There are very few scalar functions in QoQ, and I think the only string ones are upper() and lower() (or toUpper() / toLower(), I forget, and the BNF in the docs doesn't mention them). CF states there's a whole bunch of reserved words with QoQ, but I suspect those are reserved by JDBC, not QoQ per se. So. Alternatives. 1) the query you're querying must have come from somewhere. Do the substr() processing when building that query (either with the DB engine, or in your querySetCell() code). 2) I'm guessing you're iterating over this query at some point. use mid() as you do so to come up with value you need. I guess depending on what you're wanting to do, those options might not be viable. -- Adam This email contains confidential information. If you are not the intended recipient of this email, please notify Straker Interactive and delete the email. You are not entitled to use it in any way. ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/[email protected]
