Does anybody know why my sequence is being incremented by 2, instead of one,<BR><BR>Code for sequence:<BR>create sequence assetseq<BR>START WITH 1<BR>INCREMENT BY 1;<BR><BR>code in ASP for assigning id number<BR> strSQL = "SELECT assetseq.nextval as id From Dual" <BR> Set RecordSetObjectSeq = Server.CreateObject("ADODB.RecordSet")<BR> RecordSetObjectSeq.Open strSQL, objConn, 2, 3, adCmdText<BR> sequence = RecordSetObjectSeq("id")<BR><BR>then I set objRS("ID") = sequence, <BR>this seems to assign my numbers ids such as 2, 4 , 6 etc, I want them to be incremeneted by one,<BR>Thanks <BR>Trish