This content has been marked as final. Show 3 replies
If you don't mind me asking, what is the issue you are having? Are you getting errors?
Anyway, I did notice in your count that it is not already set to 0. Personally I do the same thing, but like this:
<cfset count = 0>
<cfset count = count+1>
If there is some other problem, can you be a bit more specific, and I'm sure someone can help out.
In some types of dbs, you can select from more than one db if you are properly set up. If not, you can do something like this.
from sometable etc
where somefield not in (the list from the first query)
I apologize for my poorly written question, I had a conference that i was supposed to attend and i was in the middle of writing the previous post when i realized that i was going to be late.
Sorry i did not explain myself well. :)
Anyway Dan Bracuk didn't actually solve the issue that i was having but he made me realize that what I was in error was in my sql statement. I had been pulling pulling, "* WHERE imagelist1.filename <> imagelist2.filename"
When i should have been using the NOT EXISTS sql function instead of the <>.
Thanks guys you rock!