Thank you, Nancy. One caution - Be sure to reassemble the URL's fully if they get broken by the email. The non-HTML content types can produce very confusing and/or very long output if the query parameters are mangled. In particular, limit=20 restricts the output to 20 records per page.
There is also a .xls variation (instead of .js or .xml in the examples) that can be used to load the data directly into a spreadsheet such as Excel or Gnumeric. This doesn't actually rely on a proprietary M$ format. The content is actually HTML, but the HTTP content-type is changed so that the user agent (browser) will handle it differently. I haven't used Excel in quite a while, so I don't know how it handles tables contained in other tables. Nancy wrote: >That is REALLY nice. I am going to delete my text file. It is useless >compared to this, Jim. Thanks! > >On Monday 01 May 2006 21:22, Jim Self wrote: >Thanks, >Here is another variation that returns the RPC's in a javascript object > format: > > http://vista.vmth.ucdavis.edu/query.js?dbfile=8994&index=Name&format=TEST4&limit=20 > > and another variation that produces xml: > > http://vista.vmth.ucdavis.edu/query.xml?dbfile=8994&index=Name&format=TEST4&limit=20 > >Gregory wrote: >>--- Jim Self <[EMAIL PROTECTED]> wrote: >>> This might help also, >> >> http://vista.vmth.ucdavis.edu/query?dbfile=REMOTE+PROCEDURE&format=TEST2&index=Name >> >>> It is a live query into the Remote Procedure file on a test database. >> >>Very nice! It includes a hyperlink to the code implementing the RPC, >>too. (I tried DG PATIENT TREATMENT DATA, which has a pretty simple >> interface.) --------------------------------------- Jim Self Systems Architect, Lead Developer VMTH Computer Services, UC Davis (http://www.vmth.ucdavis.edu/us/jaself) --------------------------------------- M2Web Demonstration with VistA (http://vista.vmth.ucdavis.edu/) (http://openforum.worldvista.org/~forum/m.cgi) --------------------------------------- ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members
