Hi,
I am using DBI to add a column to my existing table, goodtable. W/ a
phpmyadmin I can add a column w/ a numeric or nonnumeric label. Using
perl DBI, I can only add a column w/ a nonnumeric label, as follows:
$dbh->do("ALTER TABLE goodtable ADD testname VARCHAR( 250 ) NULL");
-------->is a non-numeric column label and works fine.
However, changing "testname" to a number results in an error......
$dbh->do("ALTER TABLE goodtable ADD 546 VARCHAR( 250 ) NULL");
-------->is a numeric column label and throwsback the following
error:
DBD::mysql::db do failed: You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the right
syntax to use near '451 VARCHAR( 250 ) NULL'
Again, everything works fine doing it in a non-perl way. I've tried
using quotes, escape characters, $sql = $dbh->quote($value), etc.
(Obviously, I could do this in a web interface but this project
requires creating columns on the fly, so to speak, so I must use perl
for this.)
thx!
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/
