1 Reply Latest reply on Jun 14, 2006 10:45 AM by Newsgroup_User

    GRRR! 8.0.2 Causing Me Grief

    oraLinque
      I've been fighting the 8.0.2 upgrade for a day now and finally figured out what the problem is. I have ASP pages that hits a SQL Server database to display dynamic information. In my queries I have a request.querystring that grabs the month (numeric representation), and a default value set to get todays date minus seven days, and use only the month (i.e. June would be 6). The actual value for "default value" is datepart(month,(GETDATE()-7)), which today would be 6. It worked in 8.0.1, but is broken in 8.0.2. The error message displayed is:

      Error Type:
      ADODB.Command (0x800A0D5D)
      Application uses a value of the wrong type for the current operation.
      /server1/dev/test/Reports/DW_TEST.asp, line 19


      If I manually type this, "?mon=6", at the end of my url string in IE it works.

      Please help if you can.

      Thanks!

        • 1. Re: GRRR! 8.0.2 Causing Me Grief
          Level 7

          "oraLinque" <webforumsuser@macromedia.com> wrote in message
          news:e6pcq8$594$1@forums.macromedia.com...
          > I've been fighting the 8.0.2 upgrade for a day now and finally figured out
          > what
          > the problem is. I have ASP pages that hits a SQL Server database to
          > display
          > dynamic information. In my queries I have a request.querystring that grabs
          > the
          > month (numeric representation), and a default value set to get todays date
          > minus seven days, and use only the month (i.e. June would be 6). The
          > actual
          > value for "default value" is datepart(month,(GETDATE()-7)), which
          > today
          > would be 6. It worked in 8.0.1, but is broken in 8.0.2. The error message
          > displayed is:

          Can you post the code? The 8.0.2 broke most recordset functionality that is
          not the basic cookie-cutter SELECT statement.


          --
          --
          Tom Muck
          co-author Dreamweaver MX 2004: The Complete Reference
          http://www.tom-muck.com/

          Cartweaver Development Team
          http://www.cartweaver.com

          Extending Knowledge Daily
          http://www.communitymx.com/