Select statement returns duplicate data

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Mark (anonymous_at_discussions.microsoft.com)
Date: 09/23/04

  • Next message: Jon Paskett: "#DELETED displayed in all cells" 
    Date: Thu, 23 Sep 2004 07:36:12 -0700

    Not sure if this is the right forum, if not, please
    direct me.

    When I create a link to a SQL 2000 server database via
    Dreamweaver MX, for some reason on one account retrieved,
    it pulls up duplicate data. The other acounts appear
    fine.

    When a customer pulls up their account history, the query
    from Dreamweaver is suppose to pull up the last 12 months
    of data, and it does, but on this one account it pulls up
    12 responses, but only six months of data, each month
    being duplicated.

    If anyone has any ideas on this, please let me know.

    Thank you,

    Mark

  • Next message: Jon Paskett: "#DELETED displayed in all cells"

    Relevant Pages

    • Sequel query pulling up duplicate data
      ... Dreamweaver MX, for some reason on one account retrieved, ... it pulls up duplicate data. ... When a customer pulls up their account history, ...
      (microsoft.public.sqlserver.mseq)
    • Sequel query retrieves duplicate data
      ... Dreamweaver MX, for some reason on one account retrieved, ... it pulls up duplicate data. ... When a customer pulls up their account history, ...
      (microsoft.public.sqlserver.server)
    • Re: Select statement returns duplicate data
      ... Mostly likely something in the query - often with joining ... >Dreamweaver MX, for some reason on one account retrieved, ... >it pulls up duplicate data. ...
      (microsoft.public.sqlserver.connect)
    • VLOOKUP Problem
      ... I have a spreadsheet that pulls data from another sheet. ... General Ledger description for that account. ... I will go to my data file and do that TEXT TO COLUMNS deal again ...
      (microsoft.public.excel.setup)
    • Re: templating system
      ... > dreamweaver) and then pulls contents from python functions and ... > 'contexts' very nicely. ...
      (comp.lang.python)