Hi,

I trying to add some peoples detail's to my Oracle database, through ASP. I have set up the form, and text boxes for each indivdual fields, everything inserts fine apart from their ID, as this is a sequence in oracle. So a number can be inserted automatically, rather than allowing the user to insert there own ID.

Any ideas how to make my asp page generate the sequence for the new ID?

Thanks

Have you tried using fieldname.nextval in your insert statement ? FYI - My oracle experience is null or (null + 10000000).