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

Reply via email to