I am working on a school project. I know that Web Services may not be the _best_ way to do this, but this is what I chose for the project. The simple idea is to create a web service that dumps data from a database, then use the MS ToolKit 3.0 in a simple client app using WSH to display the data.
Does anyone know where I can find code (or a book) that would demonstrate the following: --- Problem 1 --- AXIS: Create generic webservice that creates a resultset object, populates it with three rows of int, date, String data. Have the web service method called something like getData() and generate a result that can be seen from the browser such as: http://localhost:8080/axis/services/InteropExampleWS?method=getData Which would return: <?xml version="1.0" encoding="UTF-8" ?> <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <soapenv:Body> <getXMLResponse xmlns=""> <getXMLReturn> <ROWSET> <ROW num="0"> <sampleint>1</sampleint> <sampledate>10/01/2004</sampledate> <samplestring>This is a String.</samplestring> </ROW> <ROW num="1"> <sampleint>2</sampleint> <sampledate>10/02/2004</sampledate> <samplestring>This is a String.</samplestring> </ROW> <ROW num="2"> <sampleint>3</sampleint> <sampledate>10/03/2004</sampledate> <samplestring>This is a String.</samplestring> </ROW> </ROWSET> </getXMLReturn> </getXMLResponse> </soapenv:Body> </soapenv:Envelope> Note: There probably needs to be some schema definition here that explains that there is an int, date and String type being passed. Any help would be appreciated! MS ToolKit 3.0: Sample code using WSH for example that would do something really simple to display the data. (This is using FoxPro syntax, but hopefully you get the idea.) oXML = CREATEOBJECT("Microsoft.XMLDOM") oXML.Async = .F. oXML.Load("http://localhost:8080/axis/services/InteropExampleWS?method=g etData") oRoot = oXML.DocumentElement ? oRoot.xml Is this so hard? If there is a book I could purchase that would demonstrate this, PLEASE, PLEASE, PLEASE let me know so I can go get it RIGHT NOW! --- Problem 2 --- Once the first part is done, the next question comes with lots of data. Basically, I want a web service that can dump several hundred thousand records that the MS Toolkit can retrieve and put into a recordset to display. What do I need to watchout for. Any sample code or books that explain this? Thanks, Ken Lee