>- see footer for list info -< Nope, @arg_application_ID INT is all you need ...
-----Original Message----- From: Paul Swingewood [mailto:[EMAIL PROTECTED] Sent: 18 October 2005 10:41 To: [email protected] Subject: Re: [CF-Dev] Stored Procedure beginer >- 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 -< **************************************************************************** Notice: This e-mail and any attachments are confidential and may contain legally privileged information and/or copyright material of Hansen Technologies Limited or third parties. Copying, distributing, disclosing, commercialising or otherwise acting in reliance on this e-mail and any attachments is strictly prohibited unless you are the addressee of this e-mail and have written permission to do so. If you have received this e-mail in error please delete this e-mail (including any copies and attachments) and contact Hansen Technologies Limited by return e-mail or by telephone on + 61 39840 3000. Any views expressed in this e-mail are those of the individual sender and may not necessarily reflect the views of or be a commitment by the organisation, except where the individual sender has the authority and expressly states them to be so. **************************************************************************** _______________________________________________ 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 -<
