Could you not use a formatting function in ActionScript to do the trimming?
I'm not sure of the details with Flash Forms in CF, but in Flash I've used
them. It's been a while, but the basics are, you supply a function that's
applied to the data before display. In your case it'll look something like:
function left(str) {
return str.substring(0,3);
}
I have a feeling it's not as simple as that, I seem to remember passing
objects around but the project and source files of where I used it are
evading me.
Just a thought.
Adrian
-----Original Message-----
From: Brad Wood [mailto:[EMAIL PROTECTED]
Sent: 24 January 2006 17:32
To: CF-Talk
Subject: RE: substring in q of q
3. Use left() when outputting.
This would require me to be iterating over the result set. This query
is being returned via flash remoting and a list object which I am
binding to the dataProvider property of a cfselect. The flash redraw is
handling all output and there is no chance to play with the data once it
gets that far.
4. If one of these work, you may just need to loop over the query as an
array.
Yeah, this is what I ended up doing.
<cfif len(trim(max_display_wdith))>
<cfloop query="qry_sub_accounts">
<cfset
qry_sub_accounts['bank_account_sub_setup_name'][currentrow] =
left(qry_sub_accounts['bank_account_sub_setup_name'][currentrow],#max_di
splay_wdith#)>
</cfloop>
</cfif>
Thanks again for your help!
M!ke
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230337
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
