Re: arrays in stored procedures - pl. help

2006-07-25 Thread Peter Brawley
My question is how do I send multiple sets of data into a stored procedure without doing the things I had outlined. MySQL doesn't have arrays. Pass the data in a comma-delimited string and PREPARE the statement, or pass it as a temp memory table. PB - L P wrote: Chris, thank you fo

Re: arrays in stored procedures - pl. help

2006-07-25 Thread L P
Chris, thank you for the response, but that was not my question. My question is how do I send multiple sets of data into a stored procedure without doing the things I had outlined. On 7/17/06, Chris <[EMAIL PROTECTED]> wrote: L P wrote: > Folks, > say I have a need to add multiple rows at the

Re: arrays in stored procedures - pl. help

2006-07-17 Thread Chris
L P wrote: Folks, say I have a need to add multiple rows at the same time. for instance, say I'm collecting customer information and I want to add 3 addresses and 3 phone numbers at the same time for a customer. The above is quite straightforward to accomplish when there is only one set of data

arrays in stored procedures - pl. help

2006-07-16 Thread L P
Folks, say I have a need to add multiple rows at the same time. for instance, say I'm collecting customer information and I want to add 3 addresses and 3 phone numbers at the same time for a customer. The above is quite straightforward to accomplish when there is only one set of data to deal wit