- see footer for list info -<
Thanks for that. Just not looking at the code properly. You see an error and
blame the new thing you've done rather than checking everything .....
Its stopped now on a permissions error but I guess thats on the SQL server.
Regards - Paul (Almost there ...)
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 11:00:59 +0100
>- see footer for list info -<
<cfif isDefined("#form.entered_username#") AND #form.entered_username# NEQ
"">
should be
<cfif isDefined("form.entered_username") AND #form.entered_username# NEQ
"">
It would be further improved if you wrote it as:
<cfif isDefined("form.entered_username") AND
Len(Trim(form.entered_username))>
Duncan Cumming
New Media Developer
Customer Relations Management / Education
Fife Council
700 4105 / 01592 414105
>>> [EMAIL PROTECTED] 18/10/2005 10:57 >>>
>- see footer for list info -<
Ok I have the stored procedure on the server and it appears to have worked
ok.
I now want to call the stored procedure ....
I have
<cfset sp = "cfpages_Authenticate">
<cfif isDefined("#form.entered_username#") AND #form.entered_username# NEQ
"">
<cfstoredproc procedure="#sp#" datasource="#Application.BackendDSN#">
<!--- Apllication ID --->
<cfprocparam
cfsqltype="cf_sql_varchar"
value="#Application.ID#">
<!--- LoginName --->
<cfprocparam
cfsqltype="cf_sql_varchar"
value="#form.entered_username#">
<!--- Password --->
<cfprocparam
cfsqltype="cf_sql_varchar"
value="#form.entered_password#">
<cfprocresult
name="Results">
</cfstoredproc>
<cfdump var="#Results#" label="Results">
</cfif>
<cfabort>
When I run this code I get .....
Parameter 1 of function IsDefined, which is now "Paul
Swingewood",
must be a syntactically valid variable name.
The error occurred in
D:\inetpub\wwwroot\cfpages\calendar\login\login_action2.cfm: line 31
29 : <cfset sp = "cfpages_Authenticate">
30 :
31 : <cfif isDefined("#form.entered_username#") AND #form.entered_username#
NEQ "">
32 : <cfstoredproc procedure="#sp#" datasource="#Application.BackendDSN#">
33 : <!--- Apllication ID --->
>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
-<
_______________________________________________
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 -<
