http://www.perlmonks.org?node_id=1004826


in reply to DBI don't fetch my data...or at least not all records

This has nothing to do with your question, but I thought I'd add it. It's regarding the coding of your sql queries. I use heredocs. It's not really necessary for a short query, but comes in handy for complex ones. Makes code very easy to follow.
my $sql = <<EOQ; select BBTicker, WMRic from FXSpots where id = 218' EOQ