^ pop-out codeShare ^
  1. <cfsilent>
  2.     <cfquery name="getPhotos" datasource="#application.dsn#">
  3.     SELECT         TOP 4 p.Photo_ID,
  4.                 p.PicName,
  5.                 a.FolderName
  6.     FROM        RM_Photo p INNER JOIN
  7.                 RM_PhotoAlbum a ON p.Album_ID = a.Album_ID
  8.     WHERE        p.VertHort = 'H' AND
  9.                 a.PostDate > '1/1/2006'
  10.     ORDER BY     NewID()
  11.     </cfquery>
  12.     
  13.     <cfscript>
  14.         variables.pic1 = getPhotos.FolderName[1] & '/thumbs/' & getPhotos.picName[1];
  15.         variables.link1 = getPhotos.FolderName[1] & '/' & getPhotos.picName[1];
  16.         
  17.         variables.pic2 = getPhotos.FolderName[2] & '/thumbs/' & getPhotos.picName[2];
  18.         variables.link2 = getPhotos.FolderName[2] & '/' & getPhotos.picName[2];
  19.         
  20.         variables.pic3 = getPhotos.FolderName[3] & '/thumbs/' & getPhotos.picName[3];
  21.         variables.link3 = getPhotos.FolderName[3] & '/' & getPhotos.picName[3];
  22.         
  23.         variables.pic4 = getPhotos.FolderName[4] & '/thumbs/' & getPhotos.picName[4];
  24.         variables.link4 = getPhotos.FolderName[4] & '/' & getPhotos.picName[4];
  25.     </cfscript>    
  26. </cfsilent>
  27. <style type="text/css">
  28.     p     {
  29.         font: 12px arial;
  30.         }
  31. </style>
  32. <cfoutput>
  33.     <p>Hello and welcome to Ryan and Michelle's photo gadget. Enjoy!</p>
  34.     <div align="center">
  35.         <div align="center" style="width:45%; float:left; vertical-align:top;">
  36.             <a href="http://www.ryanandmichelle.com/photos/#variables.link1#" target="_blank"><img src="http://www.ryanandmichelle.com/photos/#variables.pic1#" style="border:3px solid ##000000;"></a>
  37.             <p></p>
  38.             <a href="http://www.ryanandmichelle.com/photos/#variables.link2#" target="_blank"><img src="http://www.ryanandmichelle.com/photos/#variables.pic2#" style="border:3px solid ##000000;"></a>
  39.             
  40.         </div>
  41.         <div align="center" style="width:45%; float:right; vertical-align:top;">
  42.             <a href="http://www.ryanandmichelle.com/photos/#variables.link3#" target="_blank"><img src="http://www.ryanandmichelle.com/photos/#variables.pic3#" style="border:3px solid ##000000;"></a>
  43.             <p></p>
  44.             <a href="http://www.ryanandmichelle.com/photos/#variables.link4#" target="_blank"><img src="http://www.ryanandmichelle.com/photos/#variables.pic4#" style="border:3px solid ##000000;"></a>
  45.         </div>
  46.     </div>
  47.     <p><a href="http://www.ryanandmichelle.com/photos/photo_feed.cfm">refresh photos</a></p>
  48. </cfoutput>