I am finally getting around to playing with CFMX and various DBs --
something I should have done during the beta.
The example problems furnished with CFMX Linux and PointBase db all run
as expected, as did MySQL and PostgreSQL.
Actually it is running on the Mac OS X port of CFMX Linux
Today I installed OpenBase & tried to run a simple program. It failed.
By experimentation, I found that the results were being returned as a
recordset structure rather than as a query.
This means that you require a different syntax to refer to the query
fields in a
<cfoutput query="queryName">
tag
Instead of #ColumnName# you must use #queryName.TableName.ColumnName#
So the simple query
<cfquery name="getPhone" datasource="Company">
SELECT Company, mainPhone
FROM Company
ORDER BY Company
</cfquery>
<table border="1" cellspacing="0" cellpadding="3">
requires the following output notation
<cfoutput query="getPhone">
<tr>
<td>#getPhone.Company.company#</td>
<td>#getPhone.Company.mainPhone#</td>
</tr>
</cfoutput>
</table>
instead of the simpler (preferred)
<cfoutput query="getPhone">
<tr>
<td>#company#</td>
<td>#mainPhone#</td>
</tr>
</cfoutput>
</table>
the "getPhone.Company." qualification appears redundant, but the
template won't run without it
What's going on here and where is it documented?
TIA Dick
______________________________________________________________________
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
