[REBOL] mysql-protocol
From: tim:johnsons-web at: 26-Jun-2003 7:54
Hello Rebols:
DocKimbel and I had an OT exchange of emails early
this year in which I posed the the following:
That it would be convenient at times for me to have
the selection set from a query returned as a 'flat'
block.
DocKimbel made the following code suggestions:
Add 'flat' to locals-class. setting as either 'true
or 'false.
in 'convert-types change the following line
if not empty? convert-body [foreach row rows :convert-body]
;to
if not empty? convert-body [
either p/locals/flat? [
row: rows
forskip row length? cols :convert-body
][foreach row rows :convert-body]
]
After implementing this - if memory serves me well -
DocKimbel indicated that he had observed less memory fragmentation
in comparison of the two methods.
For my own needs, I find it frequently useful to use the 'flat'
setting as 'true'.
It means that I can use the same block to form a query and to
extract the data, easily 'forskip'ing thru the selection set.
Sure beats the the python 'dictionary' method.
tim
--
Tim Johnson <[tim--johnsons-web--com]>
http://www.alaska-internet-solutions.com
http://www.johnsons-web.com