No, Dan, that just gives an Invalid Tag Attribute error. I have emailed the OpenBase people -- they are in silicon valley, so no response yet.
Dick On Thursday, July 25, 2002, at 07:03 AM, Dan G. Switzer, II wrote: > 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 >> >> > ______________________________________________________________________ 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
