now technically the 'best way' is to do it this way:
#iif(len(trim(imgField),de(imgField),de('/other/image/file.gif'))#
the reason for the len(trim(imgField)) is becasue often times, when a
character based field is created, it'll return that number of characters
even tho nothing is in it. i'm not sure if we decided that len was faster
or not tho :). trim gets rid of whitespace.
hope this helps.
-chris
At 10:08 AM 4/25/00 -0400, you wrote:
><cfif query.image gt ''>
>....output your image from the db here
><cfelse>
>....output a default blank image here
></cfif>
>
>> -----Original Message-----
>> From: John Stanley [mailto:[EMAIL PROTECTED]]
>> Sent: Tuesday, April 25, 2000 9:51 AM
>> To: [EMAIL PROTECTED]
>> Subject: What's the best way
>>
>>
>> I have an employee profile page that lists a bunch of
>> things about each employee. And it also has an image
>> of the said employee. Now my question to the list is
>> some employees do not have pictures on file. Is there
>> a way to check, while the page is loading to see if a
>> certain image file exists, and if it does to load it,
>> and if it does not, to load a default image or
>> something ? This would get rid of the broken image on
>> the page.
>>
>> Thanks in Advance!!!!
>>
>>
>>
>> __________________________________________________
>> Do You Yahoo!?
>> Send online invitations with Yahoo! Invites.
>> http://invites.yahoo.com
>> ------------------------------------------------------------------
>> ------------
>> Archives: http://www.eGroups.com/list/cf-talk
>> To Unsubscribe visit
>> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
>_talk or send a message to [EMAIL PROTECTED] with
>'unsubscribe' in the body.
>
>---------------------------------------------------------------------------
---
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
