Results 1 to 21 of 21

Thread: [RESOLVED] Webservice - return multiple records from table

Threaded View

  1. #19

    Thread Starter
    Fanatic Member snufse's Avatar
    Join Date
    Jul 2004
    Location
    Jupiter, FL
    Posts
    912

    Re: Webservice - return multiple records from table

    This is the outpout I get

    <?xml version="1.0" encoding="utf-8" ?>
    <base64Binary xmlns="http://GetCustomerRecords.org/">PD94bWwgdmVyc2lvbj0iMS4wIj8+DQo8QXJyYXlPZk9yZGVySGVhZGVyIHhtbG5zOnhzaT0iaHR0cDovL3d3dy53My5vcmcvMj AwMS9YTUxTY2hlbWEtaW5zdGFuY2UiIHhtbG5zOnhzZD0iaHR0cDovL3d3dy53My5vcmcvMjAwMS9YTUxTY2hlbWEiPg0KICA8T3 JkZXJIZWFkZXI+DQogICAgPE9yZGVyQ29tcGFueT4wMDAwMDwvT3JkZXJDb21wYW55Pg0KICAgIDxPcmRlck51bWJlcj4xMDA8L0 9yZGVyTnVtYmVyPg0KICA8L09yZGVySGVhZGVyPg0KICA8T3JkZXJIZWFkZXI+DQogICAgPE9yZGVyQ29tcGFueT4wMDAwMDwvT3 JkZXJDb21wYW55Pg0KICAgIDxPcmRlck51bWJlcj4xMDE8L09yZGVyTnVtYmVyPg0KICA8L09yZGVySGVhZGVyPg0KICA8T3JkZX JIZWFkZXI+DQogICAgPE9yZGVyQ29tcGFueT4wMDAwMDwvT3JkZXJDb21wYW55Pg0KICAgIDxPcmRlck51bWJlcj4xMDE8L09yZG VyTnVtYmVyPg0KICA8L09yZGVySGVhZGVyPg0KICA8T3JkZXJIZWFkZXI+DQogICAgPE9yZGVyQ29tcGFueT4wMDAwMDwvT3JkZX JDb21wYW55Pg0KICAgIDxPcmRlck51bWJlcj4xMDM8L09yZGVyTnVtYmVyPg0KICA8L09yZGVySGVhZGVyPg0KICA8T3JkZXJIZW FkZXI+DQogICAgPE9yZGVyQ29tcGFueT4wMDAwMDwvT3JkZXJDb21wYW55Pg0KICAgIDxPcmRlck51bWJlcj4xMDQ8L09yZGVyTn VtYmVyPg0KICA8L09yZGVySGVhZGVyPg0KICA8T3JkZXJIZWFkZXI+DQogICAgPE9yZGVyQ29tcGFueT4wMDAwMDwvT3JkZXJDb2 1wYW55Pg0KICAgIDxPcmRlck51bWJlcj4xMDU8L09yZGVyTnVtYmVyPg0KICA8L09yZGVySGVhZGVyPg0KICA8T3JkZXJIZWFkZX I+DQogICAgPE9yZGVyQ29tcGFueT4wMDAwMDwvT3JkZXJDb21wYW55Pg0KICAgIDxPcmRlck51bWJlcj4xMjg8L09yZGVyTnVtYm VyPg0KICA8L09yZGVySGVhZGVyPg0KICA8T3JkZXJIZWFkZXI+DQogICAgPE9yZGVyQ29tcGFueT4wMDAwMDwvT3JkZXJDb21wYW 55Pg0KICAgIDxPcmRlck51bWJlcj4xMjk8L09yZGVyTnVtYmVyPg0KICA8L09yZGVySGVhZGVyPg0KICA8T3JkZXJIZWFkZXI+DQ ogICAgPE9yZGVyQ29tcGFueT4wMDAwMDwvT3JkZXJDb21wYW55Pg0KICAgIDxPcmRlck51bWJlcj4xODg0MTwvT3JkZXJOdW1iZX I+DQogIDwvT3JkZXJIZWFkZXI+DQogIDxPcmRlckhlYWRlcj4NCiAgICA8T3JkZXJDb21wYW55PjAwMDAwPC9PcmRlckNvbXBhbn k+DQogICAgPE9yZGVyTnVtYmVyPjE4ODUwPC9PcmRlck51bWJlcj4NCiAgPC9PcmRlckhlYWRlcj4NCiAgPE9yZGVySGVhZGVyPg 0KICAgIDxPcmRlckNvbXBhbnk+MDAwMDA8L09yZGVyQ29tcGFueT4NCiAgICA8T3JkZXJOdW1iZXI+MTg4Njg8L09yZGVyTnVtYm VyPg0KICA8L09yZGVySGVhZGVyPg0KICA8T3JkZXJIZWFkZXI+DQogICAgPE9yZGVyQ29tcGFueT4wMDAwMDwvT3JkZXJDb21wYW 55Pg0KICAgIDxPcmRlck51bWJlcj4xODg3NjwvT3JkZXJOdW1iZXI+DQogIDwvT3JkZXJIZWFkZXI+DQogIDxPcmRlckhlYWRlcj 4NCiAgICA8T3JkZXJDb21wYW55PjAwMDAwPC9PcmRlckNvbXBhbnk+DQogICAgPE9yZGVyTnVtYmVyPjE4ODkyPC9PcmRlck51bW Jlcj4NCiAgPC9PcmRlckhlYWRlcj4NCiAgPE9yZGVySGVhZGVyPg0KICAgIDxPcmRlckNvbXBhbnk+MDAwMDA8L09yZGVyQ29tcG FueT4NCiAgICA8T3JkZXJOdW1iZXI+MTg5MDU8L09yZGVyTnVtYmVyPg0KICA8L09yZGVySGVhZGVyPg0KICA8T3JkZXJIZWFkZX I+DQogICAgPE9yZGVyQ29tcGFueT4wMDAwMDwvT3JkZXJDb21wYW55Pg0KICAgIDxPcmRlck51bWJlcj4xODkxMzwvT3JkZXJOdW 1iZXI+DQogIDwvT3JkZXJIZWFkZXI+DQogIDxPcmRlckhlYWRlcj4NCiAgICA8T3JkZXJDb21wYW55PjAwMDAwPC9PcmRlckNvbX Bhbnk+DQogICAgPE9yZGVyTnVtYmVyPjE4OTMwPC9PcmRlck51bWJlcj4NCiAgPC9PcmRlckhlYWRlcj4NCiAgPE9yZGVySGVhZG VyPg0KICAgIDxPcmRlckNvbXBhbnk+MDAwMDA8L09yZGVyQ29tcGFueT4NCiAgICA8T3JkZXJOdW1iZXI+MTg5NDg8L09yZGVyTn VtYmVyPg0KICA8L09yZGVySGVhZGVyPg0KICA8T3JkZXJIZWFkZXI+DQogICAgPE9yZGVyQ29tcGFueT4wMDAwMDwvT3JkZXJDb2 1wYW55Pg0KICAgIDxPcmRlck51bWJlcj4xODk3MjwvT3JkZXJOdW1iZXI+DQogIDwvT3JkZXJIZWFkZXI+DQogIDxPcmRlckhlYW Rlcj4NCiAgICA8T3JkZXJDb21wYW55PjAwMDAwPC9PcmRlckNvbXBhbnk+DQogICAgPE9yZGVyTnVtYmVyPjE4OTk5PC9PcmRlck 51bWJlcj4NCiAgPC9PcmRlckhlYWRlcj4NCiAgPE9yZGVySGVhZGVyPg0KICAgIDxPcmRlckNvbXBhbnk+MDAwMDA8L09yZGVyQ2 9tcGFueT4NCiAgICA8T3JkZXJOdW1iZXI+MTkwNjA8L09yZGVyTnVtYmVyPg0KICA8L09yZGVySGVhZGVyPg0KICA8T3JkZXJIZW FkZXI+DQogICAgPE9yZGVyQ29tcGFueT4wMDAwMDwvT3JkZXJDb21wYW55Pg0KICAgIDxPcmRlck51bWJlcj4xOTA3ODwvT3JkZX JOdW1iZXI+DQogIDwvT3JkZXJIZWFkZXI+DQogIDxPcmRlckhlYWRlcj4NCiAgICA8T3JkZXJDb21wYW55PjAwMDAwPC9PcmRlck NvbXBhbnk+DQogICAgPE9yZGVyTnVtYmVyPjE5MDk0PC9PcmRlck51bWJlcj4NCiAgPC9PcmRlckhlYWRlcj4NCiAgPE9yZGVySG VhZGVyPg0KICAgIDxPcmRlckNvbXBhbnk+MDAwMDA8L09yZGVyQ29tcGFueT4NCiAgICA8T3JkZXJOdW1iZXI+MTkxMTU8L09yZG VyTnVtYmVyPg0KICA8L09yZGVySGVhZGVyPg0KICA8T3JkZXJIZWFkZXI+DQogICAgPE9yZGVyQ29tcGFueT4wMDAwMDwvT3JkZX JDb21wYW55Pg0KICAgIDxPcmRlck51bWJlcj4xOTEyMzwvT3JkZXJOdW1iZXI+DQogIDwvT3JkZXJIZWFkZXI+DQogIDxPcmRlck hlYWRlcj4NCiAgICA8T3JkZXJDb21wYW55PjAwMDAwPC9PcmRlckNvbXBhbnk+DQogICAgPE9yZGVyTnVtYmVyPjE5MTMxPC9Pcm Rlck51bWJlcj4NCiAgPC9PcmRlckhlYWRlcj4NCiAgPE9yZGVySGVhZGVyPg0KICAgIDxPcmRlckNvbXBhbnk+MDAwMDA8L09yZG VyQ29tcGFueT4NCiAgICA8T3JkZXJOdW1iZXI+MTkxNDA8L09yZGVyTnVtYmVyPg0KICA8L09yZGVySGVhZGVyPg0KICA8T3JkZX JIZWFkZXI+DQogICAgPE9yZGVyQ29tcGFueT4wMDAwMDwvT3JkZXJDb21wYW55Pg0KICAgIDxPcmRlck51bWJlcj4xOTE1ODwvT3 JkZXJOdW1iZXI+DQogIDwvT3JkZXJIZWFkZXI+DQogIDxPcmRlckhlYWRlcj4NCiAgICA8T3JkZXJDb21wYW55PjAwMDAwPC9Pcm RlckNvbXBhbnk+DQogICAgPE9yZGVyTnVtYmVyPjE5MjAzPC9PcmRlck51bWJlcj4NCiAgPC9PcmRlckhlYWRlcj4NCiAgPE9yZG VySGVhZGVyPg0KICAgIDxPcmRlckNvbXBhbnk+MDAwMDA8L09yZGVyQ29tcGFueT4NCiAgICA8T3JkZXJOdW1iZXI+MTkyMTE8L0 9yZGVyTnVtYmVyPg0KICA8L09yZGVySGVhZGVyPg0KICA8T3JkZXJIZWFkZXI+DQogICAgPE9yZGVyQ29tcGFueT4wMDAwMDwvT3 JkZXJDb21wYW55Pg0KICAgIDxPcmRlck51bWJlcj4xOTI0NjwvT3JkZXJOdW1iZXI+DQogIDwvT3JkZXJIZWFkZXI+DQogIDxPcm RlckhlYWRlcj4NCiAgICA8T3JkZXJDb21wYW55PjAwMDAwPC9PcmRlckNvbXBhbnk+DQogICAgPE9yZGVyTnVtYmVyPjE5MjU0PC 9PcmRlck51bWJlcj4NCiAgPC9PcmRlckhlYWRlcj4NCiAgPE9yZGVySGVhZGVyPg0KICAgIDxPcmRlckNvbXBhbnk+MDAwMDA8L0 9yZGVyQ29tcGFueT4NCiAgICA8T3JkZXJOdW1iZXI+MTkyNjI8L09yZGVyTnVtYmVyPg0KICA8L09yZGVySGVhZGVyPg0KICA8T3 JkZXJIZWFkZXI+DQogICAgPE9yZGVyQ29tcGFueT4wMDAwMDwvT3JkZXJDb21wYW55Pg0KICAgIDxPcmRlck51bWJlcj4xOTI3MT wvT3JkZXJOdW1iZXI+DQogIDwvT3JkZXJIZWFkZXI+DQogIDxPcmRlckhlYWRlcj4NCiAgICA8T3JkZXJDb21wYW55PjAwMDAwPC 9PcmRlckNvbXBhbnk+DQogICAgPE9yZGVyTnVtYmVyPjE5Mjg5PC9PcmRlck51bWJlcj4NCiAgPC9PcmRlckhlYWRlcj4NCiAgPE 9yZGVySGVhZGVyPg0KICAgIDxPcmRlckNvbXBhbnk+MDAwMDA8L09yZGVyQ29tcGFueT4NCiAgICA8T3JkZXJOdW1iZXI+MTkyOT c8L09yZGVyTnVtYmVyPg0KICA8L09yZGVySGVhZGVyPg0KICA8T3JkZXJIZWFkZXI+DQogICAgPE9yZGVyQ29tcGFueT4wMDAwMD wvT3JkZXJDb21wYW55Pg0KICAgIDxPcmRlck51bWJlcj4xOTMwMDwvT3JkZXJOdW1iZXI+DQogIDwvT3JkZXJIZWFkZXI+DQogID xPcmRlckhlYWRlcj4NCiAgICA8T3JkZXJDb21wYW55PjAwMDAwPC9PcmRlckNvbXBhbnk+DQogICAgPE9yZGVyTnVtYmVyPjE5Mz E4PC9PcmRlck51bWJlcj4NCiAgPC9PcmRlckhlYWRlcj4NCiAgPE9yZGVySGVhZGVyPg0KICAgIDxPcmRlckNvbXBhbnk+MDAwMD A8L09yZGVyQ29tcGFueT4NCiAgICA8T3JkZXJOdW1iZXI+ODU1NTU8L09yZGVyTnVtYmVyPg0KICA8L09yZGVySGVhZGVyPg0KIC A8T3JkZXJIZWFkZXI+DQogICAgPE9yZGVyQ29tcGFueT4wMDA2NDwvT3JkZXJDb21wYW55Pg0KICAgIDxPcmRlck51bWJlcj4xMT c2MjQ8L09yZGVyTnVtYmVyPg0KICA8L09yZGVySGVhZGVyPg0KICA8T3JkZXJIZWFkZXI+DQogICAgPE9yZGVyQ29tcGFueT4wMD A2NDwvT3JkZXJDb21wYW55Pg0KICAgIDxPcmRlck51bWJlcj4xMTc2MjU8L09yZGVyTnVtYmVyPg0KICA8L09yZGVySGVhZGVyPg 0KICA8T3JkZXJIZWFkZXI+DQogICAgPE9yZGVyQ29tcGFueT4wMDA2NDwvT3JkZXJDb21wYW55Pg0KICAgIDxPcmRlck51bWJlcj 4xMTc2MjY8L09yZGVyTnVtYmVyPg0KICA8L09yZGVySGVhZGVyPg0KICA8T3JkZXJIZWFkZXI+DQogICAgPE9yZGVyQ29tcGFueT 4wMDA2NDwvT3JkZXJDb21wYW55Pg0KICAgIDxPcmRlck51bWJlcj4xMTc2Mjc8L09yZGVyTnVtYmVyPg0KICA8L09yZGVySGVhZG VyPg0KICA8T3JkZXJIZWFkZXI+DQogICAgPE9yZGVyQ29tcGFueT4wMDA2NDwvT3JkZXJDb21wYW55Pg0KICAgIDxPcmRlck51bW Jlcj4xMTc2Mjg8L09yZGVyTnVtYmVyPg0KICA8L09yZGVySGVhZGVyPg0KICA8T3JkZXJIZWFkZXI+DQogICAgPE9yZGVyQ29tcG FueT4wMDA2NDwvT3JkZXJDb21wYW55Pg0KICAgIDxPcmRlck51bWJlcj4xMTc2Mjk8L09yZGVyTnVtYmVyPg0KICA8L09yZGVySG VhZGVyPg0KICA8T3JkZXJIZWFkZXI+DQogICAgPE9yZGVyQ29tcGFueT4wMDA2NzwvT3JkZXJDb21wYW55Pg0KICAgIDxPcmRlck 51bWJlcj4xMTc2MzA8L09yZGVyTnVtYmVyPg0KICA8L09yZGVySGVhZGVyPg0KICA8T3JkZXJIZWFkZXI+DQogICAgPE9yZGVyQ2 9tcGFueT4wMDA2NzwvT3JkZXJDb21wYW55Pg0KICAgIDxPcmRlck51bWJlcj4xMTc2MzE8L09yZGVyTnVtYmVyPg0KICA8L09yZG VySGVhZGVyPg0KICA8T3JkZXJIZWFkZXI+DQogICAgPE9yZGVyQ29tcGFueT4wMDA2NzwvT3JkZXJDb21wYW55Pg0KICAgIDxPcm Rlck51bWJlcj4xMTc2MzM8L09yZGVyTnVtYmVyPg0KICA8L09yZGVySGVhZGVyPg0KICA8T3JkZXJIZWFkZXI+DQogICAgPE9yZG VyQ29tcGFueT4wMDEwMDwvT3JkZXJDb21wYW55Pg0KICAgIDxPcmRlck51bWJlcj4xMTwvT3JkZXJOdW1iZXI+DQogIDwvT3JkZX JIZWFkZXI+DQogIDxPcmRlckhlYWRlcj4NCiAgICA8T3JkZXJDb21wYW55PjAwMTAwPC9PcmRlckNvbXBhbnk+DQogICAgPE9yZG VyTnVtYmVyPjEyPC9PcmRlck51bWJlcj4NCiAgPC9PcmRlckhlYWRlcj4NCiAgPE9yZGVySGVhZGVyPg0KICAgIDxPcmRlckNvbX Bhbnk+MDAxMDA8L09yZGVyQ29tcGFueT4NCiAgICA8T3JkZXJOdW1iZXI+MTAxPC9PcmRlck51bWJlcj4NCiAgPC9PcmRlckhlYW Rlcj4NCiAgPE9yZGVySGVhZGVyPg0KICAgIDxPcmRlckNvbXBhbnk+MDAxMDA8L09yZGVyQ29tcGFueT4NCiAgICA8T3JkZXJOdW 1iZXI+MTc3PC9PcmRlck51bWJlcj4NCiAgPC9PcmRlckhlYWRlcj4NCiAgPE9yZGVySGVhZGVyPg0KICAgIDxPcmRlckNvbXBhbn k+MDAxMDA8L09yZGVyQ29tcGFueT4NCiAgICA8T3JkZXJOdW1iZXI+MTc4PC9PcmRlck51bWJlcj4NCiAgPC9PcmRlckhlYWRlcj 4NCiAgPE9yZGVySGVhZGVyPg0KICAgIDxPcmRlckNvbXBhbnk+MDAxMDA8L09yZGVyQ29tcGFueT4NCiAgICA8T3JkZXJOdW1iZX I+MTc5PC9PcmRlck51bWJlcj4NCiAgPC9PcmRlckhlYWRlcj4NCiAgPE9yZGVySGVhZGVyPg0KICAgIDxPcmRlckNvbXBhbnk+MD AxMDA8L09yZGVyQ29tcGFueT4NCiAgICA8T3JkZXJOdW1iZXI+MTgwPC9PcmRlck51bWJlcj4NCiAgPC9PcmRlckhlYWRlcj4NCi AgPE9yZGVySGVhZGVyPg0KICAgIDxPcmRlckNvbXBhbnk+MDAxMDA8L09yZGVyQ29tcGFueT4NCiAgICA8T3JkZXJOdW1iZXI+MT g4MzwvT3JkZXJOdW1iZXI+DQogIDwvT3JkZXJIZWFkZXI+DQogIDxPcmRlckhlYWRlcj4NCiAgICA8T3JkZXJDb21wYW55PjAwMT AwPC9PcmRlckNvbXBhbnk+DQogICAgPE9yZGVyTnVtYmVyPjE4ODQ8L09yZGVyTnVtYmVyPg0KICA8L09yZ


    I am using:

    Code:
    <WebMethod()> _
        Public Function GetCustomerRecords_Serialized(ByVal myDateFrom As DateTime) As Byte() 'Return an array of bytes
    
            OpenConnection()
            GetRecords(myDateFrom)
            CloseConnection()
    
            Dim myMemorystream As System.IO.MemoryStream = GetSeriaLized() 'Returns the memorystream
    
            Return myMemorystream.ToArray() ' Return it as an array of bytes
    
        End Function
    The value of myOrders is correct:

    (1) = {GetCustomerOrderHeaders.OrderHeader}
    m_iAge = 100
    m_sName = "00000"
    SHDOCO = 100
    SHKCOO = "00000"
    Last edited by snufse; Aug 15th, 2011 at 12:19 PM.

Posting Permissions

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



Click Here to Expand Forum to Full Width