Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
PerlMonks  

Re: using fetchrow_hashref

by maverick (Curate)
on Dec 30, 2003 at 19:47 UTC ( #317757=note: print w/ replies, xml ) Need Help??


in reply to using fetchrow_hashref

Chang your SQL query to read:

SELECT code, sum(number) as foobar FROM $serverTabl_4 group by code
and then use 'foobar' in the hash ref.

Basically, the keys are whatever it thinks the column name is..so if you use 'sum(column)', 'avg(column)' or the like, it names the key that. If you tack on the 'as something_else' after it, you can effectively name the keys whatever you like. This is also handy when you have a join across two tables that have similarily named columns :)

/\/\averick

Update: Heh. 3rd fastest keys in the west...


Comment on Re: using fetchrow_hashref
Download Code
Re: Re: using fetchrow_hashref
by Baz (Friar) on Dec 30, 2003 at 19:55 UTC
    Cool, thanks guys.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://317757]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others rifling through the Monastery: (5)
As of 2014-10-23 04:00 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    For retirement, I am banking on:










    Results (123 votes), past polls