I can get CSV file and render a table just fine. I cannot get a database connection to the table I would like to render. I ran the sample format and it did work so I know the connection is good. It might be the structure of the table. A few of the columns contain HTML code to render a link in the cells. Could that be throwing Datatables off? Szakitable works just fine in MySQL call, renders with links and all. I was going to rewrite the Szakitable plugin to call datapager.js, the lag on load it too long and that plugin doesn't seem to like the WHERE clause in the sql call. I need to parse the data down into smaller sections to call so the load time decreases and the table isn't 1800 rows long.

Scratching my head at what the problem could be and why the sql plugin won't work with this table. Need some help, almost 1800 rows of data with 7 columns, which could more than double in the next few months and we need a solution.

Thanks
Tom

Hello,

What plugin code do you use and what exactly doesn't work? Do you see a blank page or something another?

Regards,
ARI Soft

I figured out the SQL query had non break space encoding in the query. Which was odd because I was cutting and pasting from Notepad. I turned off the editor and took a look. This is what was in the query...the odd '&nbsp'

The &nbsp were throwing off the query. As soon as I removed them, all was well.