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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: An extremely need (semi-OT)
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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re[2]: An extremely need (semi-OT)
J.Milks, Yes. You are right. Only this way. Related URL http://www.sqlteam.com/item.asp?ItemID=256 Friday, September 08, 2000, 10:13:23 PM, you wrote: J.Milks Quite sure you can't pass arrays. What about passing a delimited CHAR field J.Milks and looping on that? I have done that on several occasions. I.E: 2,5,7,23 J.Milks JM J.Milks - Original Message - J.Milks From: "Alex Puritche" [EMAIL PROTECTED] J.Milks To: [EMAIL PROTECTED] J.Milks Sent: Friday, September 08, 2000 1:16 PM J.Milks 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/ -- J.Milks Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit J.Milks http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or J.Milks send a message to [EMAIL PROTECTED] with 'unsubscribe' in J.Milks the body. J.Milks -- J.Milks Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ J.Milks To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Regards, Alexmailto:[EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.