Hey all, Happy New Year! I am returning some stuff from a database to flash
via CF remoting. I need to format some of what I am returning with
URLEncodedFormat. I tried this: <cffunction name='getNews' access='remote'
returnType='query'> <cfquery name='news' datasource=#db# username=#us#
password=#pw#> SELECT id, URLEncodedFormat(subject) AS subject,
URLEncodedFormat(content) AS content, date_added, date_modified, added_by FROM
news </cfquery> </cffunction> But it's a no go. subject / content turn up as
undefined. Is there any other way I could apply the URLEncodedFormat to
subject and content and have CF return that back to flash? The real problem is
that its multiple records....so I cant just apply this to one thing as I am
returning the whole query. Any ideas my friends? Thanks in advance :D

anyone? the only thing I could think would be to return everything in arrays
an array for ids an array for subjects an array for content .. etc... and put
the URL encode format on the array elements. that is kind of wacky
though...there has to be a more elegant solution