Just to close this thread -- the OpenBase people modified their jdbc
driver to return just columnName (instead of tableName.columnName) in
resopnse to a ResultSetMetaData.getColumnLabel() Java method invocation).
So, Now OpenBase is a viable db option for CFMX on Windows, Linux,
Solaris, Windows 2000 and Mac OS X.
I was impressed with the quick response to the problem,
professionalism & quick turnaround with a fix.
Dick
On Friday, July 26, 2002, at 09:28 AM, Dick Applebaum wrote:
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
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.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
