From: Jeff Snoxell <[EMAIL PROTECTED]>
> ...I'm using a map statement...
> ...through the quote system...
Short answer: Don't do that.
The longer answer:
# Prepare the SQL using 'bind' operators.
$sth = $MyDatabase->prepare(qq{
INSERT INTO MyTable
(col1, col2, col3)
VALUES
(?, ?, ?)
});
$sth->execute(@values);
None of the other silly quoting stuff we're talking about applies to what you are
doing. Just use bind variables and ALL of your problems will go away.
Hollar if you need a hand with this, it can be a bit strange the first time.
---
Rodney Broom
President, R.Broom Consulting
http://www.rbroom.com/
sql
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
