Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

Re: need help in searching arrayrefs

by cchampion (Curate)
on Feb 13, 2004 at 01:48 UTC ( #328706=note: print w/replies, xml ) Need Help??


in reply to need help in searching arrayrefs

There are three things that I noticed and maybe they could make a difference:

  • selectcol_arrayref and selectall_arrayref return an array reference. You are assigning their return value to an array
  • After you assign to @row the value of a fetch, you assign something else, without using that result. Moreover, your second "my @row" declaration will hide the first one. If you use warnings, it will tell you straight away.
  • You are using "select max(word_id)" to get a count. This will work as long as you don't delete any record in your table. You should use "COUNT(*)" instead.

I don't know if these items are responsible for what you are complaining about, but surely they look suspicious.

HTH

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://328706]
help
Chatterbox?
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (7)
As of 2017-10-18 10:16 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    My fridge is mostly full of:

















    Results (244 votes). Check out past polls.

    Notices?