Oh yeah, and that's a query and output, not an array. But that's looks like what you are asking for.
Robert -----Original Message----- From: Robert Harrison [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 15, 2006 7:17 PM To: CF-Talk Subject: RE: CF array help Do: <cfquery name="myquery" datasource="mydatasource"> SELECT * FROM mytable </cfquery> That will get your data, now: <cfoutput query="myquery"> #PRJ_PointID# #PRJ_MainID# #Fund_Name#<br> </cfoutput> That will output the data. Format the outtput statement into a table is you want. Robert -----Original Message----- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 15, 2006 7:10 PM To: CF-Talk Subject: Re: CF array help http://tutorial150.easycfm.com/ On 11/15/06, J Robinson <[EMAIL PROTECTED]> wrote: > We are using cf with access as a database for an application here at work. I've only been using cf for about 2 weeks now so I'm a little green. I have an access table that stores project funding information in it that I need to manipulate. > > here is a snippet from the table: > > PRJ_PointID PRJ_MainID Fund_Name > 87 197 B2B > 88 198 B2b > 88 198 Bond 2004 > 88 198 B2B > 89 199 CDBG > > And this is what I'm trying to get: > > PRJ_PointID PRJ_MainID Fund_Name > 87 197 B2B > 88 198 B2B, Bond 2004 > 89 199 CDBG, B2B > > I'm developing a report with this data and would like to have the Fund_Name field to show all the different Fund_Names so on the report I can display 1 record for each project. > > Be easy on me I'm a newb! > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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-Talk/message.cfm/messageid:260608 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
