Sorry for the somewhat OT Post, but this is one of my better resources for CF I have
I was wondering if anybody had any code snippets for passing a list to a SQL Server 2000 stored procedure. I have the CF front-end working fine but when I send the list (61755,61754) to the stored procedure I get no results, when I pass a singe variable (61755), I get the results that I am looking for. Here is my stored procedure: CREATE PROCEDURE MasterAssignments @ClientList nvarchar (4000) AS SELECT Assignments.dbnum, Master.prim_name, Master.prim_ssn, SUM(Assignments.currbal) AS TotalBalance FROM Assignments INNER JOIN Master ON Master.dbnum = Assignments.dbnum WHERE Assignments.clnt IN (@clientList) GROUP BY Assignments.dbnum, Master.prim_name, Master.prim_ssn ORDER BY Master.prim_name GO Any suggestions or leads would be very helpful, I have been working on this problem for a couple of days know Thanks Jason Larson [EMAIL PROTECTED] ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
