Les, I would probably advocate that you use a stored procedure to compare the values. It will execute quicker.
You may want to create a geenrational ID on the log table similar to date time stamp, so you can compare how far back you want to check. A CFC or UDF that compares generations against one another through the use of stored procedures can make you dev life easier. I had a CFC API that I would use to load a generation and then compare against the current state of the data. I could ask the CFC to tell me how many generations existed and give a place in time generation. Teddy On 1/16/07, Les Mizzell <[EMAIL PROTECTED]> wrote: > > Is there a way to compare a complete record in one table (all columns) > to another record in another table without having to specify each > individual column? Or would you basically have to do a <cfif > record1.column1 NEQ record2.column1> for every column in a table? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266703 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
