i have created a site using dreamweaver mx 2004 and ms-access. i have created a search facility which searches for a product based on two fields. What i would like to do is a search based on either or both of the two fields.

WHERE field1 = criteria OR field2 = criteria

This is the code from the search results page, it doesnt return any results

<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="Connections/Petwise.asp" -->
<%
Dim rsResults__MMColParam
rsResults__MMColParam = "1"
If (Request.Form("ysBrand") <> "") Then
rsResults__MMColParam = Request.Form("ysBrand")
End If
%>
<%
Dim rsResults__ysCat
rsResults__ysCat = "1"
If (Request.Form("ysCategory") <> "") Then
rsResults__ysCat = Request.Form("ysCategory")
End If
%>
<%
Dim rsResults
Dim rsResults_numRows

Set rsResults = Server.CreateObject("ADODB.Recordset")
rsResults.ActiveConnection = MM_Petwise_STRING
rsResults.Source = "SELECT * FROM Product WHERE Brand = '" + Replace(rsResults__MMColParam, "'", "''") + "' OR Category = '" + Replace(rsResults__ysCat, "'", "''") + "'"
rsResults.CursorType = 0
rsResults.CursorLocation = 2
rsResults.LockType = 1
rsResults.Open()

rsResults_numRows = 0
%>

what does the query look like when built ?

this is the query

yes very nice, could we now see the SQL code AFTER your form has been submitted and the query has been built.

it's the value of the variables that is sent to the query that is important NOT the construction.

i hope this is the correct piece of code- excuse my ignorance

<td colspan="2">Product: <span class="TextMain"><%=(rsProdDetails.Fields.Item("Pr odName").Value)%></span></td>
<td width="200" rowspan="3" align="center" valign="middle"><img src="<%=(rsProdDetails.Fields.Item("Picture").Valu e)%>"></td>
</tr>
<tr class="TextAdminBold">
<td width="221">Brand: <span class="TextMain"><%=(rsProdDetails.Fields.Item("Br and").Value)%></span></td>
<td width="203">Category: <span class="TextMain"><%=(rsProdDetails.Fields.Item("Ca tegory").Value)%></span></td>
</tr>
<tr class="TextAdminBold">
<td colspan="2">Price &pound;<span class="TextMain"><%= FormatNumber((rsProdDetails.Fields.Item("Price").V alue), 2, -2, -2, -2) %></span></td>
</tr>
<tr class="TextAdminBold">
<td colspan="3">Description: <span class="TextMain"><%=(rsProdDetails.Fields.Item("De scription").Value)%></span></td>
</tr>
</table>
<p align="center"><a href="javascript:history.go(-1)" class="TextBold">&lt;&lt; Back</a></p>
<p>&nbsp;</p></td>
</tr>
</table>

Nope I need you to response.write out the value of rsResults.source and paste the actual text that appears in the browser.

It's debugging101 "Print out the bits that are going wrong so you can see why they are wrong"