Unfortunately, that's not readable. I only see the one row. Jeff
> > > On Tue, Oct 22, 2002 at 10:54:18AM -0400, Jeff Urlwin wrote: > > > > [FreeTDS] > > > > If you are using FreeTDS, then it's irrelavent what version of the ODBC > > driver is running on the server side. It's probably just a client side > > problem. > > > > What I suggest is: > > - determining which (if any) ODBC driver manager (i.e. > unixODBC) you are > > using. Try using isql or the driver manager's sql interface to > see if you > > have the same problem. It's likely you do. > > I don't, I'm afraid. > > Horribly messy output from isql follows: > > query = SELECT sc_item_code, sc_value FROM strand_content WHERE > sc_group_code = 'MUSIC_CONTENT' AND str_uniq_id = > '94F6C407-D567-11D6-A75A-00508BFCB09E' AND sc_index = 5 AND ( > (SC_ITEM_CODE = 'DURATION') OR (SC_ITEM_CODE = 'PERFORMER') ) > +---------------------+------------------------------------------- ---------------------------------------------------------------------------- ------------------------------------------------> -------------------------- ---------------------------------------- > -----------------------+ > | | > | > +---------------------+------------------------------------------- ---------------------------------------------------------------------------- ------------------------------------------------> -------------------------- ---------------------------------------- > -----------------------+ > | DURATION | > | > | PERFORMER | RICHARD G. MITCHELL > | > +---------------------+------------------------------------------- ---------------------------------------------------------------------------- ------------------------------------------------> -------------------------- ---------------------------------------- > -----------------------+ > 2 rows affected > SQL> > > and then: > > query = SELECT sc_item_code, sc_value FROM strand_content WHERE > sc_group_code = 'MUSIC_CONTENT' AND str_uniq_id = > '94F6C407-D567-11D6-A75A-00508BFCB09E' AND sc_index = 5 AND ( > (SC_ITEM_CODE = 'DURATION') OR (SC_ITEM_CODE = 'PERFORMER') ) ORDER BY > sc_item_code DESC > +---------------------+------------------------------------------- ---------------------------------------------------------------------------- ------------------------------------------------> -------------------------- ---------------------------------------- > -----------------------+ > | | > | > +---------------------+------------------------------------------- ---------------------------------------------------------------------------- ------------------------------------------------> -------------------------- ---------------------------------------- > -----------------------+ > | PERFORMER | RICHARD G. MITCHELL > | > | DURATION | > | > +---------------------+------------------------------------------- ---------------------------------------------------------------------------- ------------------------------------------------> -------------------------- ---------------------------------------- > -----------------------+ > 2 rows affected > SQL> > > > Cheers, > > > -- > dave thorn | [EMAIL PROTECTED] >
