Home All Groups Group Topic Archive Search About


Author
9 Oct 2007 11:29 AM
Corey Forman
I'm trying to set a variable to a call of ticket_ID from table tickets of the
most recent ID. Basically I want to call the most recent number in the column
ticket_ID and add 1000 to it to make a 4 digit #. What I've got is this:

user_details=split(request("ticket_userID") ,"/")
Q=request("ticket_id")
R = (1000 + Q)
ticketid=user_details(0) & cstr(R)
user_name=user_details(1)

This (plus more before) makes the 4 digit user ID combine with the 4 digit
number (which I need to be incremental, not random)  to make an 8 digit
ticket number which makes the ticket origins easy to trace, and allows me to
keep track of the number of tickets created. Any ideas on how to make it
simple? The ticket_ID field is AutoNumbered right now so it's going up
incrementally, I just want to add 1000 to that and user that equation as R.
I'm stumped.

AddThis Social Bookmark Button