Team_ID Automatic Generation stuck at 999

hackingarena · #1 (**permalink**) 08-27-10, 13:15

I have a piece of code in ASP which automatically generated as team_id as teams are added by users and stores team_id value in sql database. This code was working fine until team_ID value reached tm_999 after that this piece of code is allocating team_Id for every team added as tm_* instead of going to tm_1000. Can anybody tell what should i change in order to fix this problem?

Code:

'*********** This is code for sequence generation for Team id.
dim cmd_Nextval
set cmd_nextval = server.CreateObject ("ADODB.command")
set p1 = server.CreateObject ("ADODB.Parameter")
set p2 = server.CreateObject ("ADODB.Parameter")

'Declare Costants
const adCmdStoredProc = &H0004
const adChar = 129
const adParamInput = &H0001
const adParamOutput = &H0002

cmd_Nextval.ActiveConnection = objConn
cmd_Nextval.CommandText = "NEXTVAL"
cmd_Nextval.CommandType = adCmdStoredProc

p1.name = "@seqname"
p1.type = adChar
p1.direction = adParamInput
p1.size = 50
p1.value = "TEAM"

cmd_Nextval.Parameters.Append (p1)

p2.name = "@pre"
p2.type = adChar
p2.direction = adParamOutput
p2.size = 50

cmd_Nextval.Parameters.Append (p2)

dim teamt_id
cmd_Nextval.execute
team_id = p2.Value ' = cmd_Nextval.NamedParameters("pre")
team_id = trim(team_id)



'*******************

Thanks in advance

Teddy · #2 (**permalink**) 08-27-10, 14:07

Why not let SQL generate the ID for you using an IDENTITY/AutoNumber field and avoid this whole sordid business?

hackingarena · #3 (**permalink**) 08-27-10, 14:13

actually this is an old website baed on classic asp which i have not written, i m just managing it, so after going through all the code, i found out that this piece of code was causing problem, so i thought if i can edit it and let it do the same thing.

If that's possible for you to tell because there is lots of places where there is a reference to this id and i dont want to mess anything up

Teddy · #4 (**permalink**) 08-27-10, 14:48

I'd check the sproc first. Make sure it's returning what you think it is.

myle · #5 (**permalink**) 08-30-10, 05:55

the asp does not have a count in there it must be in the StoredProc in the SQL database

and it probabley a varibles is set to the lenght of 3

I would look for
DECLARE @???????? varchar(3)
in the StoredProc

??????? being a var name

Internet Services

Web Development

Digital Marketing

Consumer Tech