le probleme c'est que tu double tes cotes dans LCAUSE mais tu insere dans la BDD le LCAUSE Non modifié (Request.Form("LCAUSE") )
voilà c corrigé :
SQL = "INSERT INTO Renault(NORDRE, CFOU, CADRES, DESFOU, VILLE, NPIE, DESPIE, FAMACH, PROJET, SAH, LUSINECR, CUSINE, LTECUSI, TINCID, DINCID, QTENC, LACTDEM, CVEHORG, CCAUSE, LCAUSE, QDEMTOT) VALUES('" & Request.Form("NORDRE1") & "', '" & Request.Form("CFOU1") & "', '" & Request.Form("CADRES1") & "', '" & Request.Form("DESFOU1") & "', '" & Request.Form("VILLE1") & "', '" & Request.Form("NPIE1") & "', '" & Request.Form("DESPIE1") & "', '" & Request.Form("FAMACH1") & "', '" & Request.Form("PROJET1") & "', '" & Request.Form("SAH1") & "', '" & Request.Form("LUSINECR1") & "', '" & Request.Form("CUSINE1") & "', '" & Request.Form("LTECUSI1") & "', '" & Request.Form("TINCID1") & "', '" & Request.Form("DINCID1") & "', '" & Request.Form("QTENC1") & "', '" & Request.Form("LACTDEM1") & "', '" & Request.Form("CVEHORG1") & "', '" & Request.Form("CCAUSE1") & "', '" & LCAUSE & "', '" & Request.Form("QDEMTOT1") & "')"
|