Skip to Content.
Sympa Menu

freetds - Re: [freetds] dblib datetime question

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Thompson, Bill D (London)" <bill_d_thompson AT ml.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] dblib datetime question
  • Date: Tue, 28 Jun 2005 13:35:58 +0100

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/
--------------------------------------------------------




Archive powered by MHonArc 2.6.24.

Top of Page