Try this
<fotoName= "foto.name#fotoNum#.jpg" />
<cfoutput>
<img src="images/#fotoName#'" width="640" height="180" border="0" />
</cfoutput>
The square brackets [] are for referencing struct keys
On 1/16/07, alex poyaoan <[EMAIL PROTECTED]> wrote:
>
> 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:266672
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
