And if this is the case, I would guess that you are using some kind of component that is a singleton and maintaining its id field state - thus updating an existing record rather than creating a new one.
Dominic 2009/8/5 Maureen <[email protected]> > You can't delete a row without delete, but you can overwrite it, which > appears to be what is happening here. The last row written is > overwriting the previous rows because the identity field is not > changing. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325243 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
