jsp with access database

[RegK]

how do i get the autonumber generated in a table by an insert query.

I have tried a select statement with comparisons to the data i have added just after the insert query but this does not seem to work.

It works when i reload the page but at this stage the data has been inserted twice into the database with different autonumber ids.

 

[palbano]

>>I have tried a select statement with comparisons to the
>> data i have added just after the insert query but this
>> does not seem to work.

That should work... try the Access forums here at Tek-tips "if ur going to get flamed... u may as well post something flame worthy eh?" - me - 12 Feb '03

-pete