Some options: 1. If left() and substring() failed, try mid() or substr(). Not sure about these.
2. If this QoQ originated from a database query, can you select the first n characters in the SELECT statement? What if you SELECT the field twice: SELECT myCol, SUBSTRING(myCol, 1, 4) AS myColShort ... 3. Use left() when outputting. 4. If one of these work, you may just need to loop over the query as an array. M!ke -----Original Message----- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 24, 2006 10:47 AM To: CF-Talk Subject: substring in q of q When performing a query of query, is there a supported syntax for doing a left() or substring()? I wanted to trim down a display column to a certain number of characters. Left and substring both returned errors. I was hoping to not have to do a cfloop over the result set and left() them all that way-- seems more trouble than if I can get cfquery to perform the string manipulations for me. Thanks. ~Brad ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230332 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
