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 ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists