Hi, > 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?
this looks like you are storing all selected values in a single varchar field? If so, here's one piece of advice: Don't do it! Make it a relational model with another table related to your "main" table, where your related table will hold one record per submitted option. I would also recommend storing the numeric IDs of the selected records in numeric fields and not use varchar or similar fields. If I misunderstood your setup, feel free to simply ignore this mail. ;-) Chris ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230922 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
