Error when adding a second join

[Martin, Donna M]

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