I think I've been staring at this too long: This seems to return an  
empty list??
What am I doing wrong?


<cfset MyList = "">
<cfquery datasource="dsname" name="getallfiles">
SELECT photofilename, photoformat from tblPhoto;
</cfquery>

<cfloop query="getallfiles">

<cfset thisfile = "#photofilename#.#photoformat#">
<cfset ListAppend(MyList, "#thisfile#)>

</cfloop>

<cfdump var="#MyList#">


Ta

T

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2040
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15

Reply via email to