Hi Guys,
I want to compare one row of a table against another row in that table
(the row has an ID and 20 or so date fields)
I retrieve the specific rows i want, then i want to do a date compare
so i set up a list of field names
<CFSET field_names="blah blah">
<!--- i then loop over the field names --->
<CFLOOP index="Field_names" list="#Field_names#" delimiters=",">
<!--- and do the comparison --->
<CFSET comparison = DateCompare(
#PID.Field_names#,#Critical_Path_Dates.Field_names#>
<CFOUTPUT>#Comparison#</CFOUTPUT>
</CFLOOP>
of course this won't work, the question is;
How can i use the list of field names with the query name?
Any help, is as always, appreciated.
Stew
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
