Server side processing custom query using Editor database drivers
Server side processing custom query using Editor database drivers
![technofreaks](https://secure.gravatar.com/avatar/a5cdc5212767ce8279763740c6a06b9f/?default=https%3A%2F%2Fvanillicon.com%2Fa5cdc5212767ce8279763740c6a06b9f_200.png&rating=g&size=120)
Need help in changing sql query, table name, column names
I am using code from Server-side processing example,
Need help in using oci drivers from Editor and to change query.
Change query according to table below.
Table name: product_records.
Fields:
ID,ProductName,ProductCode,Stock,StoreLoc,RecordDate
RecordDate is DateTime.
ID,ProductCode,Stock is numberic,
ProductName,StoreLoc text field (varchar).
Also tried using javascript Pipelining data to reduce Ajax calls for paging with Oracle backend from Datatables-Editor.
with php scripts staff-html.php and staff-view.php, these works with example database oracle.sql,
need to make changes for usising with different table.
Please advice..
Thank you
Suds.