ColdFusion Database Record Comparison -- How?
Posted on 2014-02-06
I am in a jam today as I have been hitting my head against the wall for a couple of days now.
I have an access database with two fields -- SCRUB NSCRUB
I need to take the values one at a time that are in NSCRUB and see if they exist in SCRUB, if they do, then just show to screen "Record Exist: "data in the record"
It is really that simple. I have written a cfquery and cfloop and the best I can get is for the code to run until it finds the record from NSCRUB in SCRUB, and that is it, it will never go onto the next record in NSCRUB and try to find it. It just stops at the first record and doesn't try to find any records past the first.
I can past code, but really it is all of 8 lines and not sure it would even help???
Thank you so much!!