You're welcome.. I never use brackets like that and wanted to rule all simple things out before asking you to "post your whole query". :)
On Fri, Oct 14, 2011 at 8:30 AM, Martin, Donna M <[email protected]> wrote: > > yes! Yes!! YES!!!! > It worked, Greg. I don't understand 'why' it works, but it did, and I'm > very grateful for your help. > Again, thank you! > Donna > > ________________________________________ > From: Greg Morphis [[email protected]] > Sent: Friday, October 14, 2011 8:40 AM > To: cf-newbie > Subject: Re: Error when adding a second join > > How about removing the parentheses? > R.Role, > MT.MemberType > FROM TblName T > LEFT JOIN Role R > ON T.Role_seq = R.Role_seq > LEFT JOIN MemberType MT > ON T.MemberType_seq = MT.MemberType_seq > WHERE > T.NameStatus_seq=<cfqueryparam value="1" cfsqltype="cf_sql_numeric"> > ORDER BY T.LName, T.FName > > > > > On Fri, Oct 14, 2011 at 7:33 AM, Martin, Donna M <[email protected]> > wrote: > > > > > Tried it. No luck. > > Worth trying, however. > > ________________________________________ > > From: Greg Morphis [[email protected]] > > Sent: Friday, October 14, 2011 8:18 AM > > To: cf-newbie > > Subject: Re: Error when adding a second join > > > > Can you wrap the 1 in quotes, just to rule that out? > > <cfqueryparam value="1" cfsqltype="cf_sql_numeric" /> > > > > > > > > On Fri, Oct 14, 2011 at 7:13 AM, Martin, Donna M <[email protected]> > > wrote: > > > > > > > > Good morning, > > > > > > > > > > > > This is strange, and I hope someone can help solve the mystery. All of > > > these are running in a cfc function: > > > > > > > > > > > > This works: > > > > > > > > > > > > yada yada... > > > > > > R.Role, > > > MT.MemberType > > > FROM (TblName T > > > LEFT JOIN Role R > > > ON T.Role_seq = R.Role_seq) > > > WHERE > > > T.NameStatus_seq=<cfqueryparam value=1 > > > cfsqltype="cf_sql_numeric"> > > > ORDER BY T.LName, T.FName > > > > > > ------------------------------------------------- > > > > > > This works, too: > ... > > ________________________________ > > This e-mail message (including any attachments) is for the sole use of > the intended recipient(s) and may contain confidential and privileged > information. If the reader of this message is not the intended > recipient, you are hereby notified that any dissemination, distribution > or copying of this message (including any attachments) is strictly > prohibited. > > If you have received this message in error, please contact > the sender by reply e-mail message and destroy all copies of the > original message (including attachments). > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5689 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
