At 11:11 PM 2/15/05, Barney Boisvert wrote: >Just four sequential CFQUERY tags, each with an INSERT statement.
Thanks. Two additional thoughts: 1) should I enclose all four queries within a CFTRANSACTION tag with a rollback option? That way, if something happens that interrupts the insert process, data integrity would be protected (i.e., there wouldn't be some tables with new information and some tables without)... 2) for those tables sharing keys (PK and FK), should I go ahead an insert the value in both tables (e.g., "word PK" and "word FK" in two different tables)? I don't have "cascade" enabled (using Access 2000). Is it a custom practice to enable cascade, or is it better to manually populate the FK fields with INSERT? Thanks, Roberto Perez [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194906 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
