mySQL insert rows are less than should be

[cd1168 0]

VINsRowUPload  goes from 0->300

 

#QuantityVINsUpload is 300 records (rows %vinScraped)  

 

%vinScraped list is a list of 300 rows

 

the code works fine, in debugger i see it go through where VINSRowUpload incrmenets .. data is inserted into mysql table, but only 64 of them .. i read on some other posts here about appending  .. it is hard to debug this anty ideas

 

 

 

loop while($comparison(#VINsRowUpload, "<", #QuantityVINsUpload)) {
    plugin command("DatabaseCommands.dll", "connect to database", "server=xxxx;uid=xxxx; pwd=xxx1; database=xxx; port=3306; pooling=false") {
        plugin command("DatabaseCommands.dll", "query", "INSERT INTO xxxxxxx(every) VALUE('{$list item(%vinScraped, #VINsRowUpload)}');")
    }
    increment(#VINsRowUpload)
}

Edited September 19, 2014 by cd1168

[arunner26 51]

cd1168,

 

Be sure when you add to your list %vinScraped that you go to  "ADVANCED" on the command that adds to the list and make sure that "DELETE DUPLICATES" is set to "DON'T DELETE" (It is "DELETE" by default).

It occurs to me that %vinScraped may only have 64 entries.

[cd1168 0]

hi thank you .. that was in fact correct and helped me

[arunner26 51]

cd1168

You are welcome, glad I could help.