- <CFQUERY name="afficher" datasource="nom_de_votre_base_access">
- SELECT * FROM table_de_votre_base WHERE 0=0
- <CFLOOP index="i" from="1" TO="#ListLen(Form.champ_texte, ' ')#">
- AND Nom_Colonne_BD LIKE '%#ListGetAt(Form.champ_texte, i, ' ')#%'
- Or Nom1_Colonne_BD LIKE '%#ListGetAt(Form.champ_texte, i, ' ')#%'
- </CFLOOP>
- or reference = '#Form.champ_texte#'
- </CFQUERY>
-
- <HTML>
- <HEAD>
- <TITLE></TITLE>
- <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></HEAD>
-
- <BODY bgcolor="#0099FF" text="#FFFFFF" link="#FFFFFF" vlink="#FFFFFF" alink="#FFFFFF">
-
- <CFIF #Form.Champ_texte# is "" >
- Vous n'avez rien inscrit
- </CFIF>
-
- <CFIF #afficher.RecordCount# is "0" and #Form.Champ_texte# is not "" >
- Rien ne correpond
- </CFIF>
-
- <cfif #Form.Champ_texte# is not "" and #afficher.RecordCount# is not "0" >
- <cfoutput query="afficher" startrow="1" maxrows="1">
- <B>#afficher.RecordCount#</B> produit <br><br>
- </cfoutput>
- <TABLE border="1" align="center" bordercolor="#999999" bgcolor="#000000">
- <cfoutput query="afficher">
- <TR>
- <TD width="103" >
- <B><font color="##FFFFFF">#CurrentRow#</font>- </B> </TD>
- <TD width="223">
- <P><font color="##FFFFFF">#Nom_Colonne_BD# </font>
- <TD width="144">
- <font color="##FFFFFF"> <b>#Nom1_Colonne_BD#</b></font></TD>
- </TR>
- </cfoutput>
- </TABLE>
- </CFIF>
- <BR><BR>
- <DIV align="center">
- <A href="javascript:history.back()">
- Recherche Infructueuse, cliquez ICI</A>
- </DIV>
- </BODY>
- </HTML>
<CFQUERY name="afficher" datasource="nom_de_votre_base_access">
SELECT * FROM table_de_votre_base WHERE 0=0
<CFLOOP index="i" from="1" TO="#ListLen(Form.champ_texte, ' ')#">
AND Nom_Colonne_BD LIKE '%#ListGetAt(Form.champ_texte, i, ' ')#%'
Or Nom1_Colonne_BD LIKE '%#ListGetAt(Form.champ_texte, i, ' ')#%'
</CFLOOP>
or reference = '#Form.champ_texte#'
</CFQUERY>
<HTML>
<HEAD>
<TITLE></TITLE>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></HEAD>
<BODY bgcolor="#0099FF" text="#FFFFFF" link="#FFFFFF" vlink="#FFFFFF" alink="#FFFFFF">
<CFIF #Form.Champ_texte# is "" >
Vous n'avez rien inscrit
</CFIF>
<CFIF #afficher.RecordCount# is "0" and #Form.Champ_texte# is not "" >
Rien ne correpond
</CFIF>
<cfif #Form.Champ_texte# is not "" and #afficher.RecordCount# is not "0" >
<cfoutput query="afficher" startrow="1" maxrows="1">
<B>#afficher.RecordCount#</B> produit <br><br>
</cfoutput>
<TABLE border="1" align="center" bordercolor="#999999" bgcolor="#000000">
<cfoutput query="afficher">
<TR>
<TD width="103" >
<B><font color="##FFFFFF">#CurrentRow#</font>- </B> </TD>
<TD width="223">
<P><font color="##FFFFFF">#Nom_Colonne_BD# </font>
<TD width="144">
<font color="##FFFFFF"> <b>#Nom1_Colonne_BD#</b></font></TD>
</TR>
</cfoutput>
</TABLE>
</CFIF>
<BR><BR>
<DIV align="center">
<A href="javascript:history.back()">
Recherche Infructueuse, cliquez ICI</A>
</DIV>
</BODY>
</HTML>