http://livedocs.adobe.com/ Macromedia LiveDocs - online documentation with user feedback. Copyright 2009, Macromedia, Inc. 2009-11-26T04:28:52 en-us http://livedocs.adobe.com/coldfusion/7/htmldocs/00000280.htm#33452 You can easily mimic an auto-increment id column in oracle by placing an insert trigger on the table. Here is an example of how to create the trigger, assuming the table and sequence have already been created:<br />CREATE OR REPLACE TRIGGER TR_SPOOF_LOG<br />BEFORE INSERT<br />ON SPOOF_LOG <br />REFERENCING NEW AS NEW OLD AS OLD<br />FOR EACH ROW<br />DECLARE<br />tmpVar NUMBER;<br />BEGIN<br /> tmpVar := 0;<br /> SELECT SPOOF_LOG_SEQ.NEXTVAL INTO tmpVar FROM dual;<br /> :NEW.LOG_ID := tmpVar;<br /> :NEW.SPOOF_TS := SYSDATE;<br />END TR_SPOOF_LOG; 0 0 2005-05-16T12:03:39