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

Re^3: Extracting only required length in a column in perl DBI

by marto (Chancellor)
on Jan 15, 2013 at 12:53 UTC ( #1013392=note: print w/ replies, xml ) Need Help??


in reply to Re^2: Extracting only required length in a column in perl DBI
in thread Extracting only required length in a column in perl DBI

Replace the 3 in my example with a 6, you should consider learning basic SQL.


Comment on Re^3: Extracting only required length in a column in perl DBI
Re^4: Extracting only required length in a column in perl DBI
by Thomas Kennll (Acolyte) on Jan 15, 2013 at 13:08 UTC
    What I meant is something like this my ($ansb_cktid, $ansb_mcn, $ansb_soc) =unpack("A3 A3 A6")

      I'm of the mind set that you shouldn't pull back more data than you need then post process it, when you can easily return only what you need.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (10)
As of 2014-10-21 10:51 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    For retirement, I am banking on:










    Results (100 votes), past polls