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