autoincrement problem

[acidrain9]

i have a contact database and basic pages setup with ability to add contacts. i
have implimented a notes feature that will allow each user to add notes to each
customer. my problem is that after you add one note, and try to add another
one the text is passed from the first note to the form, basically it won't let
me add a second note.

is there a way to check the database to find out what the next available
NoteID would be and to use that number in a textbox.

hope that wasn't too confusing.

thanks

[CMBergin]

I don't think I understand your question. You don't need to know the next
note ID to insert it, and if you were to display the next note ID when the
user began entering his note, there's no guarantee it would still be the
next note ID by the time he finished and the note was actually inserted.

Can you explain a little more?

"acidrain9" <webforumsuser@macromedia.com> wrote in message
news:cv53ef$cap$1@forums.macromedia.com...

> i have a contact database and basic pages setup with ability to add

contacts. i

> have implimented a notes feature that will allow each user to add notes to

each

> customer. my problem is that after you add one note, and try to add

another

> one the text is passed from the first note to the form, basically it won't

let

> me add a second note.
>
> is there a way to check the database to find out what the next available
> NoteID would be and to use that number in a textbox.
>
> hope that wasn't too confusing.
>
> thanks
>

[acidrain9]

i have a page set up that has a datagrid (contacts.aspx) with a list of
contacts, when you click details for each contact the ID of the contact is
passed to a detail page url which shows extended info, including notes.
(contactdetails.aspx?ID123)

i then have the option to add a new note for that contact (when clicked it
passes the existing ID to the url i.e. addnote.aspx?ID=123

my problem is that when i add one not it is fine but if i click the link to
add another note it pulls up all of the previous note information into my form
fields.

i am trying to make it so that i can add as many notes as i may need.

does that make sense???

[CMBergin]

Ahh, okay.
It shouldn't be acting like that. Perhaps the page is being cached.

Can you post your code, please (in a text file online with a link to the
text file - large blocks of code coming from the web forum get badly
mangled).

"acidrain9" <webforumsuser@macromedia.com> wrote in message
news:cv5prc$efa$1@forums.macromedia.com...

> i have a page set up that has a datagrid (contacts.aspx) with a list of
> contacts, when you click details for each contact the ID of the contact

is

> passed to a detail page url which shows extended info, including notes.
> (contactdetails.aspx?ID123)
>
> i then have the option to add a new note for that contact (when clicked

it

> passes the existing ID to the url i.e. addnote.aspx?ID=123
>
> my problem is that when i add one not it is fine but if i click the link

to

> add another note it pulls up all of the previous note information into my

form

> fields.
>
> i am trying to make it so that i can add as many notes as i may need.
>
> does that make sense???
>