<CFLOOP Query="Queryname"> <CFSET test=left(UCase(column), 1)> <CFIF test GTE 65 AND test LTE 70> This is a value from A-F and you can do what you want here. </CFIF> </CFLOOP>
Your getting the ascii value of the upercase of the field value. Ascii for upper A is 65. Ascii for upper G is 71. Your getting all values in that range. From here it's just layout. At 07:09 PM 1/15/02, you wrote: >I want to output query results side by side and A-Z > >IE: >First column Second Column >A G >B H >C I >D J >E K >F L > >Any ideas? > > > >There are two major products that come out of Berkeley: LSD and [Unix] >BSD. We don't believe this to be a coincidence. > > > >Doug Brown > ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
