I have a select box that shows teachers and the grade they teach (some teach several grades). This selection is sent to a stored procedure. I want my select box to pull up the teacher with the students by grade so I set it up like this
<SELECT NAME="TchGrade" SIZE="9" TABINDEX size="1" style="width:190px" Multiple> <OPTION SELECTED VALUE=""> <CFOUTPUT QUERY="TchrByGrade"> <OPTION VALUE="#TchrID##GradeTaught#">#TCHRNAME# #GradeTaught# </CFOUTPUT> </SELECT> Simple eeeh Now this would work great IF TchrID and GradeTaught were both varchar fields, but TchrID is an integer and GradeTaught is a varchar. So of course I am getting errors about the datatype being wrong and or an error trying to convert it. So I then moved the option value into my query ((TchrID + GradeTaught) AS TcherGradeTaught) And used that <OPTION VALUE="#TcherGradeTaught#">#TCHRNAME# #GradeTaught# Although this is a good thing to do it of course doesn't fix my problem. Any way around this? Thanks, J ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
