Actually, it was with access 2000 and it was quite some time ago. But the strange behavior was in the query object after it was returned to coldfusion. It was because of this that I changed the way I named my fields. It is possible that it was something else. I will try and recreate it. If I remember correctly, it wasn't that the query did not work, it did. But the query object in ColdFusion had two "fields" with the same name when looking at the query results with cfdump. In the select the fields were named the same but from different tables...tableOne.fieldOne and tableTwo.fieldOne. If I remember right on the cfdump of the query, there were two "fields" named fieldOne. I was trying to do something with the results of the query and was having difficulty and decided after looking at the cfdump of the query object that the reason was the naming convention I was using.
The way Plum uses the CapitolLetterNamingConvention is quite useful and quite insightful of the authors. and I was just wondering whether that was indeed a problem or if I had just imagined it. I will try to find time to check it out sunday or monday. Thanks, Mark Fuqua -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Aaron Longnion - hotmail Sent: Saturday, February 19, 2005 4:54 PM To: [email protected] Subject: Re: [plum] Field Names Mark - Is this with SQL Server 2000 that you're having issues? Can you post the exact query in question, pointing out what your particular issue is that's making it not work.. as in: are the results wrong or did an error get returned? Thanks, Aaron ----- Original Message ----- From: "Mark Fuqua" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Friday, February 18, 2005 11:25 AM Subject: [plum] Field Names > > This may be silly but...I have had trouble in the past with queries where > the name of two fields in two different tables were the same. It did not > seem to matter whether or not I used table.fieldName or just fieldName. > So > I started putting the initials of the table name as a prefix to the field > name. tableOne.toFieldName tableTwo.ttFieldName. > > Did I imagine this problem? I want to redo a database with the naming > convetions spelled out in the plum tutorials...have you ever had any > problems with identically named fields in different tables? > > Thanks, > > Mark Fuqua > > > > ********************************************************************** > You can subscribe to and unsubscribe from lists, and you can change > your subscriptions between normal and digest modes here: > > http://www.productivityenhancement.com/support/DiscussionListsForm.cfm > ********************************************************************** > ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm ********************************************************************** ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm **********************************************************************
