From: Johan De Meersman
Date: August 28 2011 7:39am
Subject: Re: Arrays
List-Archive: http://lists.mysql.com/mysql/225608
Message-Id: <24a2d202-3a8c-4d96-9116-bac114cdd551@zimbra>
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="=_fce2d6c4-cbff-44be-84a3-1cef3a0994ab"
--=_fce2d6c4-cbff-44be-84a3-1cef3a0994ab
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
----- Original Message -----
> From: "Arthur Fuller"
> Another approach to this is to create a concatenated string from the
> PKs of the result set and then parse that within a stored procedure
> elsewhere in your Front End (FE). For more information on this,
> visit www.artfulsoftware.com and check out the Queries page.
That works; but string constructs are touchy at the best of times, and get exponentially complexer with your dataset. If you're going that route anyway, just construct XML with all the data you need to return - the application is almost guaranteed to have some way of handling it these days, and I'm reasonably sure that MySQL also has some functionality for it.
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
--=_fce2d6c4-cbff-44be-84a3-1cef3a0994ab--