Forums
This topic is locked
constant error on macromedia example
Posted 04 Apr 2002 01:00:11
1
has voted
04 Apr 2002 01:00:11 steve roberts posted:
i am following a macromedia example from the web site and keep getting the following errorif (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 ?
Replies
Replied 04 Apr 2002 08:35:58
04 Apr 2002 08:35:58 Viktor Farcic replied:
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') <> "" 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
TalkZone Manager
<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') <> "" 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
TalkZone Manager