Computing.Net > Forums > Programming > MySQL/Perl losing data in database table

MySQL/Perl losing data in database table

Reply to Message Icon

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

Response Number 1
Name: DrSeuss
Date: June 20, 2002 at 06:27:17 Pacific
Subject: MySQL/Perl losing data in database table
Reply: (edit)

Nevermind. I found the problem...


Report Offensive Follow Up For Removal







Use following form to reply to current message:

   Name: From My Computing.Net Settings
 E-Mail: From My Computing.Net Settings

Subject: MySQL/Perl losing data in database table

Comments:

 


  Homepage URL (*): 
Homepage Title (*): 
         Image URL: 
 
Data Recovery Software