[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-odbc
Subject:    RE: Anyone know the c syntax for
From:       Venu <venu () mysql ! com>
Date:       2002-01-05 17:31:13
[Download RAW message or body]

Hi,

> -----Original Message-----
> From: Nick Gorham [mailto:nick@lurcher.org]
> Sent: Saturday, January 05, 2002 3:24 AM
> To: Devore, Jacob
> Cc: myodbc@lists.mysql.com
> Subject: Re: Anyone know the c syntax for
>
>
>
>
> "Devore, Jacob" wrote:
>
> > Do you know if there is an issue with getting it as a string?  For some
> > reason the odbc call doesn't fill in the data correctly.  Also, how do I
> > request the timestamp from the server so that it returns data in this
> > format?
> >
>
> There *should* be no issue, but venu would be the one to give the definitive
> answer. You should need to do nothing special to get it as a timestamp, just
> select tsfield from table, then do a SQLGetData with a dataype of SQL_C_CHAR.
> However if that doesn't work, there may be a problem somewhere.
>
> Thats what it *should* do anyway...

Actually it works as it "should" be. With SQL_C_CHAR or SQL_C_TIMESTAMP,
I could ale to fetch(SQLGetData) and or insert(SQLBindParameter) data
as expected.

Jacob, Can you cut and paste your 'C' code snippet, which is causing
the problem, so that we can see what is happening ..

Regards, Venu
--
For technical support contracts, go to https://order.mysql.com
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /   Mr. Venu <venu@mysql.com>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Developer
/_/  /_/\_, /___/\___\_\___/  California, USA
       <___/  www.mysql.com


---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail myodbc-thread4476@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail myodbc-unsubscribe@lists.mysql.com instead.

[prev in list] [next in list] [prev in thread] [next in thread]