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:5683 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
