thanks Rich
so this is the code
<cfquery name="foto" datasource="webphotos">
SELECT * FROM photos
</cfquery>
<!---declare fotonum variable relative to date converted to integer and use mod
to turn that daily number into a recurring cycle --->
<cfset fotoNum = (int(now()) mod foto.recordCount) + 1>
<cfoutput>
<img src="images/#foto.name[fotoNum]#'.jpg'" width="640" height="180"
border="0">
</cfoutput>
BELOW IS THE RESULT OF THE CFDUMP
DESCRIPTION NAME PHOTOID
1 picture 1 foto1 1
2 picture 2 foto2 2
3 picture 3 foto3 3
4 picture 4 foto4 4
it doesn't give an error but it doesn't show the picture
thanks again
>Alex
>
>I am not sure that you need that extra' in the middle of here [fotoNum]#'.jpg
>
>Have you tried dumping the contents of foto to make sure you have the
>data that you need and are you also sure that fotoNum has a numerical
>value that you require?
>
>It may be helpful for these emails if you post the error message or
>part of it to give people more of a clue as to what is happening.
>
>Also, there is no '<' on your opening cfoutput but that may well be an
>email and typo or missed of a 'copy and paste'.
>
>
>
>On 1/16/07, alex poyaoan <[EMAIL PROTECTED]> wrote:
>>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266671
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
