Hi,
My last post made it sound like Simon's post was wrong or mine was better.
What I actually meant was that it would be good "In addition to" Simon's
suggestion, as the JS alone won't
necessarily correct the error.

Jim

-----Original Message-----
From: Milks, Jim [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 18, 2000 3:43 PM
To: CF-Talk
Subject: RE: ERROR


Even better...use JavaScript and save yourself a trip to the server.

Jim

-----Original Message-----
From: Simon Horwith [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 18, 2000 3:40 PM
To: CF-Talk
Subject: RE: ERROR


You should CFPARAM all form variables that have the potential to be passed
as empty strings, before your CFQUERY tag.

~Simon

> Simon Horwith
> Certified ColdFusion Instructor
> Certified ColdFusion Developer
> Fig Leaf Software
> 1400 16th St NW, # 220
> Washington DC 20036
> 202.797.6570 (direct line)
> www.figleaf.com
> 


-----Original Message-----
From: David Clay [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 18, 2000 3:30 PM
To: CF-Talk
Subject: ERROR


I am getting errors on this action of all the fields blank from this form:

I have seperated into form/action and error.  Any suggestions on how to
correct or write it a different way.

Thank you for your help and your time. 



........>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>....
FORM:

<FORM ACTION="ASAction.cfm" METHOD="POST">
<b>Call ID</b> <br>
                Enter the Call ID No. your looking for:<BR>
                <INPUT TYPE="TEXT" NAME="CallID">

<b> Customer ID</b><br> 
                Choose the customer name:<br>
                
                
                        <SELECT NAME="CustID">
                        <OPTION VALUE="All">Search All
                        <CFOUTPUT QUERY="getCustID">
                                <OPTION VALUE="#CustID#">#CustID#
                        </CFOUTPUT>
                </SELECT>


<b> Call Status</b><br> 
                Enter the call status:<br>
                
                
                        <SELECT NAME="CallStatus">
                        <OPTION VALUE="All">Search All
                        <CFOUTPUT QUERY="getCallStatus">
                                <OPTION VALUE="#CallStatus#">#CallStatus#
                        </CFOUTPUT>
                </SELECT>
                <br><br>

 <b>Software Program</b><br> 
                Choose the software:<br>
                                
                        <SELECT NAME="CallType">
                        <OPTION VALUE="All">Search All
                        <CFOUTPUT QUERY="getCallType">
                                <OPTION VALUE="#CallType#">#CallType#
                        </CFOUTPUT>
                </SELECT>

        <b>Report Type</b><br>
                Enter the report type:<br>
                
                
                        <SELECT NAME="ReportType">
                        <OPTION VALUE="All">Search All
                        <CFOUTPUT QUERY="getReportType">
                                <OPTION
VALUE="#Report_Type_TJ#">#Report_Type_TJ#
                        </CFOUTPUT>
                </SELECT>
                <br><br>
                
<b>Date Range</b> <br>
                Enter dates to view:<br>
                FROM:
                <input type="text" name="fromDate" size="10">
(enter:1998-10-24 (yyyy,mm,dd)) <br>
                
                TO:
                &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="text"
name="toDate" size="10"> (enter:1999-05-12 (yyyyy,mm,dd))
        </td>

        <b>Text Search</b><br>
<b>Search by Keywords:</b><br>
                &raquo; Enter 1 search keyword per line<br>
                &raquo; Press Enter for a new line.<br>

        <textarea cols="20" rows="5" name="searchtext"
wrap="hard"></textarea><br><br>
        
        <input type="submit" value="Get Results">
        <INPUT type=reset value="Reset">
</FORM>

........>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>....
ACTION PAGE:

<CFSET CRLF="#Chr(13)##Chr(10)#">
<CFIF #form.CallID# EQ "" AND #form.CustID# EQ "ALL" AND
#form.CallStatus# EQ "ALL" AND #form.CallType# EQ "ALL" AND
#form.ReportType# EQ "ALL" AND #form.fromDate# EQ "" AND #form.toDate# EQ ""
AND #form.searchtext# EQ ""><br><br>
<b>All search criteria can not be left blank, press the back button and pick
at least 1 search criteria.</b><br><br>
<CFABORT>
</CFIF>

..........>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>.......

ERROR:

#form.CallID# EQ "" AND #form.CustID# EQ "ALL" AND #form.CallStatus# EQ
"ALL" AND #form.CallType# EQ "ALL" AND #form.ReportType# EQ "ALL" AND
#form.fromDate# EQ "" AND #form.toDate# EQ "" AND #form.searchtext# EQ "" 

Error near line 54, column 138.
Error resolving parameter FORM.CALLID

The specified form field cannot be found. This problem is very likely due to
the fact that you have misspelled the form field name. The error occurred
while processing an element with a general identifier of (CFIF), occupying
document position (53:5) to (54:165) in the template file 

Dave Clay
Internet Facilitator
Trus Joist, A Weyerhaeuser Business
5995 Greenwood Plaza Blvd, Suite 100
Greenwood Village, CO 80111
303.770.8506
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to