If you only have two values, you can use ListFirst() and ListLast() in your INSERT statement. No need to assign temp variables.
That's about as easy as it gets. M!ke -----Original Message----- From: Richard Colman [mailto:[EMAIL PROTECTED] Sent: Monday, May 16, 2005 4:20 PM To: CF-Talk Subject: Inserting two fields from a select box I would like to insert data into two fields from a single drop-down select box. For example, <select name="leadertrailer"> <option value="AccII,CGCG"> AccII ..... </select> So, I would like to insert AccII into field1 and CGCG into field2. I suppose that I could parse the string at the comma, then assign them to temporary variables on the action page, and then do the insert. Seems like an ugly way to do it. Anything simpler out there? Rick Colman ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206806 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
