FreeTDS Development Group

["Thompson, Bill D (London)" <bill_d_thompson AT ml.com>]

Hey Jim,

1) Has your program installed error/message handlers ?
   see documentation for the api calls dberrhandle() and dbmsghandle()
or see an example of their use in src/dblib/unittests/*.c

I suspect if you install error and message handlers, you'll get some
form of message which leads you to the problem.


2) I take it there IS data in the table that satisfies your query ?


Bill



-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Jim Kuzniar
Sent: 27 June 2005 16:12
To: freetds AT lists.ibiblio.org
Subject: [freetds] dblib datetime question


Hello all:
This is probably pretty simply but its got me stumped.
I can connect to an MS sequel server on windows 2K but
when I query

dbcmd(dbconn, "SELECT fieldname FROM tablename WHERE Date =
'yyyy-mm-dd'");
dbsqlexec(dbconn);
dbresults(dbconn); returns NO_MORE_ROWS


Please Help!
Thx


_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
--------------------------------------------------------

If you are not an intended recipient of this e-mail, please notify the 
sender, delete it and do not read, act upon, print, disclose, copy, retain or 
redistribute it. Click here for important additional terms relating to this 
e-mail.     http://www.ml.com/email_terms/
--------------------------------------------------------