I forgot to mention, the Activ Mail tag won't take regular Cold Fusion variables with the # signs, it works with only what they refer to as Tokens, and the Tokens which are really data from a query can't be formatted with regular Cold Fusion functions such as dollarformat, etc.
Hence the need to somehow format within a query or revert to changing the database field type structure. ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists