2 Replies Latest reply on Nov 17, 2008 3:41 PM by webquorning

    Data type mismatch return error using HTTP service in Flex 3

    webquorning
      Hi all,

      I have a somewhat peculiar problem with the HTTP-service in Flex.
      I use it for sending a POST request to an external web server which returns an xml document to the application.
      The problem is that debugging the application using Firefox or Google Chrome, I get a strange error when I invoke the HTTPservice:


      <?xml version="1.0" encoding="iso-8859-1"?>
      <saveRating>
      <responseCode>1</responseCode>
      <responseTextEn>Rating NOT saved (ch:32|user:53|resp:379|score:4|). -2147217913: Data type mismatch in criteria expression.</responseTextEn>
      <responseTextDa>Score IKKE gemt. </responseTextDa>
      </saveRating>

      The actual content is really not that relevant, but the case is that I receive a "Data type mismatch in criteria expression" from the server (this error is really a database error from the external web server).

      The strange part is that I don't recive any error using the web service from a browser placed locally on the web server. Any ideas on this issue?


        • 1. Re: Data type mismatch return error using HTTP service in Flex 3
          Level 7

          "webquorning" <webforumsuser@macromedia.com> wrote in message
          news:gevkl3$hit$1@forums.macromedia.com...
          > Hi all,
          >
          > I have a somewhat peculiar problem with the HTTP-service in Flex.
          > I use it for sending a POST request to an external web server which
          > returns an
          > xml document to the application.
          > The problem is that debugging the application using Firefox or Google
          > Chrome,
          > I get a strange error when I invoke the HTTPservice:
          >
          >
          > <?xml version="1.0" encoding="iso-8859-1"?>
          > <saveRating>
          > <responseCode>1</responseCode>
          > <responseTextEn>Rating NOT saved (ch:32|user:53|resp:379|score:4|).
          > -2147217913: Data type mismatch in criteria expression.</responseTextEn>
          > <responseTextDa>Score IKKE gemt. </responseTextDa>
          > </saveRating>
          >
          > The actual content is really not that relevant, but the case is that I
          > receive
          > a "Data type mismatch in criteria expression" from the server (this error
          > is
          > really a database error from the external web server).
          >
          > The strange part is that I don't recive any error using the web service
          > from a
          > browser placed locally on the web server. Any ideas on this issue?

          Does this look relevant?
          http://flexdiary.blogspot.com/2007/07/flex-reorders-url-string-parameters.html


          • 2. Re: Data type mismatch return error using HTTP service in Flex 3
            webquorning Level 1
            Thank you for your reply. After a lot of debugging we found out that it acutally was the server that didn't convert the date correctly when saving a post to the DB. But thanks for your time.!