I'm hoping someone here will be able to help me out with a little query that
I've not been able to get working (and I've asked on two other CF forums).
What I would like to achieve is to do a recordcount of the photo's that are
contained within each album. The current Access DB contains the following two
album_id | album_title | album_description
photo_id | photo_album | ...
What exactly does the query need to be? This is what I've tried so far, but
it's not quite working:
<cfquery name="q_get_albums_item" datasource="#application.dsn#">
SELECT tbl_albums.album_id, tbl_albums.album_title, ...