Many thanks to Nick Slay and Orlando Correa for their suggestions.
I found out that the reason I was getting the Error 22005 message when
calling a SQL Server stored procedure
from ColdFusion, was because of the following two reasons:
(1) It appears that you cannot specify a default null in the stored
procedure T-SQL. So instead of
CREATE PROCEDURE sp_UpdateCDROM ( @CDROMID int, @Title varchar(64),
@FullTitle varchar(128) = null, @Supplier varchar(64) = null, @DiskNo
smallint = null, @CDKey varchar(64) = null, .....
You should have
CREATE PROCEDURE sp_UpdateCDROM ( @CDROMID int, @Title varchar(64),
@FullTitle varchar(128), @Supplier varchar(64), @DiskNo smallint, @CDKey
varchar(64), .....
However, this does mean that you can't have default parameters in this case.
(2) For varchar parameters you need to use th MAXLENGTH property of the
CFPROCPARAM tag; eg:
<cfprocparam type="in" dbvarname="@Title" value="#FORM.Title#"
cfsqltype="CF_SQL_VARCHAR" maxlength="64">
James Page
| james page | database developer |
| UPC TV interactive |
| w. +44 (2)0 7533 6573
| [EMAIL PROTECTED]
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
