CFQUERY named "getColumns" statement here.
The following code works for CF generated "Required"
attribute validation:
<cfform action="" method="post">
<cfoutput query="getColumns">
<cfset reqYN = IIF(nul IS NOT
'YES',DE('yes'),DE('no'))>
#column_name#: <cfinput type="text"
name="#column_name#" required="#reqYN#"> <BR>
</cfoutput>
<P>
<input type="submit" name="send" value="Go">
</cfform>
The following more complex code won't:
<cfform action="" method="post">
<cfoutput query="getColumns">
<cfset reqYN = IIF(nul IS NOT
'YES',DE('yes'),DE('no'))>
-- the IIF function can be embedded into the <CFINPUT
element but I chose not
#column_name#:
<cfif ...>
<cfinput type="text" name="#column_name#"
required="#reqYN#">
other stuff like field Help or not here <BR>
<cfelse>
...
</cfif>
</cfoutput>
<P>
<input type="submit" name="send" value="Go">
</cfform>
Why?
Secondly, there are two types of validations,
1) field required or not, msg responds to that;
2) field data_type, msg responds to that.
But there's only one Message attribute.
What's a good systematic way to address it?
Thanks.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
