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: > > > > > > > > yada, yada... > > > > 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=1 > > ORDER BY T.LName, T.FName > > > > -------------------------------------------------- > > > > This does NOT work: > > > > yada, yada... > > > > 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 > > > > ------------------------------------------------ > > > > I get: Error Executing Database Query - 'Invalid parameter number' > > > > > > > > Any clues? I'm stumped, or just plain stupid... > > > > Any help will be appreciated. > > Donna > > > > ________________________________ > > > > 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:5684 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
