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

[Guest]

What does profileImage.PRINCIPAL_ID contain if there is no image available? Null?

If so:
<CFIF profileImage.PRINCIPAL_ID IS "">
<IMG SRC="images/default.gif" WIDTH="100" HEIGHT="125">
<CFELSE>
<img src="images/#profileImage.PRINCIPAL_ID#.png" width="100" height="125">
</CFIF>

[Lemur99]

No all employess have a principal_id but some dont have a photo.

[Guest]

So profileImage.RecordCount is always 1, correct?

[monkey_woo_too]

use a rewrite rule on your http server to check that image files exist and if they don't redirect to a blank image...

#i love apache so much
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule ^images/(.*)?\.png images/default.png [NC,L,T=image/png]