i am following a macromedia example from the web site and keep getting the following error

if (Request.form('search') <> "" then Recordset1__varjob = Request.form('search')

i have a textfield on a search page called search which i want the user to be able to enter data that searches a database called wwh which has a field called Jobtitle .

i have added the following sql
SELECT *
FROM wwh
WHERE JobTitle like 'varjob'

and used
varjob % Request.form1('search')
as my variable ..

any ideas ?

Quotes aren't right. Change it to: if (Request.form("search" <> "" then Recordset1__varjob = Request.form("search"

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
i am following a macromedia example from the web site and keep getting the following error

if (Request.form('search') &lt;&gt; "" then Recordset1__varjob = Request.form('search')

i have a textfield on a search page called search which i want the user to be able to enter data that searches a database called wwh which has a field called Jobtitle .

i have added the following sql
SELECT *
FROM wwh
WHERE JobTitle like 'varjob'

and used
varjob % Request.form1('search')
as my variable ..

any ideas ?


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

Viktor Farcic
viktor@udzone.com
TalkZone Manager