How To Automate Ticket Number?
I have the ff. data:
Customer Name
Date
Subject
Problem
then when the user submitted the form, the ticket number will be automatically generated with the following format:
<last 2 digits of the current year>+<last 2 digits of the current month>+<number series 001-999>
example: 0409001
(where 04 stands for 2004, 09 for the month of september, then 001 refers to the 1st record)
then all the data will be saved to the database.
my problem is how can i do this?
View Replies
ADVERTISEMENT
I have all the ticket numbers displaying as a link ready to be edit! My question is how can I display that ticket number with all the information that comes with it when the user click it to be edit.
Would I have to use the Request.Form("Ticket_Number") or something else?
Here's the code.
Response.Write("<td><a href='Results.asp?=" & objRS("Ticket_Number") & "'>" & objRS("Ticket_Number")& "</a></td>")
Response.Write "<td>" & objRS("Escalation_Type") &"</td>"
Response.Write "<td>" & objRS("First_Name") &"</td>"
Response.Write "<td>" & objRS("Last_Name") & "</td>"
Response.Write "<td>" & objRS("Account_Number") & "</td>"
Response.Write "<td>" & objRS("Phone_Number") & "</td>"
Response.Write "<td>" & objRS("Cae_Name") & "</td>"
Response.Write "<td>" & objRS("Cust_Com") & "</tr></td>"
View Replies
View Related
I am able to connect to sql databae and it's retrieving all the tickets. Is there a way to set a query string to display the current ticket number that was generated in the database. Here's the code
str="SELECT Ticket_Number FROM Escalation_Forms"
rs.open str
While not rs.EOF
Response.Write rs("Ticket_Number") & "<BR>"
rs.MoveNext
View Replies
View Related
i want to build a ticket support system for my company, so when a client has a technical question, they can email a support address and get assigned a ticket number. then my colleague will get the email and respond when he can. my question/s is:
a) is there any existing system i can use (free if possible. i would rather use an existing system as i have limited time!)
b) how can i write some code that acts when an email address is sent. ie: user sends email, the server receives it and executes some code (sends an email back with assigned ticket number and adds record to db).
View Replies
View Related
anyone knows of a free Bug/Issue/Trouble-ticket tracking ASP application.
View Replies
View Related
I used ASP and wrote a login / logout program. This is to capture people who comes into my lab from 0800 to 1700.
The data collected are stored in a table
Userid Date_in Time_in Date_out Time_out
123 4/3/2005 0900 4/3/2005 1000
121 4/3/2005 0925 4/3/2005 1100
122 4/3/2005 1200 4/3/2005 1400
127 4/3/2005 1500 4/3/2005 1600
125 4/3/2005 1503 4/3/2005 1630
122 5/3/2005 0800 5/3/2005 0845
The manual way of calculating utilization on 4/3/2005 will be [(Time between 0900 to 1100) + (Time between 1200 to 1400) + (Time between 1500 to 1630)] / (Time between 0800 to 1700) X 100%
The problem is that depending on what time the next person arrives, there might be an overlap in time. For example, A comes at 9am and leaves at 11am. B comes at 9.30am and leaves at 12pm. The total duration will be from 9.00am to 12 pm that is 3 hours instead of (rs("time_out")-rs("time_in")) = (11-9) + (12-9.5) = 4.5 hours
Is there a formula or way to automate this process?
View Replies
View Related
Does anyone know how to autome word mailmerge to create Letter forms using ASP?
View Replies
View Related
Everyday of my life the last year has started by searching through a lot websites in order to find the latest news, and then making a link to that news from my webpage. What I have always dreamt about is some kind of automation.
Is it possible to make a script in ASP that searches through a website and gathers info on title, URL and such, and then automatically inserting it into my website (via for instance a SQL database)?
View Replies
View Related
I have an ASP script that selects data from a database, treats the data and produces a report.Now i need to run that report daily, and i would like to automate the run - every day at n o´clock. What is the best way to do it?
View Replies
View Related
if it is possible to have a web page that can be created into a pdf via a click of a button, similar to the save as pdf option. Is this possible?
View Replies
View Related
I want to have an automated recordID with the following format:
<last 2 digits of the current year>+<last 2 digits of the current month>+<number series 001-999>
example: 0409001
(where 04 stands for 2004, 09 for the month of september, then 001 refers to the 1st record)
then when month changed to october the number will be reset to 001 so the recordID now must be 0410001
having that format i can't use the database itself by setting the recordID as autonumber only..
View Replies
View Related
I'm building an asp website with calendar for a High School Basketball team. A database holds dates for all events on the calendar. I want to build a schedule for a SEASON automatically based on the current date() they are visiting the site, and a SEASON is June of one year through May of the next. Example:
If they are accessing the schedule in January 2007, a query will filter all events for the 2006-2007 season (June of 06 through May of 07)
If they are accessing the schedule in August of 2007 I want them to get events filtered from June of 2007 through May of 2008 (the 2007 - 2008 season).
I can't seem to get my mind around the logic (and code) needed to build this query. If i build a query based on the year alone, by picking 2007 you would get the end of the 2006-2007 season and the beginning of the 2007-08 season (events from Jan 2007 through Dec 2007).
View Replies
View Related
I am generating rtfs. Is there anyway to automate the printing of the rtfs after they have been created?
View Replies
View Related
I need to insert some number into database as text. My problem is if I insert the number (ie. 4.0), the value in the database only show (4). So, is it possible to convert a real number into text number using ASP?
View Replies
View Related
here is the scenerio
in master batch table i have various master batch like
200701-0001
200701-0002
200701-0003
Now each master batch can have multiple final mixed batch like
200701-0001-01
200701-0001-02
200701-0001-03
and this record is inserted in to fmix table.
so i have a form in which i have a dropdown menu in which all the master batch is listed,
i select 200701-0001 and that value is passed to next page where i will enter other fields data and insertion to my fmix_no will be done automatic like 200701-0001-01, 200701-0001-02 and so on,
how to achieve this
so in short each master batch will have more than one final mixed batch.
pls help, also if u have any online contact in yahoo or msn pls send me, i am so confused and badly struck deadline is just couple of hours away. my yahoo id is(E-Mail address blocked: See forum rules) you can PM me i am online right now.
View Replies
View Related
I want To handel the error messages by myself in one part in my script. I know that in VB I can Use the statment - On error resume next And I also know that I can retrive the Error Number In VB with Err.Number.
How can I handel the errors by myself in ASP? I heard about the ASPErr Object, Is it the same thing like the err object in VB?
View Replies
View Related
if I dispaly certain column data from database, how to make the auto numbering in front of each data?for example
1. ha
2. ho
3. hu
let say the ha, ho and hu is data that call from database column.
View Replies
View Related
Can you help me with this? Is there any function that I can use in getting a
whole number
Example:
Input OutPut
12.3 12
1.63 1
21.1 21
Im using the function left(p1,p2) but it doesnt recognize the whole number
View Replies
View Related
I have an error statement in place which i would like to catch when a problem aoccures and assign a value to Compensation.
Code:
If Err.number<>0 then
If iCount Mod 2 = 1 Then
objRS.Move ((iCount + 1)*0.9)-1
Compensation = Int(objRS(0))
Else
objRS.Move (iCount*0.9)-1
Compensation = objRS(0)
objRS.MoveNext
Compensation = (Compensation + objRS(0))/2
End If
Else
Compensation = 0
End If
at the moment,Compensation seems to always have the value of 0 even when an error is not evident. Have i got this the wrong way around?
View Replies
View Related
i m getting such number 3001/e-00084308/00/000
so each time i want to change 00 to 01 in above number
View Replies
View Related
I want to have the address IP of the client's machine. I have made this.
<b>Your IP address is:</b>
<%Response.Write(Request.ServerVariables("remote_addr"))%>
</p>
but It give me the address of my host I wish I have IP of the machine client.
View Replies
View Related
I am using the code below to count the number of records and divide it by the sum of the records to get the average number. I get the error : Type mismatch: 'ubound' . I know I'm missing something obvious as my experience with arrays have rendered below.
<% PriceArray = Recordset1("TotalBidPrice") %>
<%
for x = 0 to ubound(PriceArray,2)
CountArray = CountArray + PriceArray(0,x)
next
ThePriceAvg = CountArray/(ubound(PriceArray,2) + 1)
%>
<%=ThePriceAvg%>
View Replies
View Related
How do you check if a value is "not a number" in Visual Basic? Ie:
If textbox is not a number then
msgbox "Please enter a valid number"
Else
.............
End If
View Replies
View Related
I have a form on my site, in the form there is a field called ticketid, I want this field to be prepopulated everytime the user opens the form, Also would like to have it start with 1000 so if the it gets open second time its 1001, third time 1002 and so on. Code:
View Replies
View Related
Microsoft OLE DB Provider for SQL Server (0x80040E2F)
Cannot insert the value NULL into column 'ContactID', table 'ka0506a.ka0506a.contacts'; column does not allow nulls. INSERT fails.
/submitcontact.asp, line 15
What happened is i used to used MS Access and ContactID is an Autonmuber field, and now my connection is set to MS SQL so it's giving me this error, what's causing this error to happen and how can i change it ?
View Replies
View Related
I have a repeater that pulls back informtion from a MySQL database. I was wondering how could I put a counter that increments as each row is returned and displays it in the repeater. For example where it says Day:, I want to make that Day: 1, Day: 2 etc as each row is returned.
The Day: 1++ is just a demonstration of what i want incremented.
<asp:Repeater ID="RepeaterUserReportSummary" runat="server">
<ItemTemplate>
<table style="width: 990px">
<tr>
<td style="width: 185px;height: 10px;"><b>Day: 1++ </b></td>
<td style="width: 35px;height: 10px;"><b>Total:</b><%# Eval("TotalReport")%>cal</td>
</tr>
</table>
</ItemTemplate>
</asp:Repeater>
View Replies
View Related
Any build in function that can calculate number of records in a table?
View Replies
View Related
I've created a freight calculator that needs to know how many pallets I'm shipping. I'm using 1 pallet for 750lbs and an extra pallet for anything more than that.
If materialWeight <= 750 Then numPallets = 1 Else numPallets = Round(materialWeight / 750) End If
Now, let's say the materialWeight/750 ends up being 3.2. This is returning 3, but I need it to return 4 since we need an extra pallet.
How can I make it Round up to the next whole number? If it turned out to be an exact number without a decimal then it should stay where it is, but if it's over x.0 at all it should go up to the next whole number.
View Replies
View Related
Is there a command in asp to truncate a decimal? Currently I've got a number that's coming out with up to about 12 decimal places based on input fom the user and I'd like to force it to just display up to two decimal places. Is that possible?
View Replies
View Related
I am using w2000+sp4 server with IIS running, how can I know my IIS version
number, is it iis5.0 or 5.1 or 6.0?
I must know this, since I want to download patches from MS web site,
View Replies
View Related
When we are using ENCTYPE="multipart/form-data" for file uploading, we can use Request.TotalBytes to get the total number of bytes sent by the user in http. Is it possible to get the bytes of a specific field from that form
View Replies
View Related
Does anybody know how I can get the week number. The week number we are currently on is 28 and I need to be able to reitrieve this number so that i can manipulate for loops to advance that number to 33 and 38.
View Replies
View Related
I have an ASP variable which is a certain number. I want to create a Select tag in a form, which will be populated up to this number. So, for example, if my number was 7, you would have a list of numbers between 0 and 7 to select.I'm not sure how to do loops, but I had an idea that the code would look something like this:
Code:
<select name="select2" id="select">
<%
for i=0 to i=varNumber
Response.Write ("<option value='"& i &"'>"& i &"</option>")
rsBooking.MoveNext
%>
</select>
but, as you might guess, this doesn't play!
View Replies
View Related