Query Issue...

Question

Hey all, I am having an issue here and i was hoping that somone could help.

I am trying to retrieve an outputted list of all results that don't equal eachother.

ie, I have two databases and i want to view what images are in one database that are not in the other database. Is there a way to do this?

This is what i am doing now:

<cfquery name="imagelist1" datasource="database1">
SELECT filename, imagename
FROM iod_product_images
</cfquery>

<cfquery name="imagelist2" datasource="database2">
SELECT filename, imagename
FROM iod_product_images
</cfquery>

<cfquery dbtype="query" name="final">
SELECT filename FROM imagelist1
WHERE imagelist1.filename = imagelist2.filename
</cfquery>

<cfoutput query="final">
<cfset count = '#count + 1#'>
</cfoutput>

<cfoutput>
#count#
</cfoutput>

Dan_Bracuk · Accepted Answer

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.

query1
select somefield
from sometable etc

query2.
select whatever
from wherever
where somefield not in (the list from the first query)

palkema · Answer

Hey Guys,I apologize for my poorly written question, I had aconference that i was supposed to attend and i was in the middle ofwriting the previous post when i realized that i was going to belate. Sorry i did not explain myself well. :)Anyway Dan Bracuk didn't actually solve the issue that i washaving but he made me realize that what I was in error was in mysql statement. I had been pulling pulling, "* WHEREimagelist1.filename <> imagelist2.filename"When i should have been using the NOT EXISTS sql functioninstead of the <>.Thanks guys you rock!

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.