Hi,

I have problems to export to excel a recordset (in a table) with more than 6 columns.
if there are more than 6 columns the excel file is empty.

I have another problem as well, i can't have more than 500 lines in the excel (or pdf file) even if the recordset (table) is bigger.

Any idea ?

Thanks a lot

I had the same problem, though I could receive up to 800-900 records successfully. More than 900 results in a blank excel sheet.
So I tried to put the following two lines of code above the UDE script on the page:
set_time_limit(0);
ini_set('memory_limit','-1');

Then I could receive thousands of records, so it seems that UDE reaches a timeout which breaks the data transfer. And most probably due to the server resources.

This is absolutely something DMXZone should take a closer look at. I have been reporting this "bug" earlier, and there was no solution to it.
Maybe this can help them finding a solution to it, so we don't have to compromise the server's security in order to have the scripts to work.

Edited by - Dan Ove Tuven on 10 Mar 2011  13:55:10