bon merci infiniment pour votre réponse, mon objectif est de garder le parametre pour l'utiliser
dans la requete. la requette ne retourne aucune valeur ...
y'a t'il une solution?
page.htm
<td width="23%" height="8">
<a href=rillettes.asp?m=Les Rillettes>
<font face="Century Gothic" size="1" color="#800000">Les Rillettes</font>
</a></td>
-------------------------
page rillettes.asp
<%@ Language="JScript" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Nouvelle page 1</title>
</head>
<body>
<%
var OBJdbConnection;
var SQLQuery2;
var sql2;
var m;
m = Request.Querystring("m");
OBJdbConnection = Server.CreateObject("ADODB.Connection");
connstring="DRIVER={Microsoft Access Driver (*.mdb)};" + " DBQ=" + Server.MapPath(".") + "/base.mdb";
OBJdbConnection.Open (connstring);
SQLQuery2 = "SELECT * FROM Categories WHERE(Designation_cat='"+ m +"')";
sql2 = OBJdbConnection.Execute(SQLQuery2);
%>
<input type="hidden" name="TABARTICLE" value="1">
<div align="center">
<center>
<table name="TABARTICLE" border="0" cellpadding="0" cellspacing="0" width="90%" height="284">
<tr>
<td width="100%" colspan="3" height="40">
<br>
</td>
</tr>
<%
if (!(sql2.EOF))
{
%>
<tr>
<td width="5%" height="223" rowspan="5"></td>
<td width="90%" height="32"><p align="center">
<b><font face="Verdana" size="2" color="#800000"><%=m%></font></b><br><br>
</td>
<td width="5%" height="223" rowspan="5"></td>
</tr>
<tr>
<td width="90%" height="65"><font face="Century Gothic" size="1"><%=sql2("commentaire")%></font></td>
</tr>
<%
}
sql2.Close();
sql2 = null;
%>
</table>
</center>
</div>
</body>
</html>