> I need to query a table, take the results and change a few of the variable
> names,
It is best to change var names in the SQL so, if you want to change column
col_1 -> MyVarName1
<cfquery name="q">
SELECT col_1 as MyVarName1, col_2 as MyVarName2
FROM myTable
</cfquery>
serialize it using wddx, and then send that packet in an email.
<cfwddx action="WDDX2CFML" input="#q#" output="MyWddx">
<cfmail>
#MyWddx#
</cfmail>
HTH
~Justin MacCarthy
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.