I have a multiselect list box on a flash form, which relays the IDNo to the 
submission form. My problem is that the results that get stored in my table 
look like this "2001   ,2004    ," with the extra spaces. I can't seem to use 
the Trim function to get rid of them. Any ideas?

<cfselect name="Other_Participants"
          size="6"
          width="200"
          label="Other Part."
          query="ParticipantList"
          value="IDNo"
          display="FullName"
          selected="ClientNum"
          visible="Yes"
          enabled="Yes"
          multiple="Yes">
<option value="" selected>...</option>
</cfselect>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230851
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=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Reply via email to