I have a form that formats the phone/fax number. <CFSET TELEPHONE="(#left(SchoolInfo.TELEPHONE,3)#) #mid(SchoolInfo.TELEPHONE,4,3)#-#mid(SchoolInfo.TELEPHONE,7,4)#"> Works fine when used in a regular query. Now I have changed the queries around so that I can do bulk printing so instead of: query1 cfset query2 cfset etc I now have: <CFOUTPUT>query1 Include template of queries cfloop query2 cfloop query3 </CFOUTPUT> Anyhow nothing else changed- but for some reason my telephone/fax formatting no longer works- instead it prints out like 5554345431.0 Any ideas on why this would happen? Thanks in advance. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
