Editor without Knex on NodeJS/Express/MySQL? (General question)

abarnes204

Hello all,

I am new to Datatables/Editor - I have successfully populated a datatable with data from NodeJS/Express/MySQL using AJAX and Express routing. It functions well but have not been able to implement Editor successfully.

The documentation I see for Editor relies on the knex npm module, which I am unfamiliar. I have tried and am able to pull data from the MySQL db with knex but I cannot generate the data in the table as I did with just the MySQL npm module, AJAX, and routing.

Is anyone using the mysql npm module on NodeJS+Express successfully with Editor? I am having difficulty in getting my server-side and client-side config going with Editor to utilize the CRUD operations.

Any general feedback and/or suggestions are appreciated

Thanks in advance

allan

You can certainly use Editor on the server-side without Knex, but the provided NodeJS libraries depend upon it, so you would need to write your own server-side CRUD code if you don't want to use Knex.

What errors (if any) are you getting from Knex?

Allan

abarnes204

I was able to figure out the configuration and get Editor to work, the problem was with my ajax options on the client side. Thank you for your response Allan