|
server
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Help! Can't add! :P
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. |
|||||||||||||||||||||||