Coldfusion and Jquery prettyphoto.

Hi pimpsuit.
The question is if this is the right way to do what i'm doing or if there is a better way.

You could probably combine your queries into one, so that you get one list of images for the selected art_id in one hit on the database rather than one query for each image.

Hi Mr Nil.
Can you please show me what you mean?

The query below would get all the images for your getting information from the artikel table as well as the all_images table.

The cfoutput would group the images by art_id from the artikel table into individual galleries.

Looking at it again : You could probably do this with one query against the all_images table if you don't need anything from the artikel table.

<cfquery name="qImages" ...>
SELECT artikel.Herstellers_ID, artikel.art_ID, All_images.img_id, All_images.img_Text
FROM artikel
     LEFT JOIN All_images ON artikel.art_ID = All_images.Artimages_ID
WHERE art_Id IN (<cfqueryparam cfsqltype="cf_sql_varchar" value="393,389" list="yes">)
ORDER BY artikel.art_id, All_images.img_id
</cfquery>
 
<cfset galleryCount = 0 />
<cfoutput query="qImages" group="art_id">
   <cfset galleryCount = galleryCount +1 />
   <cfoutput>
   <a href="../images/bigsize/#qImages.img_Text#" rel="prettyPhoto[gallery#galleryCount#]" title="You can add caption to pictures."></a>
   </cfoutput>
</cfloop>

                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:

Hi again.
Looking at your code it seems there is missing the cfloop opening tag and cfoutput closing tag.
The next problem is that if i will use this code i will show all the images.

In my code the getimage query is getting the image with img_1= 1(Mainphoto) that i'm showing.
The All_images query is getting the data  of the rest of the images .By clicking on the mainphoto jquery is creating the lightbox.

I do need things from the artikel table like the Herstellers_ID but i think that would not be a problem to use the group function.

I hope you can contact with me in the next 7 hours!

I got it:
<cfset galleryCount = 0 />
<cfoutput query="qImages" group="art_id">
   <cfset galleryCount = galleryCount +1 />
     <cfoutput>
   <div class="gallery clearfix">
   <a href="../images/bigsize/#qImages.img_Text#" rel="prettyPhoto[gallery#galleryCount#]" title="You can add caption to pictures."></a>
   </div>
   </cfoutput>
</cfoutput>

The problem that remains is to show only the image with img_ID 1.

(I don't know if this could be done showing the main image in the <div class="gallery clearfix">,than clicking on the image pass the art_Id (ajax - bind function) to another page with the getAllimages query(i have above) and get the output in the div.It seems too complicated!)

It is close to the solution.
I must have all the links into the div class="gallery clearfix" to work:
<div class="gallery clearfix">
   <cfset galleryCount = galleryCount +1 />
     <cfoutput>
      <cfif qImages.img_id EQ 1>
     <!--- Output your link image for the gallery --->
      <a href="../images/bigsize/#qImages.img_Text#" rel="prettyPhoto[gallery#galleryCount#]" title="You can add caption to pictures.">  <img src="../images/thumbs/#qImages.img_Text#" width="60" height="60" alt="Red round shape" /></a>
        <!--- Now start the gallery ---->
   <a href="../images/bigsize/#qImages.img_Text#" rel="prettyPhoto[gallery#galleryCount#]" title="You can add caption to pictures."></a>
     <cfelse>
     <!--- Just add the image to the gallery --->
        <a href="../images/bigsize/#qImages.img_Text#" rel="prettyPhoto[gallery#galleryCount#]" title="You can add caption to pictures."></a>
     </cfif>
 
   </cfoutput>
   <!--- New art_id so close the gallery div for this art id --->
   </div>

The problem is that i have now for every record the image with img_id 1 twice in the lightbox.(remember the allimages query had  :....AND img_id NOT LIKE  <cfqueryparam cfsqltype="cf_sql_numeric" value="1">...)

It might be that you just need to take out the <a href> after the "now start the gallery" comment.

You are right
I did't notice that.
Thank you for your help!!!