I have a page in which employees can update information that is contained in
their record in my SQL table. I recently added a multi-select list box with
a list of foreign languages that they can choose from if it's applicable to
them.
If a user selects a foreign language and submits their changes, it works.
If they change their address, but don't speak a foreign language and the
list box doesn't have anything selected, then they get this lovely error
message:
GetOld.FLanaguage IS ""
Error near line 126, column 24.
_____
Error resolving parameter GETOLD.FLANAGUAGE
The column FLANAGUAGE is not present in the query named GETOLD. It is likely
that you have misspelled the name of the column.
The error occurred while processing an element with a general identifier of
(CFIF), occupying document position (126:1) to (126:30).
Ok, so FLangauge is a field in the query, so it isn't that. Here's the piece
of the page where it's failing at:
<cfif GetOld.FLanaguage IS "">
<cfset chgFLanguage = "">
<cfelseif GetOld.FLanguage IS NOT '#FLanguage#'>
<cfset chgFLanguage = #FLanguage#>
</cfif>
Is the reason why I am having this problem have to do with the fact that
this is a multi-select list box and if so, how do I correct this to make
this work correctly?
For anyone who wants to see the code for the list box it is:
<tr>
<td><b>Foriegn Languages You May Speak:</b></td>
<td><cfselect name="FLanguage" size="5" multiple>
<CFOutput query="GetLanguages">
<CFIF
ListFindNoCase(EditNameQry.FLanguage,GetLanguages.LanguageName)>
<CFSET PGSelected ="Selected">
<CFELSE>
<CFSET PGSelected ="">
</cfif>
<Option #PGSelected#
value="#LanguageName#">#LanguageName#</option>
</cfoutput>
</cfselect></td>
</tr>
Thank you,
Aimee Clark
Web Developer
Stinson Morrison Hecker LLP
[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
