Quite sure you can't pass arrays. What about passing a delimited CHAR field
and looping on that? I have done that on several occasions. I.E: 2,5,7,23
JM
----- Original Message -----
From: "Alex Puritche" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 08, 2000 1:16 PM
Subject: An extremely need (semi-OT)
> cf-talk,
>
> I have a need to run a stored procedure which will insert multiple
> rows in the database. Biggest problem that I don't know from the
> begging how much inserts I need to do. I need to pass in the stored
> procedure an array of variables and loop over it.
> How I can pass complex datasets like arrays,lists, etc.
> in the stored procedure?
> How I can loop over that datasets in the stored procedure?
>
> --
> Regards,
> Alex mailto:[EMAIL PROTECTED]
>
> Certified
> http://www.brainbench.com/transcript.jsp?pid=145368
>
> FAQ Project
> http://faq.worldrecovery.com/
>
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.