Hi Steve If you use Oracle APEX (http://www.oracle.com/technology/products/ database/application_express/index.html) you already have half of the work done. Take a look at a small tutorial I done at http://docs.google.com/Doc?id=djhq5bc_0gbvc74fr and see if it suits you. Oracle APEX comes free with the database, and works in any platform.
/RB/ On Oct 22, 4:17 pm, Edward Benson <[EMAIL PROTECTED]> wrote: > Steve, > > The rough outline of the script goes: > > 1) Authenticate / do data validation > 2) Perform Oracle Query > 3_init) Start writing JSON doc > 3) Iterate over Oracle results, use each result to write out a snippit > of JSON to the returned document > 3_end) Finish up writing JSON doc > > Without any more information, it is tough to decompose that further > without actually using the specifics of your particular schema, etc. > > On Oct 22, 2008, at 11:12 AM, Stephen Martino wrote: > > > Ed, Thanks for your input. > > > Has anyone out there put together such a script that I can use as a > > template? > > > thanks > > > Steve > > > On Wed, Oct 22, 2008 at 10:07 AM, Edward Benson <[EMAIL PROTECTED]> wrote: > > > Steve, > > > You can use any data source you want as long as the client eventually > > receives that data in an Exhibit-compatible format. Many people > > manually maintain small static JSON files to contain their exhibit > > data, but there is nothing preventing you from having a URL that > > points to a script that will dynamically construct a JSON file based > > on a query to Oracle or any data source. > > > So instead your data source being > > >http://example.org/some_static_file.js > > > It would be something like > > >http://example.org/some_dynamic_script.php > > > That, when accessed, queries Oracle and returns the results in a JSON > > structure that Exhibit can read in (Exhibit can read more than just > > JSON, so you have your choice as to which of these formats is most > > convenient for you). > > > Is this what you were asking? > > Ted > > > On Oct 22, 2008, at 9:55 AM, Steve wrote: > > > > To all, > > > > Does anyone know if you can use Oracle (specifically Oracle 11g) > > as a > > > source for Exhibit? > > > > thanks > > > > Steve > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "SIMILE Widgets" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/simile-widgets?hl=en -~----------~----~----~----~------~----~------~--~---
