<<<
Can you run the query from mysql interface?
>>>
Yes.
Todd
--
Todd Cary
Ariste Software
2200 D Street Extension
Petaluma, CA 94952
707-773-4523
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manu
ssage -
From: "Todd Cary" <[EMAIL PROTECTED]>
To: "Jay Blanchard" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, July 15, 2002 2:15 PM
Subject: Re: ODBC and TimeStamp
> Jay -
>
> Here is the table structure. If I include the MEM_Code fiel
Jay -
Here is the table structure. If I include the MEM_Code field, the ODBC SELECT
throws and exception, but I can understand that since CHAR is usually a one
character field. The MEM_Change_Date field is another story. When it is
included, the result is empty. Strange?!?
Todd
#
# Table st
[snip]
I have the following Sql SELECT statement:
SELECT FirstName, LastName, ChangeTime FROM Members;
If I execute the statement using ADO (uses a ODBC connection), the result
set is
empty. When the ChangeTime is removed, I get a result set.
[/snip]
Can you show us a DESCRIBE TABLE for Member
Patrick -
I have the following Sql SELECT statement:
SELECT FirstName, LastName, ChangeTime FROM Members;
If I execute the statement using ADO (uses a ODBC connection), the result set is
empty. When the ChangeTime is removed, I get a result set.
Todd
--
Todd Cary
Ariste Software
2200 D Stree
What error? What schema?
Try TIMESTAMP(14)
Pat...
- Original Message -
From: "Todd Cary" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, July 14, 2002 11:31 PM
Subject: ODBC and TimeStamp
> I have a MySQL TimeStamp in my table. If I try to do a
I have a MySQL TimeStamp in my table. If I try to do a query via ODBC, I get an
error on the field.
Any suggestions?
Todd
--
Todd Cary
Ariste Software
2200 D Street Extension
Petaluma, CA 94952
707-773-4523
[EMAIL PROTECTED]
--
