I am using PureASP Upload and Smart Image Processor to upload images, create thumbnails and write to a database. In the database I have an area for 3 photos, but the DB record does not have to use all three photos. If all three are populated, it looks fine like this:

new.obrechtriehlproperties.com/properties/detail.asp?propertyid=1

If not, I get broken image links like this:

new.obrechtriehlproperties.com/properties/detail.asp?propertyid=4

When I use the following code, the broken links don't show, but neither do the thumbnails that SHOULD show.
<% dim strPhoto3
strPhoto3 = (rsDetail.Fields.Item("photo3".Value) %>

<% if strphoto3 > "" then response.write "<a href=""#""><img src=""/properties/images/" & strphoto3 & "_small"" alt=""Photo 3"" border=""0"" onClick=""MM_openBrWindow('/properties/window3.asp','window3','scrollbars=yes,resizable=yes,width=510,height=420')""></a>"%>

Any ideas how I can have the best of both worlds?