Using a Form to selct from DB

there are numerous ways a search form like that can be coded using cf
(or any other language for that matter). which part of creating a search
form are you having trouble with exactly?

just as general examples, here's some sample code:

1) hard-coded search form:
<!--- search form --->
<form ...>
<select name="gender">
<option value="0" selected="selected">Any</option>
<option value="Female">Female</option>
<option value="Male">Male</option>
</select>
...
</form>

<!--- results page --->
<cfparam name="form.gender" default="0">
<cfquery name="getSearchResults" datasourse="...">
SELECT somecolumns
FROM sometable
WHERE 1 = 1
<cfif form.gender neq 0>
AND gender = <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.gender#">
</cfif>


2) database-driven search form:
<!--- search form --->
<cfquery name="getGenders" datasource="...">
SELECT 0 AS gender_id, 'Any' AS gender, 1 AS sortcolumn
FROM genders
UNION
SELECT gender_id, gender, 2 AS sortcolumn
FROM genderstable
ORDER BY sortcolumn, gender
</cfquery>

<form ...>
<select name="gender">
<cfoutput query="getGenders">
<option value="#gender_id#" <cfif getGenders.currentrow eq
1>selected="selected"</cfif>>#gender#</option>
</select>

<!--- results page --->
<cfparam name="form.gender" default="0">
<cfquery name="getSearchResults" datasourse="...">
SELECT somecolumns
FROM sometable
WHERE 1 = 1
<cfif form.gender gt 0>
AND gender = <cfqueryparam cfsqltype="cf_sql_integer" value="#form.gender#">
</cfif>


the above examples are just 2 of multitude of possible ways to go about
it...

hth


Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/