Webmaster Forum / ColdFusion / Advanced Techniques / September 2005

I've got an input form where i'm trying to sort dates in an output quiry.
The date out put should either list open, or closed, or all issue from the
database.
Here is the code from the input form. (dataSelection)
===========================
<form name="form1" method="post" action="output.cfm">
<p>&nbsp; </p>
<p> Select Region
<input type="radio" name="region" value="EMEA">
EMEA
<input type="radio" name="region" value="US">
US</p>
<p>Issue status
<input type="radio" name="date_closed" value="NULL">
Closed
<input type="radio" name="date_closed" value="NULL">
Open
<input type="radio" name="date_closed" value="">
ALL </p>
<p>
<input type="submit" name="Submit" value="Submit">
</p>

And here is the code of the quiry i'm having sofar. (output)
========================================
<cfparam name="FORM.region" default="1">
<cfparam name="FORM.date_closed" default="1">
<cfparam name="PageNum_laden" default="1">
<cfquery name="laden" datasource="issue">
SELECT * FROM tbl_issue WHERE region IS '#FORM.region#'
AND date_closed >...............< here i'm lost..
</cfquery>