Hugh > I'm trying to create a query based form which reads it's elements from a > database table, then populates itself. Each input element would have be > dynamically named via the DB query. > > Creating the form isn't so bad, but handling the insert query the other side > is becoming a headache. I can't figure out how to recreate the dynamic names > of the form variables and extract their data for insertion into the DB.
Unless you need to insert records relating to checkboxes that aren't checked, you can just iterate over the Form structure and see what field names you've got there. Nick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287444 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4