Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re: while (my @row = $sth->fetchrow_array)

by SamCG (Hermit)
on Jan 10, 2006 at 17:33 UTC ( [id://522251]=note: print w/replies, xml ) Need Help??


in reply to while (my @row = $sth->fetchrow_array)

I'd concur with dragonchild, and add that jesuashok's first suggestion, ordering within the sql output, may have issues but has some sense behind it.

You're going to the database separately for each @Geo_area. Maybe you're just picking out some (and not all) geo_areas, but perhaps then it makes more sense to do your filtering of these rows with a regex after you've done your select statement? Whether this makes sense probably depends on the number of rows being returned and the number of geographic areas (well, I'm guessing that's what they are) being investigated.

As for it not printing to an output file, check silly things like that the output file is open for writing, and that your query is actually returning any records. I notice you don't have any % signs bracketing your LIKE statement. Is this in the data, or is the LIKE really functioning as an =?
  • Comment on Re: while (my @row = $sth->fetchrow_array)

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others pondering the Monastery: (2)
As of 2024-04-25 02:09 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found