i routinely pass a comma delimited list to SQL Server stored procs. I just
wrote a few simple udfs in sql server to parse the list when it gets it.
----- Original Message -----
From: "Darryl Lyons" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 22, 2001 4:50 PM
Subject: SOT: Passing list to Stored Procedure..
> Does anyone know if you can pass a list of values to a stored procedure
via
> CF? This is mainly needed because the list values would be drawn from an
> unspecified datasource (e.g. a list of user groups stored in a session
> var)..
>
> -----------------------------------
> Regards,
>
> Darryl Lyons
> Senior Systems Developer
> Fuzion: http://www.fuzion.com.au
>
> Email : [EMAIL PROTECTED]
> Phone : (07) 3620 1000
> Fax : (07) 3620 1001
> Technical Support : 1300 888 480
>
> 'merging business + technology'
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
