MySQL/Perl losing data in database table
|
Original Message
|
Name: DrSeuss
Date: June 19, 2002 at 08:18:40 Pacific
Subject: MySQL/Perl losing data in database table
|
Comment: Running MySQL 3.23 on RedHat 7.2 with Perl script using DBI, wrapped in HTML doc. Background: My script queries the DB, does some calculations on the data, stores the results in a 2D array, and passes the array to a sub. The sub creates a table in the DB and loads the data from the array into the table. PROBLEM: All of the rows aren't being loaded into the table - some of them are excluded. Things that I have verified: - The array is intact once inside the sub - The datatypes in the created table match the datatypes in the array in type, size, and position - The raw data in the database table is actually missing the rows (it isn't an output problem) - Two specific columns in the array are causing the data not to load. If I place a constant in these two columns, all rows are loaded into the table. - The two columns that seem to be causing the problem load into a table without any loss of rows when loaded directly from MySQL cmd line (outside of the script). This indicates that the original data checks OK. - If I pass the array out of the sub without loading it into the table, it is still intact Has anyone seen this problem before or does anyone have any suggestions? Email me. Thanks.
Report Offensive Message For Removal
|
Use following form to reply to current message: