[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 276
  • Last Modified:

Images display

Hi Experts, I need an Idea on the way i am displaying Images.

On one of my Page,  am showing 6 Images even though Uploaded are 100, The Last Updated are shown.

Now,  have added one Column as HeaderImage and I have sets its value to 1. Now what i want is,

If has to detect the 6 Images which has been recently Updated and it will from thoses6 Images which is the headerImage, Now i want to Place that Header Image on the Main Screen and the First Image to be Shown and other Images displayed after wards

Please provide your suggestions what ways i can try out.

I tried using couple of cffif statements but all in vain. so any suggestions

Thanks
0
Gurpreet Singh Randhawa
Asked:
Gurpreet Singh Randhawa
  • 2
  • 2
1 Solution
 
stu215Commented:
Do you store info about the uploads in a database? What database fields do you have if so?

or are you just getting info from the files in a directory?

- If stored in a database you can keep whatever info about each upload you need and should be able to easily tell what the last 6 are if you keep the dateTime of when they are uploaded...


Would be something like:

<!--- Assuming there is only ever one headerImage or that you want the most recent one --->
<cfquery name="getHeaderImage" datasource="DS_Name" maxRows="1">
    SELECT dateTimeField, headerImageField, etc ...
    FROM yourTable
    WHERE headerImageField='1'
    ORDER byDateTimeField DESC
</cfquery>

<cfquery name="QName" datasource="DS_Name" maxRows="6">
    SELECT dateTimeField, headerImageField, etc...
    FROM yourTable
    ORDER BY dateTimeField DESC
</cfquery>

<!--- Print getHeaderImage where you want it then loop over the rest by either using maxrows 6 or set 2 different loops with the maxcount at 6 and total rec count --->

<cfloop from="1" to="#QName.recordcount#" index="i">
...
</cfloop>
0
 
Gurpreet Singh RandhawaWeb DeveloperAuthor Commented:
values are coming from DB, but the way you explained, i did not get properly, please explain again.
0
 
stu215Commented:
Have one query to pull up the Header Image to specifically get the values needed with that record.

A seperate query to pull up the rest of the images.

-- If you do not need all 100 images to display you could use maxrows="6" in the query to limit results

-- If you are displaying the first 6 most recent in a special way and the remainder are to be kept in an array but not displayed then you would not limit it in the query but do so inside a loop using an If statement

I may be misinterpreting what you want but was assuming you are doing something like:
------------------------------------------------
|                                                        |
|                                                        |
|                   Header Image            |
|                                                        |
|                                                        |
------------------------------------------------
|____|____|_____|_____|____|___|   <--- smaller 6 most recent images with slider for 7-100

Header Image = <img src="#getHeaderImage.Path# name="headerimage" .../>


Smaller images=
<cfloop from="1" to="#QName.recordcount#" index="i">
    <cfif #i# LT 7>
        <img src="#getHeaderImage.Path# name="headerimage" .../>
    <cfelse>
        ... store image paths in a JS array ?
    </cfif>
</cfloop>

----------------------  This is mostly pseudocode / a thought on how to do ---------------

Do you have a page  you could link / code that is not working that may give a better idea of what you are trying to do that is not working?
0
 
Gurpreet Singh RandhawaWeb DeveloperAuthor Commented:
yes that's one
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now