Pathologically Eclectic Rubbish Lister | |
PerlMonks |
Re^4: How to stuff space separated column into Hashby Marshall (Canon) |
on Aug 29, 2016 at 21:51 UTC ( [id://1170749]=note: print w/replies, xml ) | Need Help?? |
Glad that you have something "that works". Since I see that you are using the DBI and SQL, I would use the power of SQL instead of trying to replicate this into a HOH. I actually was wondering what you did with for example 'IBM' as element 0. You can get the unique names of the companies, IBM,Oracle, etc. and then run SQL queries to get those company specific results. It looks like you may be trying to translate the entire SQL DB into a HoH memory array? I am quite sure that this will work for a spreadsheet. However for a big DB, that won't work and is not necessary. It appears to me that you need some more DBI "kung foo".
In Section
Seekers of Perl Wisdom
|
|