able to blindly pass in my vars to a stored procedure, and let SQL determine
if a NULL is required or not. One variable example is below on how I am
passing it, as well as the first few lines of the stored procedure. Is this
the only way to achieve this and not store a space in the column?
<cfif trim(AUTH_AUTH_AVS) NEQ "">
<cfprocparam type="In" variable="@AUTH_AUTH_AVS"
cfsqltype="CF_SQL_VARCHAR" value="#auth_auth_avs#">
<cfelse>
<cfprocparam type="In" variable="@AUTH_AUTH_AVS"
cfsqltype="CF_SQL_VARCHAR" null="Yes">
</cfif>
And the start of the stored proc:
CREATE PROCEDURE nwoSP_insTblCCAuthLog (
@auth_auth_avs char (1) = NULL ,
Dan
------------
Dan O'Keefe
561-703-8976
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
