Perl-Sensitive Sunglasses | |
PerlMonks |
Re: DB Update w/ Hashby ferrency (Deacon) |
on Sep 05, 2000 at 19:53 UTC ( [id://31132]=note: print w/replies, xml ) | Need Help?? |
I believe MySQL doesn't like to allow you to bind to column names.
Also, looping over multiple fields and executing one query for each is most likley going to be a huge performance loss. You'd probably be better off constructing one query, even if you need to prepare it every time. You might try something like this:
This uses interpolation instead of query binding. If you always specify your mysql columns in the same order, you could use binding instead:
Alan
In Section
Seekers of Perl Wisdom
|
|