|
|
|
|
|
| | |
| |
Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: Increasing numbers without using AutoNumber property |
|
From: |
Gorkem |
|
Date: |
6/10/2002 11:43:18 AM |
|
IP: |
64.56.238.250 |
Use the MAX container is SQL.. ie
if you database had a column named YEARS and the highest year was 2001.. do this:
SELECT MAX(Years) as 'HIGHESTYEAR' FROM MyTable
this will return 2001 as the highest year. Now just take this result and add +1 to it in your ASP page.
Cheers,
Gorkem. |
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
