OT: Oracle Sequences

[Schreck, Tom]

I figured out the solution for capturing the next sequence number before inserting into table:                           <cfquery name="qryNewID" datasource="#variables.cfcDSN#">                                     SELECT DRESSER.SEQDIProducts.NEXTVAL as numProductID                                     FROM DUAL                         </cfquery>   Simply query the sequence.nextval and use DUAL as the table name in the query statement.   Thanks   Tom Schreck Applications Developer Dresser, Inc. 15455 Dallas Parkway, Suite 1100 Addison, TX  75001-4690 972-361-9943 [EMAIL PROTECTED]

<<attachment: image001.jpg>>