Tom,
Unless you are expressively setting your request variables to "null" it will bomb out.
There are two ways to go about this:
1) build a UDF that checks for "" and return null (theval = null;) and process as you
have it.
2) Build conditional statements.
<cfstoredproc procedure="sp_actUpdateTaxonomyTypeMapping" datasource="#Request.DSN#">
<cfif Request.stAttributes.numSiteID eq "">
<cfprocparam type="In" cfsqltype="CF_SQL_INTEGER" variable="numSiteID"
null="Yes">
<cfelse>
<cfprocparam type="In" cfsqltype="CF_SQL_INTEGER" variable="numSiteID"
value="#Request.stAttributes.numSiteID#" null="No">
</cfif>
I am not sure if the first works, because I have not tested it. I do know the latter
works
Sincerely,
Ricardo Sanoja
Senior Web Architect
Version 4 Technologies, LLC.
4288 Kellway Circle
Addison, TX 75001-4200
214.641.5255
[EMAIL PROTECTED]
-----Original Message-----
From: Schreck, Tom [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 18, 2002 1:58 PM
To: [EMAIL PROTECTED]
Subject: cfstoredproc question
I have a stored procedure to update data in a table. Some of the fields I'm passing
in can be null. My stored proc is bombing on null fields. I get the message "Invalid
character value for cast specification"
Here's my stored proc call:
<cfstoredproc procedure="sp_actUpdateTaxonomyTypeMapping"
datasource="#Request.DSN#">
<cfprocparam type="In" cfsqltype="CF_SQL_INTEGER" variable="numSiteID"
value="#Request.stAttributes.numSiteID#" null="No">
<cfprocparam type="In" cfsqltype="CF_SQL_INTEGER"
variable="numTaxonomyTypeID" value="#Request.stAttributes.numTaxonomyTypeID#"
null="No">
<cfprocparam type="In" cfsqltype="CF_SQL_INTEGER"
variable="numTaxonomyID" value="#loopItem#" null="No">
<cfprocparam type="In" cfsqltype="CF_SQL_INTEGER" variable="numOrder"
value="#iterativeOrder#" null="No">
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR"
variable="txtDefaultFuse" value="#variables.txtDefaultFuse#" null="no">
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR"
variable="txtImageExtension" value="#variables.txtImageExtension#" null="no">
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR"
variable="txtImageKey" value="#variables.txtImageKey#" null="no">
<cfprocparam type="In" cfsqltype="CF_SQL_TINYINT"
variable="numImageWidth" value="#variables.numImageWidth#" null="no">
<cfprocparam type="In" cfsqltype="CF_SQL_TINYINT"
variable="numImageHeight" value="#variables.numImageHeight#" null="no">
<cfprocparam type="In" cfsqltype="CF_SQL_BIT" variable="ynIsDefault"
value="#variables.ynDefaultTaxonomy#" null="No">
<cfprocparam type="In" cfsqltype="CF_SQL_BIT" variable="ynIsActive"
value="#Evaluate('Request.stAttributes.ynIsActive_#loopItem#')#" null="No">
</cfstoredproc>
Thanks - Tom
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
