Re^2: 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) {`	[reply] [d/l] [select]
Re^4: DB search results using DBI...execute by jamroll (Beadle) on Mar 04, 2017 at 22:19 UTC
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?	[reply] [d/l] [select]
Re^5: DB search results using DBI...execute by huck (Prior) on Mar 04, 2017 at 22:42 UTC
`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	[reply] [d/l] [select]