select any data from category

[quiero mas]

Hi everyone - in the following code i want to allow the user t choose 'any'.

Example
choose the area - central
language - any
department - Bronchoesopagology


I dont want the user to have the option for area but it would be useful for
the other categories.

<cfquery name="urlpass" datasource="dependent">
SELECT hospital_name, hospital_id, EnglishAddress, JapaneseAddress,
NihongoName
FROM tHHbyL
WHERE group_id = '#form.area#'
<!--- eg. English = '-1' --->
AND #form.Language# = -1
AND #form.Department# = -1
</cfquery>

by the way this is a triple drop down menu where the menus are not populated
depending on the previous choice.

Regards Mark

[MikerRoo]

The values are all numeric, set by selects?

If so, then your "any" choices should set values of "" or " " or "any".
(Don't use a magic number!)


Then the query becomes:

WHERE group_id = '#form.area#'
<!--- Either select a specific language or ALL languages. --->
<CFIF IsNumeric (form.Language)>
AND language_id = <CFQUERYPARAM cfsqltype="cf_sql_integer"
value=#form.Language#>
</CFIF>

<!--- Either select a specific department or ALL departments. --->
<CFIF IsNumeric (form.Department)>
AND language_id = <CFQUERYPARAM cfsqltype="cf_sql_integer"
value=#form.Department#>
</CFIF>

[MikerRoo]

Oopsie!

The second condition should read:
AND department_id = <CFQUERYPARAM cfsqltype="cf_sql_integer" value=#form.Department#>