>- see footer for list info -< correct. an integer has a length of 4 *bytes*. you can also use smallint (length 2) and bigint (length 8) and tinyint (length 1) http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ia-iz_3ss4.asp
Duncan Cumming New Media Developer Customer Relations Management / Education Fife Council 700 4105 / 01592 414105 >>> [EMAIL PROTECTED] 18/10/2005 10:41 >>> >- see footer for list info -< Thanks, So you don't need to define the size for integers then. >From: "Duncan Cumming" <[EMAIL PROTECTED]> >Reply-To: Coldfusion Development <[email protected]> >To: <[email protected]> >Subject: Re: [CF-Dev] Stored Procedure beginer >Date: Tue, 18 Oct 2005 10:36:53 +0100 > > >- see footer for list info -< >change >@arg_application_ID INT(4), >to >@arg_application_ID INTEGER, > > >Duncan Cumming >New Media Developer >Customer Relations Management / Education >Fife Council >700 4105 / 01592 414105 > > >>> [EMAIL PROTECTED] 18/10/2005 10:31 >>> > >- 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 >-< > > >********************************************************************** >This email and any files transmitted with it are confidential and intended >solely for the use of the individual or entity to whom they are addressed >and should not be disclosed to any other party. >If you have received this email in error please notify your system manager >and the sender of this message. > >This email message has been swept for the presence of computer viruses but >no guarantee is given that this e-mail message and any attachments are free >from viruses. > >Fife Council >Tel: +44 (0) 1592 414141 >********************************************************************** >_______________________________________________ > >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 >-< _______________________________________________ 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 -< _______________________________________________ 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 -<
