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

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

MySQL/Perl losing data in database table

Reply to Message Icon

Name: DrSeuss
Date: June 19, 2002 at 08:18:40 Pacific
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.



Sponsored Link
Ads by Google

Response Number 1
Name: DrSeuss
Date: June 20, 2002 at 06:27:17 Pacific
Reply:

Nevermind. I found the problem...


0
Reply to Message Icon

Related Posts

See More


programming MS Word spell... MS Access Report Generati...



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Programming Forum Home


Sponsored links

Ads by Google


Results for: MySQL/Perl losing data in database table

Add Data in table via VB.Net?? www.computing.net/answers/programming/add-data-in-table-via-vbnet/12525.html

Data not saving in Database..| www.computing.net/answers/programming/data-not-saving-in-database/6521.html

How to write html code in perl? www.computing.net/answers/programming/how-to-write-html-code-in-perl/12668.html