>- see footer for list info -< cfsqltype="CF_SQL_INTEGER" Is wrong, as it's not an INT, it's a list of values, thus it is a varchar.
Russ > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Lee Fortnam > Sent: 04 February 2005 14:25 > To: [email protected] > Subject: [CF-Dev] Stored procedure in CF > > >- 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 > >-< > _______________________________________________ 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 -<
