This content has been marked as final. Show 5 replies
So are these two different datasources and not two tables in the same source?
If so, you have to query your second datasource to get the strHRimage values, then query your first datasource to find the appropriate matching records and get the strimage value. Do the records match with some sort of key, or just the strHRimage values?
Yes, the key is "key"...sorry for the pun.
The best way (that I know of) is to create 2 arrays--assuming that the keys are numeric--and comparing the 2 arrays. That way, it's only 2 SELECT queries to the DB and then CF processes comparision.
arrayfirst = John
arrayfirst = Mary
arrayfirst = Larry
...where 1,2,3 are keys from 1st query
arraysecond = Ken
arraysecond = Mary
arraysecond = Larry
...where 1,2,3 are keys from 2nd query
Yes they are two separate datasources/databases, and they have no "key"connection other than the values for string "strHRimage" being the same in both.
The second database is a feedback grabber from people downloading images from our site (I capture the highres image name).
I want to display 5+ lowres images (strImage) from the 1st database where the highres (strHRimage) image names match in each database.
Hope this helps.
google "coldfusion query of queries"
Many thanks for your replies, I decided to manually enter in the lowres names by hand and update the code to capture the lowres image names for future use.