[prev in list] [next in list] [prev in thread] [next in thread] 

List:       msql-mysql-modules
Subject:    Re: DBI and DBD::mysql pseudohash results set?
From:       Dan Bolser <dmb () mrc-dunn ! cam ! ac ! uk>
Date:       2004-09-21 21:44:22
Message-ID: Pine.LNX.4.21.0409212217520.2887-100000 () mail ! mrc-dunn ! cam ! ac ! uk
[Download RAW message or body]

On Sat, 18 Sep 2004, Dan Bolser wrote:

>On Sat, 18 Sep 2004, Jochen Wiedmann wrote:
>
>>Dan Bolser wrote:
>>
>>>I was thinking about loading the rows of a $sth results set into a
>>>pseudohash so that the columns could be accessed by either the column name
>>>or the column index.
>>>  
>>>
>>You are of course free to do so. But what is it good for? DBI already 
>>offers one or the other, on your choice, and I cannot remember a case 
>>where I need both at the same time. Besides, you always have the DBI 
>>metadata methods.
>
>
>You are right, it should never be strictly necessary. However, I am
>thinking about a convenience function such as 'doQuery' (exported by my
>MySQL::Simple perl module).
>
>In general (I think) it is convenient to only remember one function call
>'doQuery', and have a very flexible results set returned.
>
>In this way the user can hack together an sql report in a very short
>amount of time. 
>
>I will have to look into the metadata methods, as I am totally ignorant of
>this feature.

Doh! Not thinking that day. 


>
>Thanks for your help.
>
>Anybody know about the future stability of the pseudohash?
>
>Cheers,
>Dan.
>
>
>>
>>
>>Jochen
>>
>>
>>
>
>


-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl?unsub=msql-mysql-modules@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]