Can I check 3 different tables at the same time like in this query? Is
this logic ok?
<cfquery name="loginCheck" datasource="#APPLICATION.dsn#">
SELECT c.clubId,
c.shortName,
cM.clubMemberId,
cLM.clubId,
cLM.clubMemberId,
cM.loginName,
cM.password_2
FROM club as c,
clubMember as cM,
clubLinkMember as cLM
WHERE c.shortName = #URL.shortName#
AND cM.loginName = '#FORM.loginName#'
AND cM.password_2 = '#FORM.password#'
AND cLM.clubMemberId = cM.clubMemberId
AND cLM.clubId = cM.clubId
</cfquery>
--
-------------------------------------------
Ravi Gehlot.
Sr. Management
Sunshine Technology Solutions, LLC
http://www.sunshinetechsolutions.com/
-------------------------------------------
Confidentiality Notice: This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 and Flex 2
Build sales & marketing dashboard RIAâs for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278667
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
