Hi Will,
Thanks so much for your help:)
My first CFC `-`
I had to make some changes to get it working.
<!---Testing.cfc--->
<cffunction name="getResults" access="public" returntype="query">
<cfquery name="qEmails" datasource="my_datasource">
SELECT *
FROM testing
</cfquery>
<cfreturn qEmails>
</cffunction>
<!--- myTest.cfm--->
<cfinvoke component="Testing"
method="GetResults"
returnvariable="qEmails"/>
<table width="301" border="1">
<tr>
<td width="101"><strong>Name</strong></td>
<td width="184"><strong>Email</strong></td>
</tr>
<cfoutput query="qEmails">
<tr>
<td>#name#</td>
<td>#email_address#</td>
</tr>
</cfoutput>
</table>
This is exactly what I wanted, thank you so much for your help`-`
John
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4499
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
