You need to work with your interaction as form data and strings. If you are
outputting data to a CF query, submit the flash strings to your cfquery as
form.variables.
If you are outputting CF data to Flash, output your data to a string, like
this:
&portfolio_id=1|3|4|5&portfolio_ico=Name1|Name3|Name4|Name5&portfolio_name=i
con1.jpg|icon3.jpg|icon4.jpg|icon5.jpg&c_name=Bay Fireworks|Provident
Bank|Bronx-Lebanon Hospital|Intrepid Sea Air %26#38; Space Museum
Above, the | is a delimiter.
You'll need to do some special character handling too, as flash chokes on
some characters. Before you output to flash be sure to replace the
following:
% as %26#37;
& as %26#38;
+ as %26#43;
< as %26#60;
> as %26#62;
| as %26#124;
Carriage Return as <br>
Here's an example of a cfquery that builds a suitable flash string:
<cfsetting enablecfoutputonly="Yes">
<cfquery datasource="#dsn#" name="bio_icons">
select bio_id, name, title, icon1, icon2
from tbl_bios
where display=1
</cfquery>
<!--- create output string for flash --->
<cfset nme="">
<cfset ttl="">
<cfset ico1="">
<cfset ico2="">
<cfset id="">
<cfloop query="bio_icons">
<cfset nme=ListAppend(nme,name,"|")>
<cfset ttl=ListAppend(ttl,title,"|")>
<cfset ico1=ListAppend(ico1,icon1,"|")>
<cfset ico2=ListAppend(ico2,icon2,"|")>
<cfset id=ListAppend(id,bio_id,"|")>
</cfloop>
<cfoutput>&nme=#nme#&ttl=#ttl#&ico1=#ico1#&ico2=#ico2#&id=#id#</cfoutput>
Hope this helps, at least some...
Robert B. Harrison
Director of Interactive services
Austin & Williams
125 Kennedy Drive, Suite 100 Hauppauge NY 11788
T : 631.231.6600 Ext. 119
F : 631.434.7022
www.austin-williams.com
Great advertising can't be either/or... It must be &.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307992
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
