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]