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:260607
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
