Re: Stored proc - dynamic sql in cursor

2008-10-17 Thread Olaf Stein
and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. Date: Thu, 16 Oct 2008 16:46:35 -0400 Subject: Re: Stored proc - dynamic sql in cursor From: [EMAIL PROTECTED] To: [EMAIL

Stored proc - dynamic sql in cursor

2008-10-16 Thread Olaf Stein
Hi all, I am running into some issues with what I am trying to do in a stored proc. Basically I am trying to find records related to certain individuals in other tables in the databases and if there are any, tell me how many. Instead of doing this for each of these tables individually I use a

Re: Stored proc - dynamic sql in cursor

2008-10-16 Thread Olaf Stein
:23 -0400 Subject: Stored proc - dynamic sql in cursor From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Hi all, I am running into some issues with what I am trying to do in a stored proc. Basically I am trying to find records related to certain individuals in other tables

Re: Stored proc - dynamic sql in cursor

2008-10-16 Thread Rob Wultsch
On Thu, Oct 16, 2008 at 12:31 PM, Olaf Stein [EMAIL PROTECTED] wrote: Hi all, I am running into some issues with what I am trying to do in a stored proc. Basically I am trying to find records related to certain individuals in other tables in the databases and if there are any, tell me how

Re: Stored proc - dynamic sql in cursor

2008-10-16 Thread Olaf Stein
not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. Date: Thu, 16 Oct 2008 15:31:23 -0400 Subject: Stored proc - dynamic sql in cursor From: [EMAIL PROTECTED] To: mysql@lists.mysql.com

Re: Stored proc - dynamic sql in cursor

2008-10-16 Thread Olaf Stein
Thanks, The INTO clause I had totally disregarded... And I could do this outside the database I just have the cmd line client connected at all times anyway and like to quickly look up certain things... On 10/16/08 4:14 PM, Rob Wultsch [EMAIL PROTECTED] wrote: On Thu, Oct 16, 2008 at 12:31

Re: Stored proc - dynamic sql in cursor

2008-10-16 Thread Olaf Stein
is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. Date: Thu, 16 Oct 2008 16:14:39 -0400 Subject: Re: Stored proc - dynamic sql in cursor From: [EMAIL