I am trying to get people that are on the outside world that email a ticket request into the database. I have most of the parts figured out, but the ticket number is causing an issue. In my sql statement I check for the last ticket number and add 1, but then when you go into the help desk webpage and create a ticket the number is already used, so it blows up. Where in the code is the ticket number stored for adding a new ticket.
Any advise would be greatly appreciated.
Thanks;
Maybe Postnew.asp int he root of your helpdesk folder. There are a few lines there ference problem ID's. Like line 106 (around it anyway) says:
' Get the problem ID number then immediately update it id = GetUnique(cnnDB, "problems")
Not saying it is there but seems to be a good a place to start. Hope this helps.
I think I figure this out!
Open the data base and open table "DB_Keys". There is a column in their called "problems". It lists ho wmany problems have bee submitted. Set it to the end of your tickets and it should start ticking off new new numbers AFTER the number you enter.
Let me know if this works. I am too porting a another access dase to this one. I got erverything working and started getting dup ticket numbers. This so far seems to have helped.
Oh and update the other fieldsd to reflect the correct values.
For example from ours:
Problems departments categories users lang
8132 276 19 2257 2
Break down:
Problems the number reflects the entire amount of tickets/problems in the "problems" table.
departments: the number reflected from the entire amount of departments from the "departtments" table.
So on... Make all the values match actual sizes! It is so sweet and working great!