% if not request.Form("step") = "" then step = cLng(request.Form("step")) else step = 0 end If if step = 2 Then Set rsOrderNr = conn.Execute("SELECT TOP 1 * FROM ordernr ORDER BY ordernr DESC") orderNr = rsOrderNr("ordernr") + 1 rsOrderNr.close : Set rsOrderNr = Nothing set rsKundvagn = conn.Execute("SELECT ordrar.ID, produkter.prisSEK AS prisSEK, produkter.prisEUR AS prisEUR, produkter.prisUSD AS prisUSD, produkter.namn AS namn, produkter.artist AS artist, ordrar.antal AS antal FROM (ordrar INNER JOIN produkter ON produkter.ID = ordrar.produkt) WHERE kundvagn = "& session("kundvagn") &" ORDER BY produkter.artist, produkter.namn;") if not rsKundvagn.eof then rsKundvagn.MoveFirst meddelande = "
" meddelande = meddelande &"Dear "& request.Form("namn") &",
"& vbCrLf
Meddelande = meddelande & "Thank you very much for your order. Your ordernumber is BBR-"& orderNr &" and you have ordered the following items:
" &rsKundvagn("antal") &" pcs "& vbCrLf & rsKundvagn("artist") &" - "& rsKundvagn("namn") & vbCrLf &"price each :"& FormatNumber(rsKundvagn("prisSEK"), 2) &" kr | "& FormatNumber(rsKundvagn("prisEUR"), 2) &" | $ "& FormatNumber(rsKundvagn("prisUSD"), 2) & vbCrLf & vbCrLf summaSEK = summaSEK + (rsKundvagn("antal")*rsKundvagn("prisSEK")) summaEUR = summaEUR + (rsKundvagn("antal")*rsKundvagn("prisEUR")) summaUSD = summaUSD + (rsKundvagn("antal")*rsKundvagn("prisUSD")) rsKundvagn.moveNext : loop meddelande = meddelande &"
" Set rsFrakt = conn.Execute("SELECT TOP 1 * FROM frakt WHERE id = "& CLng(request.Form("frakt"))) rsFrakt.MoveFirst meddelande = meddelande &"Total (including shipping fee): "& FormatNumber((summaSEK + rsFrakt("prisSEK")), 2) &" kr | "& FormatNumber((summaEUR + rsFrakt("prisEUR")), 2) &" | $ "& FormatNumber((summaUSD + rsFrakt("prisUSD")), 2) &"
"& vbCrLf &vbCrLf rsFrakt.close : Set rsFrakt = Nothing meddelande = meddelande & "Payment options:
"&vbCrLf meddelande = meddelande & "Bankgiro (Swedish customers only)
"&vbCrLf
meddelande = meddelande & "Send the money to 5882-1331, recipient is B.B.R HB. (Don't forget to write your ordernumber BBR-"& orderNr &" as 'message')
Paypal
"&vbCrLf
meddelande = meddelande & "Send the money to info@kittylitterrecords.se. (Don't forget to write your ordernumber BBR-"& orderNr &" in the 'note'-box)"&vbCrLf&"If you don't have a Paypal account register at www.paypal.com. Paypal makes payment by creditcard possible.
Your shipping information:
"&vbCrLf
formValid = true
if len(Trim(request.form("namn"))) < 1 Then
formValid = False
Else
meddelande = meddelande & ""& Trim(request.form("namn")) &vbCrLf
End if
if len(Trim(request.form("adress"))) < 1 then
formValid = False
Else
meddelande = meddelande & "
"& Trim(request.form("adress")) &vbCrLf
End if
if len(Trim(request.form("postnr"))) < 1 then
formValid = False
Else
meddelande = meddelande & "
"& Trim(request.form("postnr")) &vbCrLf
End if
if len(Trim(request.form("stad"))) < 1 then
formValid = False
Else
meddelande = meddelande & " "& Trim(request.form("stad")) &vbCrLf
End If
if len(Trim(request.form("land"))) < 1 then
formValid = False
Else
meddelande = meddelande & "
"& Trim(request.form("land")) &vbCrLf
End if
meddelande = meddelande & "
"& Trim(request.form("stat")) &vbCrLf
if len(Trim(request.form("epost"))) < 1 then
formValid = False
Else
meddelande = meddelande & "
E-mail: "& Trim(request.form("epost")) &vbCrLf
End if
meddelande = meddelande & "
Please be sure to check your quantities and the item, Then press 'Next'.