Hi,
I've written a Perl script to populate my MySQL table. It grabs values from
my old database and uses the following for each to form a comma separated
list of single quoted items...
Each of the @values items is passed through: $value =
$db->quote($original_value) first.
$st = $db->prepare('INSERT INTO Enquiries VALUES (' . join(",",@values) .
')' )
|| print 'could not prepare: ' . $db->errstr;
$st->execute() || print "Couldn't execute statement: " . $st->errstr;
This works fine for _most_ of the fields but strangely, entire columns are
incorrect sometimes. Especially where I'm sending UCT (10-digit unsigned
ints) values to an unsigned int field. These work OK for some of my
coulmns/fields but not for others.
Any clues as to what I'm doing wrong?
Many thanks,
Jeff
---------------------------------------------------------------------
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