Nov 19, 2010, 8:12 AM
Post #3 of 4
Ok...so I found my problem last night. Essentially it has nothing to do with DBI and from what I can tell, everything to do with the fact that my simple program was assigning the same keyed index to the database for sequential loops.
Re: [cms370] DBI do Command Used Recursively...not updating with new data in DB
[In reply to]
For instance, on each loop the DBI do command was executed twice. The index that was assigned to the database remained the same for each one of the do command calls, but the second variable was updated. Not sure what happened exactly, but the database must have been saying that it already has a record keyed at index "1" and was basically just making a copy of that data. After making sure that for each entry the index was updated sequentially for each do call, everything works perfectly and the data is going into the DB.