[cfaussie] Re: Dealing with a random number of images

Wed, 22 Mar 2006 14:34:03 -0800

This is a situation where the group property of cfoutput comes in very handy:
<cfoutput query="qImages" group="prop">
<!--- Do stuff with a property --->
<cfoutput>
<!--- Do stuff with each instance of the property, eg process an image field --->
</cfoutput
</cfoutput>

Cheers
Blair

On 3/22/06, Brett Payne-Rhodes <[EMAIL PROTECTED]> wrote:

In fact this should work too...

select *
from re_property prop, re_agent agent
left outer join re_image image on image.imageid = (select max(imageId) from re_image where re_image.propid = prop.propid)
where agent.propID = prop.propID

B)


Brett Payne-Rhodes wrote:
> Hi Seona,
>
> A workaround that should work...
>
> select *
>   from re_property prop, re_agent agent
>   left outer join re_image image
>     on image.propid = prop.propid
>    and image.imageid = (select max(imageId) from re_image where re_image.propid = prop.propid)
>  where agent.propID = prop.propID
>
> Assuming 'imageId' is the key for your re_image table.
>
> This will get you the latest(?) image added for a property. min(imageId) would get you the first(?) image added for a property. You might need a flag on the image to indicate which one is the 'main' image perhaps...
>
> Cheers,
>
> Brett
> B)
>
>
> Seona Bellamy wrote:
>
>>Brett and Scott,
>>
>>Thanks for that, I think I'm slowly starting to understand the join thing.
>>
>>Sadly, however, I've found a small problem with the way we're doing
>>this. Have a look at http://www.renovate.com.au/realestate/ to see what
>>this is yielding me - when there's multiple images attached to a
>>property, that property appears multiple times in the list.
>>
>>Now, I went and did a bit of reading and as far as I can tell that is
>>exactly what's supposed to happen. It's not quite what I'd wanted to
>>have happen, though.
>>
>>Is this a case where I simply have to abandon keeping the images in a
>>seperate table and make them part of the re_property table? I'd always
>>thought that was a clumsy way of doing it, but I'm willing to if it's
>>the only way to achieve the results I want.
>>
>>Cheers,
>>
>>Seona.
>>
>>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "cfaussie" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~----------~----~----~----~------~----~------~--~---

Reply via email to