28. december 2003 - 14:00Der er
20 kommentarer og 1 løsning
knap virker ikke ?
hej til alle.
jeg sider og laver en site, men på en af siderne fungere knappen ikke . (det gjorde den før jeg skfitet designet ud)
er der nogen der har oplevet det før ? koden for knappen ser sådan ud: <input type="submit" name="Action" value="Opret billet" style="font-weight: 700">
' Open Connection to the database set conn = Server.CreateObject("ADODB.Connection") conn.Open xDb_Conn_Str
Select Case a Case "A": ' Add
' Open record strsql = "SELECT * FROM [OpretBooking] WHERE 0 = 1"
set rs = Server.CreateObject("ADODB.Recordset") rs.Open strsql, conn, 1, 2
rs.AddNew
tmpFld = x_dato If IsDate(tmpFld) Then rs("dato") = cDate(tmpFld) Else rs("dato") = Null End If tmpFld = Trim(x_Maaned) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("Maaned") = tmpFld
tmpFld = Trim(x_Betbetingelser) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("Betbetingelser") = tmpFld
tmpFld = Trim(x_navn) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("navn") = tmpFld
tmpFld = Trim(x_dato) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("Dato") = tmpFld
tmpFld = Trim(x_adresse) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("adresse") = tmpFld
tmpFld = x_postnr If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("postnr") = cLng(tmpFld) tmpFld = Trim(x_city) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("city") = tmpFld tmpFld = x_Telefon If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Telefon") = cLng(tmpFld) tmpFld = x_Profit If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Profit") = cLng(tmpFld) tmpFld = Trim(x_email) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("email") = tmpFld tmpFld = Trim(x_Deltager) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("Deltager") = tmpFld tmpFld = Trim(x_Tekst) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("Tekst") = tmpFld
tmpFld = Trim(x_afrejse) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("afrejse") = tmpFld tmpFld = Trim(x_afrejse1) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("afrejse1") = tmpFld
tmpFld = Trim(x_ankomst) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("ankomst") = tmpFld
tmpFld = Trim(x_ankomst1) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("ankomst1") = tmpFld
tmpFld = x_afrejsedato If IsDate(tmpFld) Then rs("afrejsedato") = cDate(tmpFld) Else rs("afrejsedato") = Null End If
tmpFld = x_hjemrejsedato If IsDate(tmpFld) Then rs("hjemrejsedato") = cDate(tmpFld) Else rs("hjemrejsedato") = Null End If tmpFld = Trim(x_Destairlines) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("Destairlines") = tmpFld
tmpFld = Trim(x_depart) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("depart") = tmpFld
tmpFld = Trim(x_depart1) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("depart1") = tmpFld
tmpFld = Trim(x_arrival1) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("arrival1") = tmpFld
tmpFld = Trim(x_arrival) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("arrival") = tmpFld
tmpFld = Trim(x_flightnr) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("flightnr") = tmpFld
tmpFld = Trim(x_flightnr1) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("flightnr1") = tmpFld
tmpFld = x_Betsenest If IsDate(tmpFld) Then rs("Betsenest") = cDate(tmpFld) Else rs("Betsenest") = Null End If
TotalFld=0 tmpFld = x_voksen If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Voksen") = cDbl(tmpFld) TotalFld=TotalFld+cDbl(tmpFld)
tmpFld = x_Antal If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Antal") = cLng(tmpFld) TotalFld=TotalFld*cDbl(tmpFld)
tmpFld = x_skat If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Skat") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("Antal")
tmpFld = x_Handlingfee If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Handlingfee") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("Antal")
tmpFld = x_PrisTyrkietVoksen If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisTyrkietVoksen") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("Antal")*("0,92")
rs("Total") = TotalFld
TotalFld=0 tmpFld = x_Barn If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Barn") = cDbl(tmpFld) TotalFld=TotalFld+cDbl(tmpFld)
tmpFld = x_AntalBarn If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("AntalBarn") = cLng(tmpFld) TotalFld=TotalFld*cDbl(tmpFld)
tmpFld = x_Skatbarn If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Skatbarn") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("Antalbarn")
tmpFld = x_Handlingfeebarn If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Handlingfeebarn") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("Antalbarn")
tmpFld = x_PrisTyrkietBarn If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisTyrkietBarn") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("AntalBarn")*("0,92")
rs("Totalbarn") = TotalFld
TotalFld=0 tmpFld = x_Infant If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Infant") = cDbl(tmpFld) TotalFld=TotalFld+cDbl(tmpFld)
tmpFld = x_AntalInfant If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("AntalInfant") = cLng(tmpFld) TotalFld=TotalFld*cDbl(tmpFld)
tmpFld = x_Skatinfant If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Skatinfant") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("Antalinfant")
tmpFld = x_Handlingfeeinfant If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Handlingfeeinfant") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("Antalinfant")
tmpFld = x_PrisTyrkietInfant If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisTyrkietInfant") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("AntalInfant")*("0,92")
rs("Totalinfant") = TotalFld
TotalFld=0 tmpFld = x_voksen If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("voksen") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antal")
tmpFld = x_skat If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("skat") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antal")
tmpFld = x_handlingfee If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("handlingfee") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antal")
tmpFld = x_Barn If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Barn") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalbarn")
tmpFld = x_Skatbarn If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Skatbarn") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalbarn")
tmpFld = x_Handlingfeebarn If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Handlingfeebarn") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalbarn")
tmpFld = x_Infant If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Infant") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalinfant")
tmpFld = x_Skatinfant If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Skatinfant") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalinfant")
tmpFld = x_Handlingfeeinfant If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Handlingfeeinfant") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalinfant")
tmpFld = x_PrisTyrkietVoksen If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisTyrkietVoksen") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("Antal")*("0,92")
tmpFld = x_PrisTyrkietBarn If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisTyrkietBarn") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("AntalBarn")*("0,92")
tmpFld = x_PrisTyrkietInfant If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisTyrkietInfant") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("AntalInfant")*("0,92")
rs("Totalalle") = TotalFld
TotalFld=0 tmpFld = x_PrisVoksenSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisVoksenSalg") = cDbl(tmpFld) TotalFld=TotalFld+cDbl(tmpFld)
tmpFld = x_AntalVoksenSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("AntalVoksenSalg") = cLng(tmpFld) TotalFld=TotalFld*cDbl(tmpFld)
tmpFld = x_skatvoksensalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Skatvoksensalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("AntalVoksenSalg")
tmpFld = x_Provision If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Provision") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)
rs("TotalSalgVoksen") = TotalFld
TotalFld=0 tmpFld = x_PrisBarnSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisBarnSalg") = cDbl(tmpFld) TotalFld=TotalFld+cDbl(tmpFld)
tmpFld = x_AntalBarnSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("AntalBarnSalg") = cLng(tmpFld) TotalFld=TotalFld*cDbl(tmpFld)
tmpFld = x_SkatbarnSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("SkatbarnSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("AntalbarnSalg")
rs("TotalSalgbarn") = TotalFld
TotalFld=0 tmpFld = x_PrisInfantSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisInfantSalg") = cDbl(tmpFld) TotalFld=TotalFld+cDbl(tmpFld)
tmpFld = x_AntalInfantSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("AntalInfantSalg") = cLng(tmpFld) TotalFld=TotalFld*cDbl(tmpFld)
tmpFld = x_SkatinfantSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("SkatinfantSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("AntalInfantSalg")
rs("TotalSalginfant") = TotalFld
TotalFld=0 tmpFld = x_PrisVoksenSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisVoksenSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalVoksenSalg")
tmpFld = x_skatVoksenSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("skatVoksenSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalVoksenSalg")
tmpFld = x_PrisBarnSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisBarnSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalbarnSalg")
tmpFld = x_SkatbarnSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("SkatbarnSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalbarnSalg")
tmpFld = x_PrisInfantSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisInfantSalg") = cDbl(tmpFld) TotalFld=TotalFld+cDbl(tmpFld)*rs("antalinfantSalg")
tmpFld = x_SkatinfantSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("SkatinfantSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalinfantSalg")
rs("TotalSalg") = TotalFld
TotalFld=0 tmpFld = x_PrisVoksenSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisVoksenSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalVoksenSalg")
tmpFld = x_skatVoksenSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("skatVoksenSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalVoksenSalg")
tmpFld = x_PrisBarnSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisBarnSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalbarnSalg")
tmpFld = x_SkatbarnSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("SkatbarnSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalbarnSalg")
tmpFld = x_PrisInfantSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisInfantSalg") = cDbl(tmpFld) TotalFld=TotalFld+cDbl(tmpFld)*rs("antalinfantSalg")
tmpFld = x_SkatinfantSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("SkatinfantSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalinfantSalg")
tmpFld = x_Depositium If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Depositium") = cDbl(tmpFld) TotalFld=TotalFld-cLng(tmpFld)
rs("Restbelob") = TotalFld
tmpFld = Trim(x_medarbejder) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("medarbejder") = tmpFld
tmpFld = x_Totalalle If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Totalalle") = cDbl(tmpFld)
tmpFld = Trim(x_Billetnummer) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("Billetnummer") = tmpFld tmpFld = x_Salgspris If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Salgspris") = cDbl(tmpFld)
TotalFld=0 tmpFld = x_PrisVoksenSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisVoksenSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalVoksenSalg")
tmpFld = x_skatVoksenSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("skatVoksenSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalVoksenSalg")
tmpFld = x_Provision If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Provision") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)
tmpFld = x_PrisBarnSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisBarnSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalbarnSalg")
tmpFld = x_SkatbarnSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("SkatbarnSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalbarnSalg")
tmpFld = x_PrisInfantSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisInfantSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalinfantSalg")
tmpFld = x_SkatinfantSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("SkatinfantSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalinfantSalg")
tmpFld = x_voksen If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("voksen") = cDbl(tmpFld) TotalFld=TotalFld-cLng(tmpFld)*rs("antal")
tmpFld = x_PrisTyrkietVoksen If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisTyrkietVoksen") = cDbl(tmpFld) TotalFld=TotalFld-cLng(tmpFld)*rs("Antal")*("0,92")
tmpFld = x_skat If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("skat") = cDbl(tmpFld) TotalFld=TotalFld-cLng(tmpFld)*rs("antal")
tmpFld = x_handlingfee If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("handlingfee") = cDbl(tmpFld) TotalFld=TotalFld-cLng(tmpFld)*rs("antal")
tmpFld = x_Barn If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Barn") = cDbl(tmpFld) TotalFld=TotalFld-cLng(tmpFld)*rs("antalbarn")
tmpFld = x_PrisTyrkietBarn If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisTyrkietBarn") = cDbl(tmpFld) TotalFld=TotalFld-cLng(tmpFld)*rs("antalBarn")*("0,92")
tmpFld = x_Skatbarn If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Skatbarn") = cDbl(tmpFld) TotalFld=TotalFld-cLng(tmpFld)*rs("antalbarn")
tmpFld = x_Handlingfeebarn If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Handlingfeebarn") = cDbl(tmpFld) TotalFld=TotalFld-cLng(tmpFld)*rs("antalbarn")
tmpFld = x_Infant If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Infant") = cDbl(tmpFld) TotalFld=TotalFld-cLng(tmpFld)*rs("antalinfant")
tmpFld = x_PrisTyrkietInfant If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisTyrkietInfant") = cDbl(tmpFld) TotalFld=TotalFld-cLng(tmpFld)*rs("antalInfant")*("0,92")
tmpFld = x_Skatinfant If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Skatinfant") = cDbl(tmpFld) TotalFld=TotalFld-cLng(tmpFld)*rs("antalinfant")
tmpFld = x_Handlingfeeinfant If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Handlingfeeinfant") = cDbl(tmpFld) TotalFld=TotalFld-cLng(tmpFld)*rs("antalinfant")
rs("provision") = TotalFld
rs.Update rs.Close Set rs = Nothing conn.Close Set conn = Nothing Response.Clear Response.Redirect "OpretBookingview.asp" End Select %> <!--#include file="include.asp"-->
En anden ting som kan drille i IE er når ikke skriver noget action og filen er en default.asp fil så kan den ikke gennemskue filnavn:
<form name="online" method="post" action="">
Er de samme fil den skal loade bruger jeg at skrive action="<%=Request.ServerVariables("SECRIPT_NAME")%>" fordi den så automatisk udfylder filnavnet og så skulle det virker i alle browsere :
' Open Connection to the database set conn = Server.CreateObject("ADODB.Connection") conn.Open xDb_Conn_Str
Select Case a Case "A": ' Add
' Open record strsql = "SELECT * FROM [OpretBooking] WHERE 0 = 1"
set rs = Server.CreateObject("ADODB.Recordset") rs.Open strsql, conn, 1, 2
rs.AddNew
tmpFld = x_dato If IsDate(tmpFld) Then rs("dato") = cDate(tmpFld) Else rs("dato") = Null End If tmpFld = Trim(x_Maaned) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("Maaned") = tmpFld
tmpFld = Trim(x_Betbetingelser) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("Betbetingelser") = tmpFld
tmpFld = Trim(x_navn) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("navn") = tmpFld
tmpFld = Trim(x_dato) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("Dato") = tmpFld
tmpFld = Trim(x_adresse) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("adresse") = tmpFld
tmpFld = x_postnr If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("postnr") = cLng(tmpFld) tmpFld = Trim(x_city) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("city") = tmpFld tmpFld = x_Telefon If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Telefon") = cLng(tmpFld) tmpFld = x_Profit If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Profit") = cLng(tmpFld) tmpFld = Trim(x_email) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("email") = tmpFld tmpFld = Trim(x_Deltager) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("Deltager") = tmpFld tmpFld = Trim(x_Tekst) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("Tekst") = tmpFld
tmpFld = Trim(x_afrejse) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("afrejse") = tmpFld tmpFld = Trim(x_afrejse1) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("afrejse1") = tmpFld
tmpFld = Trim(x_ankomst) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("ankomst") = tmpFld
tmpFld = Trim(x_ankomst1) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("ankomst1") = tmpFld
tmpFld = x_afrejsedato If IsDate(tmpFld) Then rs("afrejsedato") = cDate(tmpFld) Else rs("afrejsedato") = Null End If
tmpFld = x_hjemrejsedato If IsDate(tmpFld) Then rs("hjemrejsedato") = cDate(tmpFld) Else rs("hjemrejsedato") = Null End If tmpFld = Trim(x_Destairlines) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("Destairlines") = tmpFld
tmpFld = Trim(x_depart) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("depart") = tmpFld
tmpFld = Trim(x_depart1) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("depart1") = tmpFld
tmpFld = Trim(x_arrival1) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("arrival1") = tmpFld
tmpFld = Trim(x_arrival) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("arrival") = tmpFld
tmpFld = Trim(x_flightnr) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("flightnr") = tmpFld
tmpFld = Trim(x_flightnr1) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("flightnr1") = tmpFld
tmpFld = x_Betsenest If IsDate(tmpFld) Then rs("Betsenest") = cDate(tmpFld) Else rs("Betsenest") = Null End If
TotalFld=0 tmpFld = x_voksen If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Voksen") = cDbl(tmpFld) TotalFld=TotalFld+cDbl(tmpFld)
tmpFld = x_Antal If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Antal") = cLng(tmpFld) TotalFld=TotalFld*cDbl(tmpFld)
tmpFld = x_skat If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Skat") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("Antal")
tmpFld = x_Handlingfee If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Handlingfee") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("Antal")
tmpFld = x_PrisTyrkietVoksen If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisTyrkietVoksen") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("Antal")*("0,92")
rs("Total") = TotalFld
TotalFld=0 tmpFld = x_Barn If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Barn") = cDbl(tmpFld) TotalFld=TotalFld+cDbl(tmpFld)
tmpFld = x_AntalBarn If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("AntalBarn") = cLng(tmpFld) TotalFld=TotalFld*cDbl(tmpFld)
tmpFld = x_Skatbarn If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Skatbarn") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("Antalbarn")
tmpFld = x_Handlingfeebarn If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Handlingfeebarn") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("Antalbarn")
tmpFld = x_PrisTyrkietBarn If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisTyrkietBarn") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("AntalBarn")*("0,92")
rs("Totalbarn") = TotalFld
TotalFld=0 tmpFld = x_Infant If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Infant") = cDbl(tmpFld) TotalFld=TotalFld+cDbl(tmpFld)
tmpFld = x_AntalInfant If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("AntalInfant") = cLng(tmpFld) TotalFld=TotalFld*cDbl(tmpFld)
tmpFld = x_Skatinfant If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Skatinfant") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("Antalinfant")
tmpFld = x_Handlingfeeinfant If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Handlingfeeinfant") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("Antalinfant")
tmpFld = x_PrisTyrkietInfant If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisTyrkietInfant") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("AntalInfant")*("0,92")
rs("Totalinfant") = TotalFld
TotalFld=0 tmpFld = x_voksen If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("voksen") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antal")
tmpFld = x_skat If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("skat") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antal")
tmpFld = x_handlingfee If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("handlingfee") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antal")
tmpFld = x_Barn If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Barn") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalbarn")
tmpFld = x_Skatbarn If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Skatbarn") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalbarn")
tmpFld = x_Handlingfeebarn If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Handlingfeebarn") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalbarn")
tmpFld = x_Infant If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Infant") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalinfant")
tmpFld = x_Skatinfant If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Skatinfant") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalinfant")
tmpFld = x_Handlingfeeinfant If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Handlingfeeinfant") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalinfant")
tmpFld = x_PrisTyrkietVoksen If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisTyrkietVoksen") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("Antal")*("0,92")
tmpFld = x_PrisTyrkietBarn If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisTyrkietBarn") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("AntalBarn")*("0,92")
tmpFld = x_PrisTyrkietInfant If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisTyrkietInfant") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("AntalInfant")*("0,92")
rs("Totalalle") = TotalFld
TotalFld=0 tmpFld = x_PrisVoksenSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisVoksenSalg") = cDbl(tmpFld) TotalFld=TotalFld+cDbl(tmpFld)
tmpFld = x_AntalVoksenSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("AntalVoksenSalg") = cLng(tmpFld) TotalFld=TotalFld*cDbl(tmpFld)
tmpFld = x_skatvoksensalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Skatvoksensalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("AntalVoksenSalg")
tmpFld = x_Provision If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Provision") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)
rs("TotalSalgVoksen") = TotalFld
TotalFld=0 tmpFld = x_PrisBarnSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisBarnSalg") = cDbl(tmpFld) TotalFld=TotalFld+cDbl(tmpFld)
tmpFld = x_AntalBarnSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("AntalBarnSalg") = cLng(tmpFld) TotalFld=TotalFld*cDbl(tmpFld)
tmpFld = x_SkatbarnSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("SkatbarnSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("AntalbarnSalg")
rs("TotalSalgbarn") = TotalFld
TotalFld=0 tmpFld = x_PrisInfantSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisInfantSalg") = cDbl(tmpFld) TotalFld=TotalFld+cDbl(tmpFld)
tmpFld = x_AntalInfantSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("AntalInfantSalg") = cLng(tmpFld) TotalFld=TotalFld*cDbl(tmpFld)
tmpFld = x_SkatinfantSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("SkatinfantSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("AntalInfantSalg")
rs("TotalSalginfant") = TotalFld
TotalFld=0 tmpFld = x_PrisVoksenSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisVoksenSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalVoksenSalg")
tmpFld = x_skatVoksenSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("skatVoksenSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalVoksenSalg")
tmpFld = x_PrisBarnSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisBarnSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalbarnSalg")
tmpFld = x_SkatbarnSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("SkatbarnSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalbarnSalg")
tmpFld = x_PrisInfantSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisInfantSalg") = cDbl(tmpFld) TotalFld=TotalFld+cDbl(tmpFld)*rs("antalinfantSalg")
tmpFld = x_SkatinfantSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("SkatinfantSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalinfantSalg")
rs("TotalSalg") = TotalFld
TotalFld=0 tmpFld = x_PrisVoksenSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisVoksenSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalVoksenSalg")
tmpFld = x_skatVoksenSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("skatVoksenSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalVoksenSalg")
tmpFld = x_PrisBarnSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisBarnSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalbarnSalg")
tmpFld = x_SkatbarnSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("SkatbarnSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalbarnSalg")
tmpFld = x_PrisInfantSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisInfantSalg") = cDbl(tmpFld) TotalFld=TotalFld+cDbl(tmpFld)*rs("antalinfantSalg")
tmpFld = x_SkatinfantSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("SkatinfantSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalinfantSalg")
tmpFld = x_Depositium If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Depositium") = cDbl(tmpFld) TotalFld=TotalFld-cLng(tmpFld)
rs("Restbelob") = TotalFld
tmpFld = Trim(x_medarbejder) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("medarbejder") = tmpFld
tmpFld = x_Totalalle If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Totalalle") = cDbl(tmpFld)
tmpFld = Trim(x_Billetnummer) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("Billetnummer") = tmpFld tmpFld = x_Salgspris If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Salgspris") = cDbl(tmpFld)
TotalFld=0 tmpFld = x_PrisVoksenSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisVoksenSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalVoksenSalg")
tmpFld = x_skatVoksenSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("skatVoksenSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalVoksenSalg")
tmpFld = x_Provision If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Provision") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)
tmpFld = x_PrisBarnSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisBarnSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalbarnSalg")
tmpFld = x_SkatbarnSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("SkatbarnSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalbarnSalg")
tmpFld = x_PrisInfantSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisInfantSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalinfantSalg")
tmpFld = x_SkatinfantSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("SkatinfantSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalinfantSalg")
tmpFld = x_voksen If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("voksen") = cDbl(tmpFld) TotalFld=TotalFld-cLng(tmpFld)*rs("antal")
tmpFld = x_PrisTyrkietVoksen If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisTyrkietVoksen") = cDbl(tmpFld) TotalFld=TotalFld-cLng(tmpFld)*rs("Antal")*("0,92")
tmpFld = x_skat If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("skat") = cDbl(tmpFld) TotalFld=TotalFld-cLng(tmpFld)*rs("antal")
tmpFld = x_handlingfee If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("handlingfee") = cDbl(tmpFld) TotalFld=TotalFld-cLng(tmpFld)*rs("antal")
tmpFld = x_Barn If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Barn") = cDbl(tmpFld) TotalFld=TotalFld-cLng(tmpFld)*rs("antalbarn")
tmpFld = x_PrisTyrkietBarn If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisTyrkietBarn") = cDbl(tmpFld) TotalFld=TotalFld-cLng(tmpFld)*rs("antalBarn")*("0,92")
tmpFld = x_Skatbarn If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Skatbarn") = cDbl(tmpFld) TotalFld=TotalFld-cLng(tmpFld)*rs("antalbarn")
tmpFld = x_Handlingfeebarn If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Handlingfeebarn") = cDbl(tmpFld) TotalFld=TotalFld-cLng(tmpFld)*rs("antalbarn")
tmpFld = x_Infant If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Infant") = cDbl(tmpFld) TotalFld=TotalFld-cLng(tmpFld)*rs("antalinfant")
tmpFld = x_PrisTyrkietInfant If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisTyrkietInfant") = cDbl(tmpFld) TotalFld=TotalFld-cLng(tmpFld)*rs("antalInfant")*("0,92")
tmpFld = x_Skatinfant If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Skatinfant") = cDbl(tmpFld) TotalFld=TotalFld-cLng(tmpFld)*rs("antalinfant")
tmpFld = x_Handlingfeeinfant If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Handlingfeeinfant") = cDbl(tmpFld) TotalFld=TotalFld-cLng(tmpFld)*rs("antalinfant")
rs("provision") = TotalFld
rs.Update rs.Close Set rs = Nothing conn.Close Set conn = Nothing Response.Clear Response.Redirect "OpretBookingview.asp" End Select %> <!--#include file="include.asp"-->
' Open Connection to the database set conn = Server.CreateObject("ADODB.Connection") conn.Open xDb_Conn_Str
Select Case a Case "A": ' Add
' Open record strsql = "SELECT * FROM [OpretBooking] WHERE 0 = 1"
set rs = Server.CreateObject("ADODB.Recordset") rs.Open strsql, conn, 1, 2
rs.AddNew
tmpFld = x_dato If IsDate(tmpFld) Then rs("dato") = cDate(tmpFld) Else rs("dato") = Null End If tmpFld = Trim(x_Maaned) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("Maaned") = tmpFld
tmpFld = Trim(x_Betbetingelser) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("Betbetingelser") = tmpFld
tmpFld = Trim(x_navn) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("navn") = tmpFld
tmpFld = Trim(x_dato) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("Dato") = tmpFld
tmpFld = Trim(x_adresse) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("adresse") = tmpFld
tmpFld = x_postnr If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("postnr") = cLng(tmpFld) tmpFld = Trim(x_city) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("city") = tmpFld tmpFld = x_Telefon If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Telefon") = cLng(tmpFld) tmpFld = x_Profit If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Profit") = cLng(tmpFld) tmpFld = Trim(x_email) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("email") = tmpFld tmpFld = Trim(x_Deltager) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("Deltager") = tmpFld tmpFld = Trim(x_Tekst) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("Tekst") = tmpFld
tmpFld = Trim(x_afrejse) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("afrejse") = tmpFld tmpFld = Trim(x_afrejse1) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("afrejse1") = tmpFld
tmpFld = Trim(x_ankomst) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("ankomst") = tmpFld
tmpFld = Trim(x_ankomst1) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("ankomst1") = tmpFld
tmpFld = x_afrejsedato If IsDate(tmpFld) Then rs("afrejsedato") = cDate(tmpFld) Else rs("afrejsedato") = Null End If
tmpFld = x_hjemrejsedato If IsDate(tmpFld) Then rs("hjemrejsedato") = cDate(tmpFld) Else rs("hjemrejsedato") = Null End If tmpFld = Trim(x_Destairlines) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("Destairlines") = tmpFld
tmpFld = Trim(x_depart) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("depart") = tmpFld
tmpFld = Trim(x_depart1) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("depart1") = tmpFld
tmpFld = Trim(x_arrival1) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("arrival1") = tmpFld
tmpFld = Trim(x_arrival) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("arrival") = tmpFld
tmpFld = Trim(x_flightnr) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("flightnr") = tmpFld
tmpFld = Trim(x_flightnr1) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("flightnr1") = tmpFld
tmpFld = x_Betsenest If IsDate(tmpFld) Then rs("Betsenest") = cDate(tmpFld) Else rs("Betsenest") = Null End If
TotalFld=0 tmpFld = x_voksen If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Voksen") = cDbl(tmpFld) TotalFld=TotalFld+cDbl(tmpFld)
tmpFld = x_Antal If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Antal") = cLng(tmpFld) TotalFld=TotalFld*cDbl(tmpFld)
tmpFld = x_skat If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Skat") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("Antal")
tmpFld = x_Handlingfee If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Handlingfee") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("Antal")
tmpFld = x_PrisTyrkietVoksen If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisTyrkietVoksen") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("Antal")*("0,92")
rs("Total") = TotalFld
TotalFld=0 tmpFld = x_Barn If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Barn") = cDbl(tmpFld) TotalFld=TotalFld+cDbl(tmpFld)
tmpFld = x_AntalBarn If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("AntalBarn") = cLng(tmpFld) TotalFld=TotalFld*cDbl(tmpFld)
tmpFld = x_Skatbarn If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Skatbarn") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("Antalbarn")
tmpFld = x_Handlingfeebarn If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Handlingfeebarn") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("Antalbarn")
tmpFld = x_PrisTyrkietBarn If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisTyrkietBarn") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("AntalBarn")*("0,92")
rs("Totalbarn") = TotalFld
TotalFld=0 tmpFld = x_Infant If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Infant") = cDbl(tmpFld) TotalFld=TotalFld+cDbl(tmpFld)
tmpFld = x_AntalInfant If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("AntalInfant") = cLng(tmpFld) TotalFld=TotalFld*cDbl(tmpFld)
tmpFld = x_Skatinfant If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Skatinfant") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("Antalinfant")
tmpFld = x_Handlingfeeinfant If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Handlingfeeinfant") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("Antalinfant")
tmpFld = x_PrisTyrkietInfant If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisTyrkietInfant") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("AntalInfant")*("0,92")
rs("Totalinfant") = TotalFld
TotalFld=0 tmpFld = x_voksen If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("voksen") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antal")
tmpFld = x_skat If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("skat") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antal")
tmpFld = x_handlingfee If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("handlingfee") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antal")
tmpFld = x_Barn If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Barn") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalbarn")
tmpFld = x_Skatbarn If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Skatbarn") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalbarn")
tmpFld = x_Handlingfeebarn If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Handlingfeebarn") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalbarn")
tmpFld = x_Infant If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Infant") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalinfant")
tmpFld = x_Skatinfant If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Skatinfant") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalinfant")
tmpFld = x_Handlingfeeinfant If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Handlingfeeinfant") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalinfant")
tmpFld = x_PrisTyrkietVoksen If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisTyrkietVoksen") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("Antal")*("0,92")
tmpFld = x_PrisTyrkietBarn If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisTyrkietBarn") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("AntalBarn")*("0,92")
tmpFld = x_PrisTyrkietInfant If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisTyrkietInfant") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("AntalInfant")*("0,92")
rs("Totalalle") = TotalFld
TotalFld=0 tmpFld = x_PrisVoksenSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisVoksenSalg") = cDbl(tmpFld) TotalFld=TotalFld+cDbl(tmpFld)
tmpFld = x_AntalVoksenSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("AntalVoksenSalg") = cLng(tmpFld) TotalFld=TotalFld*cDbl(tmpFld)
tmpFld = x_skatvoksensalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Skatvoksensalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("AntalVoksenSalg")
tmpFld = x_Provision If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Provision") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)
rs("TotalSalgVoksen") = TotalFld
TotalFld=0 tmpFld = x_PrisBarnSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisBarnSalg") = cDbl(tmpFld) TotalFld=TotalFld+cDbl(tmpFld)
tmpFld = x_AntalBarnSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("AntalBarnSalg") = cLng(tmpFld) TotalFld=TotalFld*cDbl(tmpFld)
tmpFld = x_SkatbarnSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("SkatbarnSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("AntalbarnSalg")
rs("TotalSalgbarn") = TotalFld
TotalFld=0 tmpFld = x_PrisInfantSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisInfantSalg") = cDbl(tmpFld) TotalFld=TotalFld+cDbl(tmpFld)
tmpFld = x_AntalInfantSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("AntalInfantSalg") = cLng(tmpFld) TotalFld=TotalFld*cDbl(tmpFld)
tmpFld = x_SkatinfantSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("SkatinfantSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("AntalInfantSalg")
rs("TotalSalginfant") = TotalFld
TotalFld=0 tmpFld = x_PrisVoksenSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisVoksenSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalVoksenSalg")
tmpFld = x_skatVoksenSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("skatVoksenSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalVoksenSalg")
tmpFld = x_PrisBarnSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisBarnSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalbarnSalg")
tmpFld = x_SkatbarnSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("SkatbarnSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalbarnSalg")
tmpFld = x_PrisInfantSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisInfantSalg") = cDbl(tmpFld) TotalFld=TotalFld+cDbl(tmpFld)*rs("antalinfantSalg")
tmpFld = x_SkatinfantSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("SkatinfantSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalinfantSalg")
rs("TotalSalg") = TotalFld
TotalFld=0 tmpFld = x_PrisVoksenSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisVoksenSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalVoksenSalg")
tmpFld = x_skatVoksenSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("skatVoksenSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalVoksenSalg")
tmpFld = x_PrisBarnSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisBarnSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalbarnSalg")
tmpFld = x_SkatbarnSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("SkatbarnSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalbarnSalg")
tmpFld = x_PrisInfantSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisInfantSalg") = cDbl(tmpFld) TotalFld=TotalFld+cDbl(tmpFld)*rs("antalinfantSalg")
tmpFld = x_SkatinfantSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("SkatinfantSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalinfantSalg")
tmpFld = x_Depositium If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Depositium") = cDbl(tmpFld) TotalFld=TotalFld-cLng(tmpFld)
rs("Restbelob") = TotalFld
tmpFld = Trim(x_medarbejder) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("medarbejder") = tmpFld
tmpFld = x_Totalalle If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Totalalle") = cDbl(tmpFld)
tmpFld = Trim(x_Billetnummer) If trim(tmpFld) & "x" = "x" Then tmpFld = Null rs("Billetnummer") = tmpFld tmpFld = x_Salgspris If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Salgspris") = cDbl(tmpFld)
TotalFld=0 tmpFld = x_PrisVoksenSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisVoksenSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalVoksenSalg")
tmpFld = x_skatVoksenSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("skatVoksenSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalVoksenSalg")
tmpFld = x_Provision If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Provision") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)
tmpFld = x_PrisBarnSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisBarnSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalbarnSalg")
tmpFld = x_SkatbarnSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("SkatbarnSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalbarnSalg")
tmpFld = x_PrisInfantSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisInfantSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalinfantSalg")
tmpFld = x_SkatinfantSalg If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("SkatinfantSalg") = cDbl(tmpFld) TotalFld=TotalFld+cLng(tmpFld)*rs("antalinfantSalg")
tmpFld = x_voksen If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("voksen") = cDbl(tmpFld) TotalFld=TotalFld-cLng(tmpFld)*rs("antal")
tmpFld = x_PrisTyrkietVoksen If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisTyrkietVoksen") = cDbl(tmpFld) TotalFld=TotalFld-cLng(tmpFld)*rs("Antal")*("0,92")
tmpFld = x_skat If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("skat") = cDbl(tmpFld) TotalFld=TotalFld-cLng(tmpFld)*rs("antal")
tmpFld = x_handlingfee If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("handlingfee") = cDbl(tmpFld) TotalFld=TotalFld-cLng(tmpFld)*rs("antal")
tmpFld = x_Barn If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Barn") = cDbl(tmpFld) TotalFld=TotalFld-cLng(tmpFld)*rs("antalbarn")
tmpFld = x_PrisTyrkietBarn If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisTyrkietBarn") = cDbl(tmpFld) TotalFld=TotalFld-cLng(tmpFld)*rs("antalBarn")*("0,92")
tmpFld = x_Skatbarn If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Skatbarn") = cDbl(tmpFld) TotalFld=TotalFld-cLng(tmpFld)*rs("antalbarn")
tmpFld = x_Handlingfeebarn If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Handlingfeebarn") = cDbl(tmpFld) TotalFld=TotalFld-cLng(tmpFld)*rs("antalbarn")
tmpFld = x_Infant If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Infant") = cDbl(tmpFld) TotalFld=TotalFld-cLng(tmpFld)*rs("antalinfant")
tmpFld = x_PrisTyrkietInfant If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("PrisTyrkietInfant") = cDbl(tmpFld) TotalFld=TotalFld-cLng(tmpFld)*rs("antalInfant")*("0,92")
tmpFld = x_Skatinfant If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Skatinfant") = cDbl(tmpFld) TotalFld=TotalFld-cLng(tmpFld)*rs("antalinfant")
tmpFld = x_Handlingfeeinfant If Not IsNumeric(tmpFld) Then tmpFld = 0 rs("Handlingfeeinfant") = cDbl(tmpFld) TotalFld=TotalFld-cLng(tmpFld)*rs("antalinfant")
rs("provision") = TotalFld
rs.Update rs.Close Set rs = Nothing conn.Close Set conn = Nothing Response.Clear Response.Redirect "OpretBookingprocces.asp" End Select %> <!--#include file="include.asp"-->
superior kan du ikke smide et svar ind så kan jeg dele poin :)
Synes godt om
Ny brugerNybegynder
Din løsning...
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.