Results 1 to 2 of 2

Thread: Sequence in ASP

  1. #1
    Join Date
    Dec 2003
    Posts
    22

    Unanswered: Sequence in ASP

    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

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Have you tried using fieldname.nextval in your insert statement ? FYI - My oracle experience is null or (null + 10000000).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •