Hey Ramsey: Well, the first suggestion was partly right. But I still kept ending up with no sign the query had ever run. I got suspicious that the other form on the first page (and/or its associated javascript) was interfering. So I created a new temporary page with just an HTML shell and the form I'm trying to debug. Bingo it works. So I'm on the right track; it's not a CF problem.
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. > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Behalf Of Ramsey Abu-Absi > Sent: Friday, April 02, 2004 2:55 PM > To: [EMAIL PROTECTED] > Subject: Re: [KCFusion] Form failure within Fusebox > > > Hi Keith, > > 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#%') > > ========================================================= 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. ======================================================
