I've not had the opportunity to get into Fusebox, but I think (and I could be wrong here) the problem is that you are mixing a post method with a get method. I would try one of two things:
1. Remove "?fuseaction=SearchRecs" from the action attribute of the "srchhwdb" form, and then add a hidden input for it in the form, like
<INPUT type="hidden" name="fuseaction" value="SearchRecs">
2. Leave the ACTION attribute as it is and change the METHOD attribute to "get"
Thanks, Ramsey
At 03:43 PM 4/2/2004, you wrote:
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. ======================================================
=========================================================
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. ======================================================
