Re: Column Order Problem

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

From: William \(Bill\) Vaughn (billvaRemoveThis_at_nwlink.com)
Date: 08/06/04 

Date: Fri, 6 Aug 2004 15:37:59 -0700

For reasons that I discuss in my books, BLOB (TEXT, IMAGE) columns generally
have to appear last in the SELECT list... It's one of those things that
makes it better NOT to store BLOBs in the database... 

-- 
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Dave Fancher" <eijitek@comcast.net> wrote in message
news:dK-dnUPYhJmOZY_cRVn-vA@comcast.com...
> Here's one that I encountered today that just plain baffled me.
>
> I'm working on extending an existing ASP application.  One of the changes
> I'm working on required extending an existing query to retrieve some rows
> from a new table.  The query is written correctly and returns the correct
> results when executed in Query Analyzer.  I'm talking direct copy and
paste
> into query analyzer, no changes to the query whatsoever.  The problem I
> encountered is that I absolutely could not retrieve the value of one of
the
> new columns if I specified it after in certain places within the field
list.
>
> More specifically, the query selects data from approximately 27 columns
> including two text columns.  Where I was encountering the problem was when
I
> placed a varchar(5) column after either of the text columns or after the
> tinyint column immediately after the text columns.  What made this even
more
> mind-boggling is that the tinyint column worked just fine (I even
> temporarily replaced it with a constant value and aliased the column name
to
> check).  If I placed the varchar(5) column anywhere else in the field list
I
> was able to retrieve the value without any problem.
>
> Column order in my solution isn't really important and I got around this
by
> just changing the order of the columns but I was wondering if anyone has
> seen behavior like this before and could give me some insight.  This
problem
> isn't impeding my progress on the project but the problem is driving me
> crazy.  I appreciate any thoughts you have about this one.
>
> -- Dave
>
>

Relevant Pages

  • Re: Column Order Problem
    ... I understand the reasons for not using the BLOB data types but as I ... >> I'm working on required extending an existing query to retrieve some ... The query is written correctly and returns the ...
    (microsoft.public.data.ado)
  • Column Order Problem
    ... I'm working on extending an existing ASP application. ... I'm working on required extending an existing query to retrieve some rows ... Where I was encountering the problem was when I ...
    (microsoft.public.data.ado)
  • Re: On ADSI and LDAP
    ... the problem is how can I retrieve the value for myuser using the ... would be more efficient to use ADO to query AD for the attributes values. ... For more on using ADO, ... Dim adoCommand, adoConnection, strBase, strFilter, strAttributes ...
    (microsoft.public.scripting.vbscript)
  • Re: Internet class differences...
    ... The database and web interface to the server is produced by a different ... Initially a WebClient class was used. ... This worked fine for submitting the query. ... retrieve the results but, instead, is sent to a login page from which it ...
    (microsoft.public.dotnet.general)
  • Re: Returning only a subset of groups in AD
    ... Output.WriteLine "There are no members in this group." ... I assume that ADSICommand is an ADO command object, ... value assigned to the CommandText property, which is the ADO query. ... ' Comma delimited list of attribute values to retrieve. ...
    (microsoft.public.scripting.vbscript)