Hi Steve, Briefly -- yes, you can do that, by setting up a Javascript function that takes that parameter from a control embedded in the page. Instead of passing the parameter to the server in the URL of the page, and setting up the SQL query that way, you can write a Javascript function that takes the value of a form element. For example, your users might see a drop-down box (a select form element) labeled "Country" next to a button labeled "Go". Let's say they select Canada. In the source code of the HTML page, you could use the "onClick" property of that button to call a Javascript function, that would get the value selected in the Country drop-down box -- Canada -- and run your query on the local database -- SELECT * FROM people WHERE country=Canada -- and then update the table with the results.
It would take a while to work out the exact code, but I hope this example illustrates what I'm talking about. Best wishes, Matt On May 25, 3:33 am, Steve Patrick <[email protected]> wrote: > Hi Matt, thanks a lot for your time and help > Now I use JavaScript to change HTML content of an existing pattern > page, but got a new issue... > in step 1 I show the result of the query and capture in a Goolge's > Resource Store an HTML file that I use as a pattern (its the page to > show the user when offline, got everithing but some dynamic info to be > updated). In step 5 I show captured pattern HTML file, query local > Gear's database and dynamically update the pattern HTML page with > required data. OK. > The problem now is that, as I know, this HTML page, that is not in a > server (its in user's local Resource Store) do not support parameters, > so the query to the local database that it has is not dynamic. > For example I can do this: > SELECT * FROM people > > but can not do this: > SELECT * FROM people WHERE country= X > > because X should be a parameter, different in every query and can´t > pass it to the HTML pattern page that is not in a server > > Is there any way to do that? > Thanks
