I need a hand with a little project I am working on. I am learning CF
as I go, but this is stumping me.
How do I compare the records of two different queries, find records
that have data that matches in one particular column, and use this
information to display an image in a table that shows the "main record set"
with an extra column to hold the image that signifies that there was a
Here is what I have tried so far:
<CFQUERY Name="query1" Datasource="masterdb">
Select col1,col2,col3 from table1
Where user_id = #session.userid#
<CFQUERY NAME="query2" ...