Can i use SQL in Server side scripting

Sunilgoel

Hi Allan,
Can i use SQL where i can use "where" and "group by" clause .
if possible then please give me example.

Regards.
Sunil

allan

Hi Sunil,

The server-side processing libraries in Editor, and the demo script from DataTables, do not support GROUP BY I'm afraid.

However, the Editor libraries do support WHERE conditions.

Regards,
Allan

Sunilgoel

Hi Allan,
can you send me example in non-editor server-side processing where i can see how to use "where conditions"

Regards.
Sunil

Sunilgoel

Hi Allan,
I am waiting answer from you. I have two question.

I am using Non-editor mode of DataTables.

1. Can i use SQL script in server-side script.
2. if answer of Point 1 is NO then how can i use "where" clause.

Regards.
Sunil

allan

Hi Sunil,

The WHERE conditions documentation that I linked to above will work for both server-side processing and client-side processing. The Editor PHP libraries dynamically adapt for each case.

Allan