Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    1

    Unanswered: SQLXML, complex types, and WSDL

    Hello -

    I've used SQLXML to generate WSDL from a sample stored procedure that returns customerID and contactName from the 'northwind' database based on a runtime-supplied parameter.

    However, the generated WSDL doesn't explicitly name the two columns (customerID and contactName) that the procedure returns. I've tried all of the possible combinations of 'row formatting; and 'output as' when configuring the virtual name. Instead, I get the following:

    - <xsd:element name="TestResponse">
    - <xsd:complexType>
    - <xsd:sequence>
    <xsd:element minOccurs="1" maxOccurs="1" name="RobTestResult" type="sqlresultstreamqlResultStream" />
    </xsd:sequence>
    </xsd:complexType>
    </xsd:element>

    To parse the results, I would have to cast the information correctly, which requires some hard-coding. Does anyone have any suggestions on how to force the WSDL file to correctly list out the individual elements in the result set?

    Many thanks!

    Robert

  2. #2
    Join Date
    Oct 2003
    Location
    Dallas
    Posts
    76

    ....

    cant you just...

    SELECT * FROM TABLE for xml auto, elements

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •