XP is just a number | |
PerlMonks |
Weird problem with Perl and MySQLby ido50 (Scribe) |
on Nov 21, 2004 at 21:16 UTC ( [id://409423]=perlquestion: print w/replies, xml ) | Need Help?? |
ido50 has asked for the wisdom of the Perl Monks concerning the following question:
Hi again! Well, I don't know whether this problem is related to Perl/DBD::mysql, mySQL itself, or just my program. Anyhow, here it is: I have a certain table in the database with a field called 'id' holding an "INTEGER NOT NULL". For some reason, when INSERTing a new entry to the table, the program/the database/perl will usually(!) ignore the value supplied for the 'id' field and insert some other (6 digit) number (It's always the same number). This will not happen every now and again, I have yet to find a certain pattern, and I don't think I will find one. No need to mention that I've double- and even triple-checked that the correct value is supplied to the statement handle. Thing is, and I don't know if it's abnormal or not, if I try to INSERT entries which have identical field values, except for the 'id' field, they will all be INSERTed with that same number as the id, and becuase all other fields are identical, the entry will be multiplied. My host runs FreeBSD, Perl version is 5.005_03 built for i386-freebsd, DBI version is 1.28, DBD::mysql version is 2.0416. Any suggestions? Thanks. ------------------------- Live fat, die young
Back to
Seekers of Perl Wisdom
|
|