Can i use SQL in Server side scripting

Can i use SQL in Server side scripting

SunilgoelSunilgoel Posts: 48Questions: 19Answers: 0
edited March 2017 in Priority support

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

Regards.
Sunil

Answers

  • allanallan Posts: 61,972Questions: 1Answers: 10,160 Site admin

    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

  • SunilgoelSunilgoel Posts: 48Questions: 19Answers: 0
    edited March 2017

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

    Regards.
    Sunil

  • SunilgoelSunilgoel Posts: 48Questions: 19Answers: 0

    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

  • allanallan Posts: 61,972Questions: 1Answers: 10,160 Site admin

    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

This discussion has been closed.