Jerry, Since lists are also strings why not pass it in as a varchar using cfsqltype="CF_SQL_VARCHAR"
then within the stored procedure select * from country where country_id IN (@countries) just make sure the varchar is large enough to hold a little more than the maximum number of characters that the list can contain At 03:52 AM 4/16/2002, you wrote: >Adrian, >Im not sure as I am new to stored procedures.What do you think it should >be ? > > >-----Original Message----- >From: Adrian Lynch [mailto:[EMAIL PROTECTED]] >Sent: 16 April 2002 11:43 >To: CF-Talk >Subject: RE: Stored Process > > >cfsqltype="CF_SQL_INTEGER" <<<<<<<< is that correct?? > >-----Original Message----- >From: Jerry Staple [mailto:[EMAIL PROTECTED]] >Sent: 16 April 2002 11:31 >To: CF-Talk >Subject: Stored Process > > >Hi , > I am transferring few queries into stored procedures but I have >come across a stumbling block, and would be grateful if anyone could >advise, for example: > >I am gathering a list of all countries on one page and sending them to >the action page as a list, what I have is a query select * from country >where country_id in (#url.countries#). This works fine in cfquery of >course, but when I put it into a stored procedure it doesn't like the >list of id's being passed in and only expects one value. > >I.E. > ><cfstoredproc > procedure="sp_countries" > datasource="geographical" > RETURNCODE="YES" > > > <cfprocparam type="In" > dbvarname="@country" > value="#url.countries#" > cfsqltype="CF_SQL_INTEGER"> > > ><cfprocresult name="Sp_Countries"> > ></cfstoredproc> > > > >You may be thinking what would I want to put this in a stored procedure >for, but above is only an example but the principle is what im after. >How do you pass a list into a stored procedure. > >Many Thanks In advance > >Jerry Staple >Web Application Developer >Certified Coldfusion (5.0) Developer > > >Head Office >133-137 Lisburn Road, Belfast >Northern Ireland BT9 7AG >T +44 (0) 28 9022 3224 >F +44 (0) 28 9022 3223 >E [EMAIL PROTECTED] >W www.biznet-solutions.com > > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
