<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> Volley-Ball Club Tihange - Huy
<% IDJ = Request.QueryString("IDJ") IDV = Request.QueryString("IDV") montantPaye = Request.QueryString("montantPaye") PayDay = Request.QueryString("PayDay") PayMonth = Request.QueryString("PayMonth") PayYear = Request.QueryString("PayYear") datePaiement = PayYear & "-" & PayMonth & "-" & PayDay typePaiement = Request.QueryString("typePaiement") APayer = Request.QueryString("APayer") ResteAPayer = APayer - montantPaye Communication = Request.QueryString("Communication") Set rsAddVenteJPay = Server.CreateObject("ADODB.Recordset") sqlAddVenteJPay = "INSERT INTO RelVenteJoueurCompte_club (idV, idJ, typePaiement, datePaiement, montantPaye, Communication)" & _ " VALUES (" & _ ToSQL(IDV, "Number") & ", " & _ ToSQL(IDJ, "Number") & ", " & _ ToSQL(typePaiement, "Text") & ", " & _ "'" & datePaiement & "', " & _ ToSQL(montantPaye, "Number") & ", " & _ ToSQL(Communication, "Text") & ")" openrs rsAddVenteJPay, sqlAddVenteJPay If Request.QueryString("location") = "admin" then Response.Redirect("mypayventeadmin.asp?idJ=" & IDJ & "&idV=" & IDV & "&APayer=" & ResteAPayer) else Response.Redirect("mypayvente.asp?idJ=" & IDJ & "&idV=" & IDV & "&APayer=" & ResteAPayer) end if %>