how do i create an invoice no with addition.. sample of my code.. which is not working...
Code:
if rs.EOF then
invoiceno="fm1193-01"
else
rs.movelast
lastinvoiceno=rs("Invoice Number")
invoiceval=trim(mid(lastinvoiceno,3,6))
invoiceval=CLng(invoiceval)+1
invoiceno="fm1193-01" & invoiceval
end if
rs.AddNew
rs("Invoice Number")=invoiceno
rs.Update
i am doing an shopping cart project and i am stuck at generating an unique cart id which will also be the invoice number. and that it should not be random but should start from 1000 and then go on. so, guyz if u can give me the code or help me with this let me know at the earliest.
is this a good way to generate or should generate cart id with session.sessionid and should generate invoice no starting from 1000 and so on. if this is also ok. then plz let me know how to generate invoice no.
I am trying to assign an invoice number to orders that are made on my website so that i can combine multiple order numbers into one invoice number. Here is the code i am using to insert the invoice number into the orders table.
It works if there is only one order in the table but if you try and order again it multiplies the orders by the number of invoice rows for example if there was 3 invoice fields it would add the same order 3 times into the order table. Its got stuck in some sort of loop. Code:
I have a ASP shopping cart web site with Access db. I need to assign an invoice number (1,2,3,4 etc.) to orders which have status "completed" ("invoice number" used only to count completed orders and different from OrderID, which is unique).
Also, if i change status from completed to something else (in case if it was completed by mistake) then the invoice number from that order will be available for the next completed order. I am not sure if it's possible. I need it for tax dep. they don't except a list with missing invoice numbers.
After server went down I got this error after submitting Membership form. (win2000, IIS 5.0, Access Database(mdb)
ActiveX component can't create object Error Number =429
I have just finished writing my site in ASP with Access I thought it would be useful to continue using this technology to create this invoice. Basically the details will be added to the invoice by retrieveing records from a database or creating new ones.
What I am looking for advice is regarding the end product, i.e. the printed invoice. I should be able to format the page correctly so that it prints to A4, but my concern is what about the header and footer information that the user controls.
I don't want any of this information to appear on the print out therefore I'm wondering if there are any other options that I can look at for producing this invoice. for example is it possible to create a properly laid out word document or pdf from the data?
The first page I`m calculating all the units fields and add them
to the second page as total without VAT and works fine, Code:
<input type="hidden" name="tphtva" value="<%=tfp1+tfp2+tfp3+tfp4+tfp5+tfp6+tfp7+tfp8+tfp9+tfp 10%>">
but the 3th page I want to calculate the VAT Code:
<%=Request.Form("tphtva")%>
and I get the error anitel/verify_invoice_2.asp, line 254 where the ]<%=Request.Form("tphtva")%> is.... where I`m wrong...
I need to be able to generate an invoice from an ASP page. Currently, the invoice is drawn in a web page and my client prints the page from their browser. This doesn't work too well in terms of graphics resolution and also requires endless positioning tweaking on my part.
Is there a way to use Word or Excel on the client, and send the invoice data down so that some sort of invoice template could be used? This needs to work on a Mac and ideally on a PC as well. The client machines have Office installed. I'm thinking this would be the best way to eliminate the positioning and resolution problems.
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 RelatedHere's what my code looks like...
View Replies View Relatedhere 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.
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?
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.
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
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?
i m getting such number 3001/e-00084308/00/000
so each time i want to change 00 to 01 in above number
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.
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%>
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
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 RelatedMicrosoft 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 ?
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>
Any build in function that can calculate number of records in a table?
View Replies View RelatedI'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.
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 RelatedI 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,
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
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 RelatedI 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!
I want to trim a number and display the integer and decimals
separately, as such I'm trying to convert it to a string so I can
truncate it.
No matter what combination of int or CStr I try, VBScript displays
long numbers such as:
345332523545325425235255453.6789555
in its exponentiated form:
3.45332523545325E+26
How can I stop this?Alternatively is there a function that will separate the two for me?
I have a results page which retrieves a number. I am using "Repeat record" to get a list of all the number records of the database.
I would like to make a sum of all these records at the end of the result page.
record1 = 100 (repeat region)
record2 = 500
record3 = 100
and then, how can I make a sum of these records?
Total = 700
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>"
I have a ASP shopping cart system and sell expensive products that can push the total purchase price over $1000. If the invoice total is more than $999.99... say $1010.00, it passes a value of $1.00 instead of $1010.00. Anything under $999.00 get processed just fine. Of course, Authorize.net say's it's my code and not their system.
Is there a limit to FormatCurrency that would cause it to trim the value? I'm not quite sure where to begin looking but my "hidden x_amount" value thats passed along to the gateway is using FormatCurrency.
Code:
<input type="HIDDEN" name="x_amount" value='<% = FormatCurrency(Request("GrandTotal"))%>'>
Looking at it just know I noticed that the x_amount value is enclosed in ' ' instead of " "... could the comma in the currency value $1,010.00 be ending the code? It happened to some of my product drescriptions that had a comma. Changed it to " " and all was well.