I am replying to my own original post so I can add a few comments.
1. The OpenBase people are looking into unusual results.
2. CFMX docs for cfquery include the following, but a search on "dot
notation" did not yield anything enlightening.
New in ColdFusion MX: ColdFusion supports dot notation within a
record set name.
ColdFusion interprets such a name as a structure. For more
information, see Developing
ColdFusion MX Applications with CFML.
3. In a way, returning the "tableName.columnName" format is a good
thing -- it solves one of the two major gripes
I have always had with cfquery.
1. solved (at least for OpenBase dbs) queryName.ColumnList gives
the fully-qualified name of each column --
eliminating the problem when columns in different tables
have the same name
2. still unsolved is the fact that the entries in
queryName.ColumnList are not returned in the same order as the columns
exist
in the db -- a problem if you are writing a general-purpose
utility to browse a db, using SELECT * FROM tableName ---
it would be natural to see the columns in the order they were
defined.
Note: you get both of these with cfobject, why not with cfquery?
Dick
On Wednesday, July 24, 2002, at 04:54 PM, Dick Applebaum wrote:
> 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
