> 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?
This is probably some problem with your specific database (OpenBase) or its driver. This is not the case for most databases used within CF MX. I haven't seen that with any database, in fact. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
