1 2 3 4 5
|
ajout="insert into MARKETING(num_dossier,operatice,tel,mobile,civilite,nom,prenom,appel_stat,status,type_contact,type_interet,jour_rappel,heure_rappel,fax,email,courrier,sms,dept,commercial,jour_rdv,heure_rdv,rapport,jour_operation,heure_operation,code_trait)VALUES('" & num_dossier & "','" & session("login") & "','" & request.Form("tel") & "','" & request.Form("mobile") & "','" & request.Form("civilite") & "','" & request.Form("nom") & "','" & request.Form("prenom") & "','" & request.Form("appel_stat")& "','" & request.Form("status") & "','" & request.Form("type_contact") & "','" & request.Form("type_interet") & "','" & jour_rappel & "','" & heure_rappel & "','" & fax & "','" & email & "','" & courrier & "','" & sms & "','" & request.Form("dept") & "','" & request.Form("commercial") & "','" & jour_rdv & "','" & heure_rdv & "','" & replace(request.Form("rapport"),"'","''") & "','" & year(date()) & "-" & month(date()) & "-" & day(date()) & "','" & heure_operation & "','" & request.Form("code_trait") & "')"
conn.execute(ajout)
mis="update identite set code_trait='" & request.Form("code_trait") & "' where num_dossier='" & num_dossier & "'"
conn.execute(mis) |
Partager