Ignited DataTables

[eluser]dobbler[/eluser]
Hi, thanks for everyone's work on this but I just can't get it working and it's driving me insane!

I just get "Loading..." on the table in the view but when I hit the listener I get this:

Code:

A PHP Error was encountered

Severity: Notice

Message: Undefined variable: sOrder

Filename: libraries/Datatables.php

Line Number: 143


A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '$sOrder $sLimit' at line 4

SELECT SQL_CALC_FOUND_ROWS EmailId, Subject, Added FROM $table $sWhere $sOrder $sLimit

It's weird, from the error it looks like the variables aren't being replaced. I've tried everything but can't seem to make any sense of it. I'm sure I'm missing something (like a decent brain..)

I can post any code you need but I really just copied the samples and altered the table & row variables.

CI version: 1.6.3 - (could be this??? - it's a huge critical app so have been reluctant to upgrade but think I may have to. Going to try it on 1.7.3 and see if it works now that I think of it..)

Any help would be greatly appreciated as I'm under pressure!

Thanks,

Rob.