>I've tried using the result.identitycol trick with CF8 and MSSQL and for >me, it doesn't work. I just get an error. >
Not that it is the best approach, but the result.identitycol trick is a little 'tricky' eg. <cfquery name="queryname" datasource="nameddatasource"> if you cfdump queryname, you will see the identity col, BUT if you try to get the identitycol with queryname.identitycol, it doesn't work. Here is the tricky part: add a 'result' parameter eg. <cfquery name="queryname" datasource="nameddatasource" result="qnvars"> and then refer to the identitycol through that result. <cfdump var="#qnvars.identitycol#"> Hope this helps ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311533 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4