>- see footer for list info -<
Hi All,
I have a stored procedure which just queries a lookup table.
Here is the store procedure:
CREATE PROCEDURE spr_GET_USER_GROUPS_MEMBERS
@MemberIDs int
AS
SELECT
*
FROM
LKU_Addresses_Groups
WHERE
(GroupID IN (@MemberIDs))
GO
The value I am trying to pass into @MemberIDs is 1,2,3,4 (i.e. a list of
numeric values generated by a ListValue function.
If is run the query from within SQL Server replacing @MemberIDs with
1,2,3 it works fine, but receive nothing when placing it in a stored
procedure.
Here is my stored procedure call:
<!--- Get members for user --->
<cfstoredproc procedure="spr_GET_USER_GROUPS_MEMBERS"
datasource="#request.dsn#" username="#request.db_username#"
password="#request.db_password#" returncode="Yes">
<cfprocparam type="In"
value="#ValueList(res_GET_USER_GROUPS.GroupID,",")#"
cfsqltype="CF_SQL_INTEGER" variable="MemberIDs">
<cfprocresult name="res_GET_USER_GROUPS_MEMBERS">
</cfstoredproc>
Anyone got any ideas why it would return 1 set of details directly
within SQL Server but nothing through a store procedure?
Regards,
Lee
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
>- Hosting provided by www.cfmxhosting.co.uk -<
>- Forum provided by www.fusetalk.com -<
>- DHTML Menus provided by www.APYCOM.com -<
>- Lists hosted by www.Gradwell.com -<
>- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
