You should have no problem with this. I wrote a free tool called GridMonger that has SQL inserts and updates that run completely conditionally. They take a list of parameters and use those to decide how to build the SQL. What you're describing sounds simpler than that, but you can look at code samples by downloading it from the devex and looking at the file /includes/gm_update2.cfm starting at about Line 70 or so.
In short, loop over the form fields and pour the data types into a list. Then run the update statement and, inside of it, loop over the form fields again. Build an update line for each form field, using the datatype list you produced to assign a cfsqltype. Done. IIRC Isaac Dealey wrote up an amazing database sniffer of sorts that can figure all this out by itself, but its probably overkill here. Still its an absolute gem that I really need to start using myself. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:204751 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
