I work with an app the embeds IE in a control on a form. The app includes HTML templates that query a local (LAN) MS SQL database and posts the results to the page in the IE control. The HTML template has some special tags that the app intercepts to make the SQL queries then the app inserts the query results in an output static HTML file. This generated HTML file is what is actually displayed in the IE control.
I know I can embed some javascript in the static HTML by referencing it in the original HTML template. It is just passed through untouched to the generated HTML file where it works like normal. You can use it to do things like expand/collapse a section.
So finally, this is what I would like to know. I want to embed some javascript/jQuery that will directly query the SQL DB so I can enhance what can be displayed in the generated HTML file beyond what the app can do by default. So for example suppose I wanted to show columns from multiple records. The app won't let me do that. Can I use javascript/jQuery to query the DB and display the results directly? As I understand it javascript/jQuery want to talk to a web service, AJAX or PHP module on a server. The server component is what actually communicates with the SQL DB and passes messages back to the javascript/jQuery code on the client. I'm wondering if there is any way to make the client side javascript/jQuery code talk to the SQL DB directly?
Sorry for the long winded explanation. And I'm sorry if this is just obviously a dumb question. Newbie remember? :)