1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108
|
<%
Connect
'on recupere la liste des langues
sql="SELECT * FROM langue"
Ouvre sql,res,0
if not estVide(res) then
leslangues = res.getrows()
end if
Fermer res
if request("actions")<>"" then
'recup du nouvel identifiant
sql="SELECT * FROM marque ORDER BY id DESC"
Ouvre sql,res,0
if not estVide(res) then
res.movefirst
leid = res(0)+1
else
leid = 1
end if
Fermer res
for c=0 to Ubound(leslangues,2)
sql="SELECT * FROM marque"
Ouvre sql,res,0
res.addnew
res.fields("id")=leid
res.fields("idlangue")=leslangues(0,c)
res.fields("libelle")=request("libelle"&c)
res.update
Fermer res
next
%>
<script language="javascript">
var o=new Option(document.forms["ajmarque"].libelle1.value,'1');
window.opener.document.forms["ajvehicule"].marque.options[window.opener.document.forms["ajvehicule"].marque.options.length]=o;
self.close();
</script>
<%
end if
Deconnect
%>
<html>
<head>
<title>Ajouter un secteur</title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1250">
<link href="/stylesheet.css" rel="stylesheet" type="text/css">
<script language="javascript">
function Valider(sF){
var bval = true;
<% for b=0 to Ubound(leslangues,2) %>
if (sF.libelle<%=b%>.value=="" && bval){
alert('Veuillez saisir le nom <%=leslangues(1,b)%> de la marque);
bval = false;
sF.libelle<%=b%>.focus();
}
<% next %>
return bval
}
</script>
</head>
<body>
<br>
<form action="./ajmarque.asp" name="ajmarque" method="post" onSubmit="return Valider(this);">
<table width="90%" border="0" cellspacing="0" cellpadding="0" align="center" class="bdr">
<tr>
<td colspan="2" bgcolor="#CCCCCC" style="padding-left:10px; "><span style="color:#FFFFFF ">Ajouter une marque</span></td>
</tr>
<% if isArray(leslangues) then %>
<% for a=0 to Ubound(leslangues,2) %>
<tr>
<td width="45%" style="padding-left:10px; ">Libelle <%=leslangues(1,a)%></td>
<td width="55%" align="right"><input type="text" name="libelle<%=a%>" style="width:150px;"></td>
</tr>
<% next %>
<% end if %>
<tr>
<td colspan="2" align="right"><input type="submit" name="actions" value="Enregistrer >>" class="ref"></td>
</tr>
</table>
</form>
</body> |
Partager