What if there is no picture, how to not show broken window? 1

[kpierson]

I am doing a realestate site. The pictures are not listed in the MLS database. I am pulling up the pictures using:

<IMG HEIGHT=100 WIDTH=100 SRC=&quot;/mlspictures/VICTORIA#MLS#.jpg&quot;>

Where #MLS# is the Multiple Listing number. This works well until I run across a listing with no picture. I want to put a generic picture in place of where the picture goes. I have tried various ways using this:

<CFIF &quot;VICTORIA#MLS#.jpg&quot; IS &quot;&quot;>
<IMG HEIGHT=100 WIDTH=100 SRC=&quot;/mlspictures/nopictures.gif&quot;>

This doesn't work, before or after.
Any ideas how I can get my nopicture.gif to display if there is no picture?

 

[ecobb]

Try taking the &quot;VICTORIA&quot; and &quot;.jpg&quot; out of your IF statement. The way it reads right now, VICTORIA#MLS#.jpg will never be &quot;&quot; because &quot;VICTORIA&quot; and &quot;.jpg&quot; have been hard coded and they already exist. Try:

<CFIF #MLS# IS &quot;&quot;>
<IMG HEIGHT=100 WIDTH=100 SRC=&quot;/mlspictures/nopictures.gif&quot;>
<cfelse>
<IMG HEIGHT=100 WIDTH=100 SRC=&quot;/mlspictures/VICTORIA#MLS#.jpg&quot;>
</cfif>



Hope This Helps!

Ecobb
- I hate computers!

 

[philhege]

The problem is that the listing exists, but the picture doesn't. You'll always have MLS numbers; you just won't always have pictures.

I don't see a clean way of doing this outside of using a CFDIRECTORY to get all of the image file names, and then doing a LISTFIND() on the file name column for that particular file.

(In your output loop)
<cfset thispic = &quot;VICTORIA&quot;&trim(MLS)&&quot;.jpg&quot;>
<cfif listfind(valuelist(mydirectoryquery.file),thispic) GT 0>
<IMG HEIGHT=100 WIDTH=100 SRC=&quot;/mlspictures/VICTORIA#MLS#.jpg&quot;>
<cfelse>
<IMG HEIGHT=100 WIDTH=100 SRC=&quot;/mlspictures/nopictures.gif&quot;>
</cfif>


HTH,

Phil Hegedusich
Senior Web Developer
IIMAK

http://www.iimak.com

-----------
Boy howdy, my Liberal Studies degree really prepared me for this....

 

[BigElf4493]

Why not use FileExists?

 

[CFMSACCESS]

Here's more about FileExists:

http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/functi79.htm

http://www.GracefulWebDevelopment.com

 

[sgdragon78]

Hi All,
First time posting here.
Is it possible to use solve by this method:
============== in application.cfm =======================
<cfset thisPath = ExpandPath(&quot;*.*&quot>
<cfset thisDirectory = GetDirectoryFromPath(thisPath)>
=========================================================


=========================================
<Cfif FileExists(&quot;#thisDirectory#mlspictures/VICTORIA#MLS#.jpg&quot>
<IMG HEIGHT=100 WIDTH=100 SRC=&quot;/mlspictures/VICTORIA#MLS#.jpg&quot;>
<cfelse>
&nbps;
</cfif>

 

[mcsolas]

<cfset thisPath = ExpandPath(&quot;*.*&quot>
<cfset thisDirectory = GetDirectoryFromPath(thisPath)>

shorter
\/\/\/\/

<cfset thisDirectory = GetTemplatePath()>

Pura Vida - &quot;The Pure Life&quot; - Visit Costa Rica

http://www.rovercam.com

 

[csteinhilber]

Uhh... no mcsolas...

GetTemplatePath()

returns the entire path including the filename.

You would still need to use the

GetDirectoryFromPath()

method to get just the directory. So it's no shorter than the

ExpandPath()

solution. They're pretty interchangable.


-Carl

 

[mcsolas]

OH yeah sorry. I forgot I pulled that from the form, not my cffile code. I have been using that to make a standard generic email me form that I copy from site to site.

Mike

Pura Vida - &quot;The Pure Life&quot; - Visit Costa Rica

http://www.rovercam.com

 

[rockyroad]

Hi,

Please tell me if I have missed this, but how
(form, URL) is the #MLS# being passed into this template?

RR