<% Set prodricer = Server.CreateObject("ADODB.Recordset") prodricer.ActiveConnection = MM_ecommerce_STRING prodricer.Source = "SELECT * FROM Prodotti WHERE "&Request.QueryString("campo")&" LIKE '%" + Request.QueryString("cosa") + "%'" prodricer.CursorType = 0 prodricer.CursorLocation = 2 prodricer.LockType = 1 prodricer.Open() prodricer_numRows = 0 %> <% Repeat1__numRows = -1 Repeat1__index = 0 prodricer_numRows = prodricer_numRows + Repeat1__numRows %> E-commerce - Daviduccio.it
Pagina di ricerca

 

Cerca: " size="30">
       
<% If Not prodricer.EOF Or Not prodricer.BOF Then %> <% While ((Repeat1__numRows <> 0) AND (NOT prodricer.EOF)) %> "> <% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 prodricer.MoveNext() Wend %>
Nome Descrizione Prezzo
     
<% des=(prodricer.Fields.Item("Descrizione").Value) if len(des) > 50 then response.Write(mid(des,1,50)&"...") else response.Write(des) end if%>
<%=formatcurrency((prodricer.Fields.Item("Prezzo").Value))%>
<% End If ' end Not prodricer.EOF Or NOT prodricer.BOF %>
<% prodricer.Close() Set prodricer = Nothing %>