I have this working but I need a little help on a perl script to copy the newly created aug from the items_aug table to the items table.  I plan on running a task to shutdown the server every morning, run the script and restart the server.  I know I can do a statement like: perl augcreate.pl to actually execute the script but I am unsure as to the actual code to insert the new item.  I add items all the time to my items table so I have to have the code increment the item id.  Thanks in advance. 
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 |