This is in the Fusebox newbie category. My main page contains two forms, each with a
distinct name
and purpose. Only the second form, which is supposed to search a database, does not
work. It fails
silently. I can see in the debug that the form variables were passed. One important
clue is that
"fuseaction" and its value are not appearing in the URL (SearchCriteria does appear).
This is
probably one of those embarrassingly obvious errors, but I'll take the risk to solve
it. Here are
several relevant snippets ...
---FIRST TEMPLATE---
<FORM NAME="srchhwdb" ACTION="index.cfm?fuseaction=SearchRecs"
ENCTYPE="multipart/form-data"
METHOD="post">
Search: <INPUT type="text" size="15" name="SearchCriteria" VALUE="under
revision">
<INPUT type="submit" value="Go">
</FORM>
--FROM INDEX.CFM PG---
<cfswitch expression="#fuseaction#">
<CFCASE value="SearchRecs">
<CFINCLUDE template="qry_searchresults.cfm">
</CFCASE>
---FROM QRY_SEARCHRESULTS---
<CFQUERY name="SearchEvents" datasource="#Application.DataSourceName#" dbtype="ODBC">
SELECT *
FROM EventsCalendar
WHERE EventName LIKE '%#srchhwdb.SearchCriteria#%'
</CFQUERY>
(at one time I also used LIKE '%#Form.SearchCriteria#%')
Keith Purtell, Web/Network Administrator
VantageMed Operations (Kansas City)
CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole
use of the
intended recipient(s) and may contain confidential and privileged information. Any
unauthorized
review, use, disclosure or distribution is prohibited. If you are not the intended
recipient, please
contact the sender by reply email and destroy all copies of the original message.
=========================================================
Kansas City ColdFusion User Group's website & listserv is
hosted through the generous support of Clickdoug.com
To send email to the list, email [EMAIL PROTECTED]
To (un)subscribe, email [EMAIL PROTECTED] with your request.
For hosting solutions http://www.clickdoug.com
Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1.
======================================================
