Hi Roger,
I suggest you turn field_b into a comma delimited list using valuelist. Then
cfloop through each record of field_a using a listfind to check for it's
presence in the list you created from field_b.
Just use a flag to indicate a failed check.
|Wanna ask for help here. Let's say that I have 2 queries which have a
|similar field column name. I wish to do a comparision and it's a AND
|critieria.
|For example,
|Field_a Field_b
|1 1
|2 2
|3 4
5
|I wish to compare field_a with field_b and everything that's in field_a has
|to be found in field_b, else it'll fail. How do I go about doing that ?
Regards,
Anthony Geoghegan.
Lead Developer,
IFTN
http://www.wow.ie
mailto:[EMAIL PROTECTED]
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
