Can jEditable plug-in work with multiple tables?

DanSchwartz

Can the jEditable plug-in for jQuery work with multiple tables, i.e., can it create records in multiple database tables through a single interface, or can it only work with one database table at a time?

allan

To confirm, this is posted in the Editor forum, but you mention jEditable. Editor ( http://editor.datatables.net ) does not use jEditable. Which one is it that you are looking for help with?

Allan

DanSchwartz

Allan,

Thanks for your replies. I guess I misspoke. The editor I'm looking at is the one you reference at http://editor.datatables.net/ . I have downloaded the trial version and am currently trying to figure out how to set it up. Am wondering if one can use it to view/edit/insert fields from multiple database tables, such through an updatable database view.

Dan

allan

I see what you mean, yes. I am actually working on revamping the PHP classes for Editor 1.2 at the moment to make multiple table support (joins) much easier than they currently are (although I'm not sure how much that will help you given your other thread asking about JSP?).

The server implementation that comes with Editor is never going to be everything to everyone - the client-side library is the main component of Editor, and the expectation is that the server implementations included with Editor will be enough to cover the majority of cases, but when starting to look at complex interactions with the database, there will need to be some programming done by the developer to interface Editor with their database schema.

As I mentioned in the other thread - the protocol Editor uses to communicate with the server is fully documented ( http://editor.datatables.net/server/ ) to allow anyone to implement a server-side environment that will support Editor, and the onPreSubmit and onSubmit methods can be used on the client-side to manipulate the data that is sent / received by Editor if required.

Allan

DanSchwartz

Okay, as I said in my other post, I'll have a look at it and decide whether its something I want to undertake right now. I may switch to PHP, but have been doing everything in JSP. I like having the full capabilties of Java, but PHP may be adequate for my current application.