I've had some code that's been working fine until someone decided to start
adding dashes to some of the key field codes.
Here's the code on the action page:
<cfloop index="doc" list="#form.check#">
<cfquery name="addtorec" datasource="docs">
insert into tblemployee_train(employeeno,fullfileid,deptcode,dateadded)
values(#evaluate('form.empid' & doc)#,'#evaluate('form.fullfileid'&
doc)#','#evaluate('form.deptcode'& doc)#',#Now()#)
</cfquery>
</cfloop>
Now when it hits the action page code above with a deptcode selected that
contains a dash, I get this error upon processing:
Error Occurred While Processing Request
Error Diagnostic Information An error occurred while evaluating the
expression: #evaluate('form.empid' & doc)# Error near line 17, column 9.
An error has occurred while processing the expression:
form.empid40063GI30003GIXXX-XX
Error near line 1, column 28. Error resolving parameter
FORM.EMPID40063GI30003GIXXX The specified form field cannot be found. This
problem is very likely due to the fact that you have misspelled the form
field name. The error occurred while processing an element with a general
identifier of (#evaluate('form.empid' & doc)#), occupying document position
...
All of the field names and values look fine when debugging is on, so it has
something to do with that evaluate command and how it parses it out.
Anyone had a similar problem? What can I do to fix it other than inform my
end users they can't use dashes? Thanks a bunch to anyone that can answer
this!! (CF 4.5 by the way).
Melanie
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
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
