http://qs1969.pair.com?node_id=1183678


in reply to Re: DB search results using DBI...execute
in thread DB search results using DBI...execute

reviewed my code, and sure enough, that damn "\n" is there! now i feel REALLY dumb! lol - TYVM, huck, for pointing that out! i don't have a CLUE how i did that. Likely due to commenting, and modifications, and just missed it. now, i get a list of UID's, and not just a 3. Thank you, thank you, thank you. I think i can finally move onto the next stage. MOST appreciated, Sire.
  • Comment on Re^2: DB search results using DBI...execute

Replies are listed 'Best First'.
Re^3: DB search results using DBI...execute
by huck (Prior) on Mar 04, 2017 at 22:02 UTC

    Dont forget to fix the if ($#arr eq 1) { test too. its either if ($#arr eq 0) { or if (sclalar(@arr) eq 1) {

      wow. so many different ways to do things, makes it hard to keep track of which is right lol. ok. so, i changed it from $#arr to scalar(@arr) i'll have to rip through some 30,000 lines of code to fix that issue. do i have to use if (scalar(@arr) eq 1) or would if (@arr eq 1) work the same?

        if (@arr eq 1) does work the same, i just think  if (scalar(@arr) eq 1) is clearer, and i dont play golf

        if (scalar(@arr) == 1) might be cleaner/faster too, eq "causes" each side to get cast into char