Whenever I right an SP I use..
CREATE PROCEDURE someSP
@somthing AS int,
@somethingelse AS varchar(50)
I don't know if not using the AS is ok or not but give it a go, see if it
fixes it
Ade
-----Original Message-----
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]]
Sent: 30 September 2002 02:34
To: CF-Talk
Subject: more cfstoredproc issues ...
Argh!
I have a stored procedure with parameters as:
CREATE PROCEDURE tap_adLibUpdate
@LibraryID int,
@Ident int,
@UpdatedDate datetime,
@PageFileName varchar(15) = NULL,
@ArchivePath varchar(15) = NULL,
@Scheduled bit = 0,
@RestoreID int = NULL,
@UpdateError varchar(8000) = NULL
AS
and I'm using this code in CF:
<cfstoredproc procedure="tap_adLibUpdate" datasource="#request.tap.dsn#"
username="#request.tap.dsnusr#" password="#request.tap.dsnpwd#">
<cfprocparam type="in" dbvarname="LibraryID"
value="#variables.PageID#"
cfsqltype="cf_sql_integer">
<cfprocparam type="in" dbvarname="Ident" value="#Request.User.ID#"
cfsqltype="cf_sql_integer">
<cfprocparam type="in" dbvarname="UpdatedDate"
value="#CreateODBCDate(Now())#" cfsqltype="cf_sql_timestamp">
<!--- indicates the file name for a top level container -- file
extension
may change although file name is consistent --->
<cfprocparam type="In" dbvarname="PageFileName"
value="#variables.tempfilename#" cfsqltype="cf_sql_varchar"
null="#yesnoformat(not rspage.istoplevelcontainer)#">
<!--- archive path indicates where restoring content is being
restored from
-->
<cfprocparam type="in" dbvarname="ArchivePath"
value="#variables.archivepath#" cfsqltype="cf_sql_varchar"
null="#yesnoformat(not request.tap.archivecontent)#">
<cfprocparam type="In" dbvarname="Scheduled" value="0"
cfsqltype="cf_sql_bit">
<cfprocparam type="in" dbvarname="restoreid"
value="#variables.restoreid#"
cfsqltype="cf_sql_integer"
null="#yesnoformat(IsDate(attributes.RestoreFromDate))#">
<cfprocparam type="In" dbvarname="UpdateError"
value="#variables.errormessage#" cfsqltype="cf_sql_varchar">
<cfprocresult name="rsupdate" resultset="1">
</cfstoredproc>
and I'm getting this error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Procedure 'tap_adLibUpdate'
expects parameter '@LibraryID', which was not supplied.
I know that the LibraryID parameter is defined in the <cfprocparam> tags. I
know that none of it was misspelled. I know that the value of
variables.PageID is an integer. What I don't know is why I'm getting an
error message that tells me exactly what the problem is not.
Anybody have any ideas?
Isaac Dealey
Certified Advanced ColdFusion 5 Developer
new epoch
www.turnkey.to
954-776-0046
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
