Umm, it asks for a username/password :)
-----Original Message-----
From: Don Vawter [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 23, 2001 5:06 PM
To: CF-Talk
Subject: Re: Passing list to Stored Procedure..
Ok I put them out there as is. I am no SQL Server Guru so I make no
guarantees about efficiency. Also I wrote the functions to use any
delimitter but I only use commas in my site. I have unit tested them with
other delimitters but nothing extensive. They are "I am in a hurry and I am
the only one who uses them documented" They were wriiten in SQL Server 2000
but AFAIK they should work in 7 also.
http://www.cyberroomies.com/data/listfunctions.zip
Enjoy
----- Original Message -----
From: "Don Vawter" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, August 22, 2001 8:02 PM
Subject: Re: Passing list to Stored Procedure..
> 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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists