> It's been deprecated? > Okay.. I'll do the CfQuery route.. <CFINSERT> was just > soooo clean...
You could roll your own <cfinsert> tag -- in SQL Server the information_schema.columns table will give you just about all the info you need to perform your insert / update -- with the acception of knowing which columns are identities if you use them. Never have been able to figure out how to retreive that info. But it's not a terribly complex query and then you can put all your "low-level" sql code into a high-level tag that uses <cfqueryparam> and knows not to try to insert values for columns that don't exist, etc. (so the only time you'd need a field list is if you want to not update a column that does exist in the db) -- and passing an attribute for the data collection is much better than being forced to use the form scope. <cf_sqlinsert tablename="mytable" datasource="#mydsn#" data="#form#"> and you'd only have to write the tag once. :) hth s. isaac dealey 954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
