STORED PROCEDURE
CREATE PROCEDURE adminlogin
@user NVarChar (64),
@password NVarChar (32)
AS
SELECT Comp.COMP_ID_INT, Client.CLIENT_ID_INT
FROM Client, Comp, Comp_Client
WHERE Comp_Client.COMP_ID_INT = Comp.COMP_ID_INT AND
Comp_Client.CLIENT_ID_INT = Client.CLIENT_ID_INT AND
(Client.USERNAME_VC = @user) AND (Client.PASSWORD_VC =
@password)
stored procedure tag in your CF CODE
(attributes.user and attributes.password) could also be form.user and
form.password or whatever scope you choose)
<!--- CFSTOREDPROC tag --->
<CFSTOREDPROC PROCEDURE="ormlogin" datasource="#attributes.dsn#"
DBSERVER="#attributes.dbserver#" DBNAME="#attributes.dbname#"
USERNAME="#attributes.dbusername#" PASSWORD="#attributes.dbpassword#"
RETURNCODE="YES" DEBUG>
<!--- CFPROCRESULT tags --->
<CFPROCRESULT NAME = ormlogin>
<!--- CFPROCPARAM tags --->
<CFPROCPARAM TYPE="IN" CFSQLTYPE=CF_SQL_VARCHAR
VALUE="#trim(attributes.user)#" DBVARNAME=@retuser>
<!--- CFPROCPARAM tags --->
<CFPROCPARAM TYPE="IN" CFSQLTYPE=CF_SQL_VARCHAR
VALUE="#trim(attributes.password)#" DBVARNAME=@retpassword>
<!--- Close the CFSTOREDPROC tag --->
</CFSTOREDPROC>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
