I have a search form. When I chose an option in a certain select box and
then submit the form, I get this error:
HTTP Error 405
405 Method Not Allowed
The method specified in the Request Line is not allowed for the resource
identified by the request. Please ensure that you have the proper MIME type
set up for the resource you are requesting.
Please contact the server's administrator if this problem persists.
If I don't select anything in that particular list box, the search works
fine.
Here is the code for the select box:
<select name="contact_typeCriteria" size="1">
<option value="">(Choose One:)</option>
<option value="Staff">Staff</option>
<option value="Instructor">Instructor</option>
</select>
And here is the code on the action page that I think is causing the problem:
<cf_cbAppendCriteria FieldName="c.contact_type" FieldType="CHAR"
Operator="#contact_typeOperator#" Value="#contact_typeCriteria#">
And here is the code in the cf_cbAppendCriteria custom tag:
<cfif Trim(Attributes.value) NEQ "">
<CFSET Criteria = Attributes.fieldName>
<CFSET Value = Attributes.value>
<CFIF Attributes.FieldType is not 'DATETIME'>
<!--- escape quotes if field type is not datetime --->
<CFSET Value = Replace( Value, "'", "''", "ALL" )>
</CFIF>
<CFIF ListFindNoCase( 'CHAR,MEMO', Attributes.FieldType )>
<CFIF Attributes.operator is 'EQUAL'> <CFSET Criteria = Criteria & "
= '#Value#' ">
<CFELSEIF Attributes.operator is 'NOT_EQUAL'> <CFSET Criteria = Criteria
& " <> '#Value#' ">
<CFELSEIF Attributes.operator is 'GREATER_THAN'><CFSET Criteria = Criteria
& " > '#Value#' ">
<CFELSEIF Attributes.operator is 'LESS_THAN'><CFSET Criteria = Criteria &
" < '#Value#' ">
<CFELSEIF Attributes.operator is 'CONTAINS'> <CFSET Criteria =
Criteria & " LIKE '%#Value#%' ">
<CFELSEIF Attributes.operator is 'DOES_NOT_CONTAIN'> <CFSET
Criteria = Criteria & " LIKE '%#Value#%' ">
<CFELSEIF Attributes.operator is 'BEGINS_WITH'> <CFSET Criteria = Criteria
& " LIKE '#Value#%' ">
<CFELSEIF Attributes.operator is 'ENDS_WITH'> <CFSET Criteria = Criteria
& " LIKE '%#Value#' ">
</CFIF>
<CFELSEIF ListFindNoCase( 'DATETIME', Attributes.FieldType)>
<CFIF Attributes.operator is 'EQUAL'> <CFSET Criteria = Criteria & "
= #CreateODBCDateTime(Value)# ">
<CFELSEIF Attributes.operator is 'NOT_EQUAL'> <CFSET Criteria = Criteria
& " <> #CreateODBCDateTime(Value)# ">
<CFELSEIF Attributes.operator is 'GREATER_THAN'><CFSET Criteria = Criteria
& " > #CreateODBCDateTime(Value)# ">
<CFELSEIF Attributes.operator is 'LESS_THAN'><CFSET Criteria = Criteria &
" < #CreateODBCDateTime(Value)# ">
</cfif>
<CFELSEIF ListFindNoCase( 'INT,FLOAT,BIT', Attributes.FieldType )>
<CFIF Attributes.operator is 'EQUAL'> <CFSET Criteria = Criteria & "
= #Val(Value)# ">
<CFELSEIF Attributes.operator is 'NOT_EQUAL'> <CFSET Criteria = Criteria
& " <> #Val(Value)# ">
<CFELSEIF Attributes.operator is 'GREATER_THAN'><CFSET Criteria = Criteria
& " > #Val(Value)# ">
<CFELSEIF Attributes.operator is 'LESS_THAN'><CFSET Criteria = Criteria &
" < #Val(Value)# ">
</CFIF>
</CFIF>
<CFIF Trim( Caller.Criteria ) is "" OR Trim(Caller.Criteria) EQ "1 > 0">
<CFSET Caller.Criteria = Criteria>
<CFELSE>
<CFSET Caller.Criteria = Caller.Criteria & " AND " & Criteria>
</CFIF>
<cfelse>
<CFIF Trim( Caller.Criteria ) EQ "" OR Trim(Caller.Criteria) EQ "1 > 0">
<CFSET Caller.Criteria = "1 > 0">
</CFIF>
</cfif>
Anyone know what this error means and how to make it go away?
Todd Ashworth
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
