It sounds like it may just be something strange w/the OpenBase ODBC
driver--especially since it's working w/other dbs.
Out of curiosity, does this work?
<cfoutput query="getPhone.Company">
<tr>
<td>#company#</td>
<td>#mainPhone#</td>
</tr>
</cfoutput>
-Dan
> -----Original Message-----
> From: Dick Applebaum [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 24, 2002 7:54 PM
> To: CF-Talk
> Subject: CFMX strange syntax required to output a query [crosspost]
>
> 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
