Having some trouble with the record set in creating a search results page. I place in the name, connection,table hit test an its OK. When i go to select a filter and hit test it displays [microsoft][ODBC Microsoft Access Driver] syntax error(missing operator) in query expression 'coloum name'
I'm a little new to UD but willing to go the hard yards. Anyone got any answers.
thanx

What is the code from the the results page?

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Having some trouble with the record set in creating a search results page. I place in the name, connection,table hit test an its OK. When i go to select a filter and hit test it displays [microsoft][ODBC Microsoft Access Driver] syntax error(missing operator) in query expression 'coloum name'
I'm a little new to UD but willing to go the hard yards. Anyone got any answers.
thanx


<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

S Bloodworth

&lt;%@LANGUAGE="VBSCRIPT"%&gt;
&lt;!--#include file="Connections/VIEW_DATA.asp" --&gt;
&lt;%
Dim Recordset1__MMColParam
Recordset1__MMColParam = "1"
if (Request.QueryString("form1" &lt;&gt; "" then Recordset1__MMColParam = Request.QueryString("form1"
%&gt;
&lt;%
set Recordset1 = Server.CreateObject("ADODB.Recordset"
Recordset1.ActiveConnection = MM_VIEW_DATA_STRING
Recordset1.Source = "SELECT * FROM Main_tbl1 WHERE Stock Receipt Number = " + Replace(Recordset1__MMColParam, "'", "''" + ""
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 3
Recordset1.Open()
Recordset1_numRows = 0
%&gt;
&lt;html&gt;
&lt;head&gt;
&lt;title&gt;Results&lt;/title&gt;
&lt;meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"&gt;
&lt;/head&gt;
&lt;body bgcolor="#FFFFFF" text="#000000"&gt;
&lt;/body&gt;
&lt;/html&gt;
&lt;%
Recordset1.Close()
%&gt;
Thats just the record set for the results page.