>
> I have been having a heck of a time with trying to pass a list into a
> stored procedure and have it parsed out. The problem I am having is
> getting CF to pass the list into the stored procedure. Can someone point
> me in the right direction?
> <cfset Keys = ListChangeDelims(Keys, "|", ",")>
> <cfquery name="deDupeSegments" dbtype="odbc" datasource="#Client.DS#"
> username="#Client.UID#" password="#Client.PWD#">
> EXEC #Client.DBPrefix#.uspCrossSegmentEmailRemove
> @Str = #Keys#
> </cfquery>
How about using cfqueryparam and the list attribute?
<cfquery name="deDupeSegments" dbtype="odbc"
datasource="#Client.DS#" username="#Client.UID#"
password="#Client.PWD#">
EXEC #Client.DBPrefix#.uspCrossSegmentEmailRemove
@Str = <cfqueryparam cfsqltype="cf_sql_integer"
value="#Keys#" list="yes">
</cfquery>
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
