hello,
this is presumably such a dull newbie question but i
did consult several manuals and couldn't find it:
When trying to import xml data into MySQL via a perl
script, i encounter the problem that the data is
written into the value fields when VARCHAR is choosen,
but not when TEXT is chosen: (MEMO) appears as field
content instead of the data.
What works:
CREATE TABLE IF NOT EXISTS $ARGV[1] (identifier
VARCHAR(255), value VARCHAR(255)) "
What doesn't work:
CREATE TABLE IF NOT EXISTS $ARGV[1] (identifier
VARCHAR(255), value TEXT) "
The table and date is then written with:
foreach my $row ($nodelist->get_nodelist ())
{
$dbh-> do (
"INSERT INTO livertox (identifier, value) VALUES
(?,?)",
undef,
$row->find ("identifier")->string_value (),
$row->find ("value")->string_value ()
);
}
So - what is wrong ??
Any help on this greatly appreciated
Holger
Any suggestions ??
Thanks a lot
Holger
___________________________________________________
The ALL NEW CS2000 from CompuServe
Better! Faster! More Powerful!
250 FREE hours! Sign-on Now!
http://www.compuserve.com/trycsrv/cs2000/webmail/
---------------------------------------------------------------------
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
