Re: CFMX strange syntax required to output a query [crosspost]
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 tag Instead of #ColumnName# you must use #queryName.TableName.ColumnName# So the simple query SELECTCompany, mainPhone FROMCompany ORDER BY Company requires the following output notation #getPhone.Company.company# #getPhone.Company.mainPhone# instead of the simpler (preferred) #company# #mainPhone# 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMX strange syntax required to output a query [crosspost]
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 > > > > tag > > Instead of #ColumnName# you must use #queryName.TableName.ColumnName# > > So the simple query > > > > SELECTCompany, mainPhone > FROMCompany > ORDER BY Company > > > > > requires the following output notation > > > > #getPhone.Company.company# > #getPhone.Company.mainPhone# > > > > > > instead of the simpler (preferred) > > > > #company# > #mainPhone# > > > > > > 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMX strange syntax required to output a query [crosspost]
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? > > > > #company# > #mainPhone# > > > > -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 >> >> >> >> tag >> >> Instead of #ColumnName# you must use #queryName.TableName.ColumnName# >> >> So the simple query >> >> >> >>SELECTCompany, mainPhone >>FROMCompany >>ORDER BY Company >> >> >> >> >> requires the following output notation >> >> >> >> #getPhone.Company.company# >> #getPhone.Company.mainPhone# >> >> >> >> >> >> instead of the simpler (preferred) >> >> >> >> #company# >> #mainPhone# >> >> >> >> >> >> 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX strange syntax required to output a query [crosspost]
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? #company# #mainPhone# -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 > > > > tag > > Instead of #ColumnName# you must use #queryName.TableName.ColumnName# > > So the simple query > > > > SELECTCompany, mainPhone > FROMCompany > ORDER BY Company > > > > > requires the following output notation > > > > #getPhone.Company.company# > #getPhone.Company.mainPhone# > > > > > > instead of the simpler (preferred) > > > > #company# > #mainPhone# > > > > > > 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: 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 > > > > tag > > Instead of #ColumnName# you must use #queryName.TableName.ColumnName# > > So the simple query > > > SELECTCompany, mainPhone > FROMCompany > ORDER BY Company > > > > > requires the following output notation > > > > #getPhone.Company.company# > #getPhone.Company.mainPhone# > > > > > > instead of the simpler (preferred) > > > > #company# > #mainPhone# > > > > > > 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX strange syntax required to output a query [crosspost]
Hmm... I dont think CFMX translates queries into structures if you try #isStruct("queryName")# it comes back with "NO" sounds like there is something mysterious goin on you setup. Joe -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 7:43 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 tag Instead of #ColumnName# you must use #queryName.TableName.ColumnName# So the simple query SELECTCompany, mainPhone FROMCompany ORDER BY Company requires the following output notation #getPhone.Company.company# #getPhone.Company.mainPhone# instead of the simpler (preferred) #company# #mainPhone# 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMX strange syntax required to output a query [crosspost]
On 7/24/02, Dick Applebaum penned: >This means that you require a different syntax to refer to the query >fields in a > > > >tag > >Instead of #ColumnName# you must use #queryName.TableName.ColumnName# > >So the simple query Man, this can't be correct. That would mean 99% of all CF apps/pages would have to be modified. It's got to have something to do with the OSX port. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 __ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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 tag Instead of #ColumnName# you must use #queryName.TableName.ColumnName# So the simple query SELECTCompany, mainPhone FROMCompany ORDER BY Company requires the following output notation #getPhone.Company.company# #getPhone.Company.mainPhone# instead of the simpler (preferred) #company# #mainPhone# 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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 tag Instead of #ColumnName# you must use #queryName.TableName.ColumnName# So the simple query SELECTCompany, mainPhone FROMCompany ORDER BY Company requires the following output notation #getPhone.Company.company# #getPhone.Company.mainPhone# instead of the simpler (preferred) #company# #mainPhone# 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 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists