Re: cfstored procedure problem
Kill the single quotes. No need to put them around an SQL var. Chris -- Original Message From: "sebastian palmigiani"<[EMAIL PROTECTED]> Subject: Re: cfstored procedure problem Date: Tue, 05 Dec 2000 22:29:16 -0600 >on 12/5/00 3:46 PM, S R at [EMAIL PROTECTED] wrote: > >> Hi everyone, >> >> I can't figure this one out. I'm using SQL Server 7.0 and CF 4.5 >> >> This is my stored procedure in SQL: >> >> @SAMAccountName varchar >> >> AS >> >> SELECT UserID FROM PasUsers >> WHERE SAMAccountName = '@SAMAccountName' > >I don't know if you purposefully left it out but you need to have: > >CREATE PROCEDURE myProceduresName (@SAMAccountName varchar (field lenght) ) > > >For example: > >CREATE PROCEDURE SelectUserID ( @SAMAccountName varchar (15) ) > >AS > >etc. > >Sebastian > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfstored procedure problem
I've found that you also need to specify the size of your data type. Something like this... @SAMAccountName varchar(50) hope this helps! -Original Message- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 05, 2000 11:29 PM To: CF-Talk Subject: Re: cfstored procedure problem on 12/5/00 3:46 PM, S R at [EMAIL PROTECTED] wrote: > Hi everyone, > > I can't figure this one out. I'm using SQL Server 7.0 and CF 4.5 > > This is my stored procedure in SQL: > > @SAMAccountName varchar > > AS > > SELECT UserID FROM PasUsers > WHERE SAMAccountName = '@SAMAccountName' I don't know if you purposefully left it out but you need to have: CREATE PROCEDURE myProceduresName (@SAMAccountName varchar (field lenght) ) For example: CREATE PROCEDURE SelectUserID ( @SAMAccountName varchar (15) ) AS etc. Sebastian ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfstored procedure problem
on 12/5/00 3:46 PM, S R at [EMAIL PROTECTED] wrote: > Hi everyone, > > I can't figure this one out. I'm using SQL Server 7.0 and CF 4.5 > > This is my stored procedure in SQL: > > @SAMAccountName varchar > > AS > > SELECT UserID FROM PasUsers > WHERE SAMAccountName = '@SAMAccountName' I don't know if you purposefully left it out but you need to have: CREATE PROCEDURE myProceduresName (@SAMAccountName varchar (field lenght) ) For example: CREATE PROCEDURE SelectUserID ( @SAMAccountName varchar (15) ) AS etc. Sebastian ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfstored procedure problem
http://www.wizaerd.com = > -Original Message- > From: S R [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, December 05, 2000 2:46 PM > To: CF-Talk > Subject: cfstored procedure problem > > > Hi everyone, > > I can't figure this one out. I'm using SQL Server 7.0 and CF 4.5 > > This is my stored procedure in SQL: > > @SAMAccountName varchar > > AS > > SELECT UserID FROM PasUsers > WHERE SAMAccountName = '@SAMAccountName' > > Here is my CF Code: > > ATTRIBUTES="SAMAccountName" SCOPE="subtree" > FILTER="SAMAccountName=#cgi.auth_user#" START="" > USERNAME="mydomain\sal.rosales" PASSWORD="password" PORT="" > TIMEOUT="30"> > > DBNAME="userpreferences" > PROCEDURE="GetUserID"> > VALUE="#GetUser.SAMAccountName#" TYPE="In"> > CFSQLTYPE="CF_SQL_INTEGER"> > > > #UserID# > > I keep getting a 'Data Access Error Unknown data' > > Sal > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfstored procedure problem
> I can't figure this one out. I'm using SQL Server 7.0 and CF 4.5 > > This is my stored procedure in SQL: > > @SAMAccountName varchar > > AS > > SELECT UserID FROM PasUsers > WHERE SAMAccountName = '@SAMAccountName' > > Here is my CF Code: > > ATTRIBUTES="SAMAccountName" SCOPE="subtree" > FILTER="SAMAccountName=#cgi.auth_user#" START="" > USERNAME="mydomain\sal.rosales" PASSWORD="password" PORT="" > TIMEOUT="30"> > > DBNAME="userpreferences" > PROCEDURE="GetUserID"> > VALUE="#GetUser.SAMAccountName#" TYPE="In"> > CFSQLTYPE="CF_SQL_INTEGER"> > > > #UserID# It looks to me like your stored procedure is returning a recordset, not a parameter, but your CFSTOREDPROC tag is referencing an output parameter instead of a recordset. Try this: #MyUserID.UserID# Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfstored procedure problem
I'm pretty sure you don't need the quotes in your SQL statement -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 06, 2000 7:46 AM To: CF-Talk Subject: cfstored procedure problem Hi everyone, I can't figure this one out. I'm using SQL Server 7.0 and CF 4.5 This is my stored procedure in SQL: @SAMAccountName varchar AS SELECT UserID FROM PasUsers WHERE SAMAccountName = '@SAMAccountName' Here is my CF Code: #UserID# I keep getting a 'Data Access Error Unknown data' Sal ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists