quick table/SQl question - revisited

[quiero mas]

Getting this in the result page
CFLanguage_variable error

Search page
<cfquery name="SearchLanguage" datasource="simple">
SELECT Language_name
FROM tslanguage</cfquery>
<input type="submit" name="Submit" value="Submit">
<select name="select">
<cfoutput query="SearchLanguage">
<option value="#SearchLanguage.Language_name#" <cfif
(isDefined("SearchLanguage.Language_name") AND SearchLanguage.Language_name EQ
SearchLanguage.Language_name)>selected</cfif>>#SearchLanguage.Language_name#</op
tion>
</cfoutput> </select>
</form>

Result Page
<cfquery name="gethospital" datasource="simple">
select a.Hospital_Name, a.English, a.Russian
from tsHosptial a, tsLanguage b, tsLbyH c
where a.Hosptial_ID = c.Hospital_ID
and b.Language_ID=c.Language_ID
abd b.Language_Name=#cflanguage_variable#
</cfquery>

[Dan Bracuk]

Looks like you are trying to have every language selected in your cfselect.

[quiero mas]

Could it be something to do with my tables?
Language_ID Language_name
1 ???????
2 ???????

Hospital_ID Hospital_Name English Russian
1 ????? Yes Yes
2 ????? Yes No
3 ????? Yes Yes

Hospital_ID Language_ID
1 1
1 2
2 1
3 2
3 1

[Dan Bracuk]

No, it has something to do with the way you are deciding which option to have selected in your select control. It looks like every one will qualify.