K Dub
|
Posted: 10/07/2003, 10:30 AM |
|
I hope someone can help me with this... I'm trying to create a web app that allows managers to enter their own job postings on our intranet, using CCS 2.1 - C# and SQL 2000
How can I lookup the value of a newly created Primary Key (auto generated) so I can redirect the page after insert, to a kind of OVERVIEW screen of what was just entered?
-----------------------------------------------------------------------
Example:
Field Values for Table:
job_id : primary key (auto increment)
department_id : int
manager : nvarchar
posting_date : datetime
overview : nvarchar
valid : bit
All entries are given by the user except JOB_ID. After INSERT, I would like to look up the job_id that was just created and redirect the user to a new page with an overview of what was just created.
-----------------------------------------------------------------------
I hope that's clear enough... if you think you know but need more info... please ask.
It's driving me nuts...
|
|
|
DaveRexel
|
Posted: 10/07/2003, 1:02 PM |
|
::
Have you looked at the webshop example shipped with CCS ?
It does contain code that looks up the latest auto-inc pk_id
Greetings
Dave
www.rexdesign.com (CCS Tutorial site)
|
|
|
K Dub
|
Posted: 10/08/2003, 1:31 PM |
|
Thanks! I'll try that..
Which example? And would you know the specific page in the site that I could look at?
|
|
|
|