Re: ADO problem with MYSQL datetime column

2001-03-27 Thread Dennis Salguero 

- Original Message -
From: "Samantha Savvakis" [EMAIL PROTECTED]
To: "MySQL" [EMAIL PROTECTED]
Sent: Tuesday, March 27, 2001 12:39 AM
Subject: ADO problem with MYSQL datetime column


 I have a table that I'm querying that has 'datetime' columns. If these
 columns are null or 0 - "-00-00 00:00:00", I have problems reading
from
 the ADO recordset.

What kind of problems are you having specifically?

If you already have your data in an ADO recordset, then it is fairly simple
to "massage" the data in any way you want. Have you checked the field with
IsEmpty or IsNull? Using a conditional statement to check for null or empty
values should prevent these dates from passing through to your script.

 I was wondering if this is an ADO issue with the MYSQL column type of
 datetime, or perhaps an issue with the MyODBC driver and ADO ?

If the data is already in the recordset, and the values for the other fields
are correct, then I don't think that it would be an ODBC error. It might
just be a matter of using some further code to verify the data before you
use it in the rest of your scripts.

Good luck,

Dennis
**'
Beridney Computer Services
[EMAIL PROTECTED]
http://www.beridney.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

ADO problem with MYSQL datetime column

2001-03-26 Thread Samantha Savvakis 

Hi,

I'm using ADO with the MyODBC driver.

I have a table that I'm querying that has 'datetime' columns. If these
columns are null or 0 - "-00-00 00:00:00", I have problems reading from
the ADO recordset.

I have other columns - char, varchar, integer etc that are null and don't
have this problem. It only seems to be the datetime columns.

I was wondering if this is an ADO issue with the MYSQL column type of
datetime, or perhaps an issue with the MyODBC driver and ADO ?

Has anyone found a work around for this problem? The only work around I've
got is to actually format the field when I select it, but this creates an
issue for me when I'm trying to retrieve all columns from a table that has
100+ columns. I wanted to avoid having to type out all column names in the
query.

Thanks,
Sam


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php