- see footer for list info -<
Having never used stored procedures before I decided its time I learned how
to do this ...
So heres the first question ...
I have a this in query analyzer ...
CREATE PROCEDURE cfpages_Authenticate (
@arg_application_ID INT(4),
@arg_LoginName NVARCHAR(50),
@arg_Password CHAR(8))
AS
SELECT TOP 100 PERCENT tblAuthentication.UsersName,
tblAuthentication.LoginName,
tblAuthentication.Password,
tblusertoapplication.FKApplicationID,
tblAuthentication.UserIDPK,
tblAuthentication.EmailAddress
FROM tblAuthentication
INNER JOIN tblusertoapplication ON tblAuthentication.UserIDPK =
tblusertoapplication.FKUserID
WHERE (tblusertoapplication.FKApplicationID = @arg_application_ID)
AND (tblAuthentication.LoginName = @arg_LoginName)
AND (tblAuthentication.Password = @arg_Password)
ORDER BY tblAuthentication.UsersName
Which syntax checks all ok .....
When I run it I get ...
Server: Msg 2716, Level 16, State 1, Procedure cfpages_Authenticate, Line 0
Column or parameter #1: Cannot specify a column width on data type int.
Parameter '@arg_application_ID' has an invalid data type.
It doesn't like the INT for the Primary Key of ApplicationID
How do I fix this and why is it giving me an error?
Regards - Paul
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
- Hosting provided by www.cfmxhosting.co.uk -<
- Forum provided by www.fusetalk.com -<
- DHTML Menus provided by www.APYCOM.com -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
