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
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
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
