Here is the action page. Very simple just loops the the query records.
<cfquery name="GetCompanies" datasource="#DSN#">
SELECT *
FROM tbl_Members
WHERE CategoryID=#FORM.CategoryID# AND DeActivate = 0 AND FirstName <>
'Administrator'
ORDER BY BusinessName
</cfquery>
-----Original Message-----
From: mark brinkworth [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 08, 2002 9:06 PM
To: CF-Talk
Subject: Re: 500 Internal Server Error
Nothing obvious here. It would be helpful if you could indicate, or give
some code, indicating what happens of the action page.
>I have a select list, a user chooses what category they want to view and
>click submit. The submit is a input type img.
>
>Most of the selects work as desired, but a few when selected and the form
>is
>submitted get a 500 internal server error.
>
>An example is below.
><form name="Category_Search" method="post"
>action="/categorysearch/index.cfm">
><select name="Category">
> <option value="1">Category 1</option>
> <option value="2">Category 2</option>
></select>
><input type="img" src="/assets/images/gobutton.gif">
></form>
>
>Category 1 will work correctly, but category 2 will show 500 internal
>server
>error.
>
>??
>
>P.S. This is not my actual code but setup basically the same without the
>variables, loop, tables, etc.
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
