Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

Re: Select quuery result sets

by petecm99 (Pilgrim)
on Aug 26, 2010 at 12:18 UTC ( #857428=note: print w/replies, xml ) Need Help??


in reply to Select quuery result sets

You should be able to reference them as individual fields, like so:

$emp_qry->execute(); while ( my $emprec = $emp_qry->fetchrow_hashref ) { $tmp_e1 = $emprec->{e1}; $tmp_e2 = $emprec->{e2}; $tmp_e3 = $emprec->{e3}; $tmp_e4 = $emprec->{e4}; } $emp_qry->finish();

Hope this helps...

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (2)
As of 2016-09-25 03:55 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Extraterrestrials haven't visited the Earth yet because:







    Results (463 votes). Check out past polls.