Re: DBI reports too many bind variables

This is the culprit:

my @player_rec = split '|';
[download]

If you add a print join ":", @player_rec; in there you'll see that it split up every single character -- this is because the pipe is treated as a special regex character (behaves like OR), so if you truly need a pipe (as in this case), it just simply needs to be escaped:

my @player_rec = split '\|';
[download]

Comment on Re: DBI reports too many bind variables Select or Download Code

Replies are listed 'Best First'.
Re^2: DBI reports too many bind variables by Juerd (Abbot) on May 24, 2005 at 17:55 UTC
my @player_rec = split '\\|'; Although that fixes the problem, it's still bad style to write a regex as a string. Use `/\\|/` instead of `'\\|'` here. Note that `split / /` and `split ' '` in fact ARE different! Juerd # { site => 'juerd.nl', plp_site => 'plp.juerd.nl', do_not_use => 'spamtrap' }	[reply] [d/l] [select]
Re^3: DBI reports too many bind variables by davidrw (Prior) on May 24, 2005 at 18:06 UTC
ah. yes -- thanks for explicitly noting that (i actually had `/\\|/` in my head but that part got lost somewhere between brain and fingertips..) -- it definitely is an important disctinction (if anyone reading this doesn't know the difference please read `preldoc -f split` carefully--it's well worth the read).	[reply] [d/l] [select]