Professional Web Applications Themes

BUG: QA results in grid - Microsoft SQL / MS SQL Server

QA grid internally is using CHAR(1) to separate column values but does not escape it if it comes from the query results. columns shifting is demonstarted with this query: SELECT 'z' + CHAR(1) + 'z' + CHAR(1) + 'z' AS A , 'B' AS B , 'C' AS C , 'D' AS D , 'E' AS E , 'F' AS F QA Help->About version here is 8.0.760. can anyone can confirm this one? cheers, </wqw>...

  1. #1

    Default BUG: QA results in grid

    QA grid internally is using CHAR(1) to separate column values but does not
    escape it if it comes from the query results. columns shifting is
    demonstarted with this query:

    SELECT 'z' + CHAR(1) + 'z' + CHAR(1) + 'z' AS A
    , 'B' AS B
    , 'C' AS C
    , 'D' AS D
    , 'E' AS E
    , 'F' AS F

    QA Help->About version here is 8.0.760.

    can anyone can confirm this one?

    cheers,
    </wqw>


    Vlad Guest

  2. #2

    Default Re: QA results in grid

    Interesting ...It works like this even on SP3a+ version ...

    It comes correctly on a text output ...

    But the query below comes just fine ...
    SELECT 'z' + SPACE(1) + 'z' + SPACE(1) + 'z' AS A
    , 'B' AS [B]
    , 'C' AS C
    , 'D' AS D

    --
    HTH,
    Vinod Kumar
    MCSE, DBA, MCAD
    www.extremeexperts.com


    "Vlad Vissoultchev" <myrealbox.com> wrote in message
    news:phx.gbl... 


    Vinodk Guest

  3. #3

    Default Re: BUG: QA results in grid

    Vlad,

    I believe this is a known bug. I don't see a Knowledge Base article
    about it, and will pass on to Microsoft a request to add one. It's only
    a display issue, and if your string data contains non-printing
    characters, you can at least see what's there by converting the string
    to binary or varbinary for grid dispaly:

    select cast('z' + char(1) + 'z' as varbinary(20)) as A, ...

    -- Steve Kass
    -- Drew University
    -- Ref: 91A795D7-E8B7-4C31-BCF9-81CF4A416B3F

    Vlad Vissoultchev wrote:
     

    Steve Guest

Similar Threads

  1. Replies: 3
    Last Post: June 6th, 10:56 AM
  2. Query results don't display properly in results table.IGNORE PREVIOUS
    By JoyRose in forum Coldfusion - Advanced Techniques
    Replies: 1
    Last Post: March 24th, 07:28 PM
  3. How to edit records in a grid that's within a grid
    By Iams in forum ASP.NET Data Grid Control
    Replies: 0
    Last Post: March 17th, 06:41 PM
  4. Replies: 3
    Last Post: July 17th, 11:58 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139