It's a work-around, but after you do your query, if needed to select certain records, you could loop through the resulting recordset using array notation. That would probably suck, tho.
M!ke -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Roland Collins Sent: Friday, March 18, 2005 3:22 AM To: [email protected] Subject: RE: [CFCDev] OT: QoQ Substring? Yeah - no gas :( -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kirk Brogdon Sent: Thursday, March 17, 2005 7:21 PM To: [email protected] Subject: RE: [CFCDev] OT: QoQ Substring? I think you would just use the mid function although I've never tried it on a query of a query. Kirk ---------------------------------------------------------- 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]
