4 Replies Latest reply on Nov 8, 2006 9:39 AM by monkey_woo_too

    Replacing Unfounf Images

    Lemur99
      Hi,

      On my training site when i click an individules name to see there progress it takes me to my profiles.cfm. On this page there is a photo of the individule along with there details.
      Not all induvidules have a photo uploaded, how can i get it to use a defult images if there is not a photo uploaded?

      Please find my current coding below :-

      <cfparam name="start" default="">

      <cfquery name="profileImage" datasource="breeze" username="stamp-ro" password="coldfusion256">
      SELECT DISTINCT dbo.PPS_TRANSCRIPTS.PRINCIPAL_ID
      FROM (dbo.PPS_SCOS JOIN dbo.PPS_TRANSCRIPTS ON dbo.PPS_SCOS.SCO_ID = dbo.PPS_TRANSCRIPTS.SCO_ID)
      JOIN dbo.PPS_PRINCIPALS ON dbo.PPS_TRANSCRIPTS.PRINCIPAL_ID = dbo.PPS_PRINCIPALS.PRINCIPAL_ID
      WHERE dbo.PPS_PRINCIPALS.NAME LIKE '#start#'
      </cfquery>

      <cfoutput query="profileimage"> <img src="images/#profileImage.PRINCIPAL_ID#.png" width="100" height="125"> </cfoutput>


      Thanks

      Lee Duncan