I believe the timestamp field needs to be nullable, but you shouldn't have any issue selecting a char. Can you run the query from mysql interface? If you can, than I would suspect that ADO is the culprit, try using straight ODBC instead.
I hope this helps... Pat... ----- Original Message ----- 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 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 structure for table 'MEMBERS' > # > > CREATE TABLE MEMBERS ( > MEM_NUM int(11) NOT NULL default '0', > MEM_LINK int(11) default NULL, > MEM_NAME varchar(70) default NULL, > MEM_FIRSTNAME varchar(30) default NULL, > MEM_LASTNAME varchar(30) default NULL, > MEM_SPOUSE varchar(30) default NULL, > MEM_CHILDREN varchar(70) default NULL, > MEM_ADDRESS1 varchar(30) default NULL, > MEM_CITY1 varchar(30) default NULL, > MEM_STATE1 varchar(30) default NULL, > MEM_ZIP1 varchar(10) default NULL, > MEM_PHONE1 varchar(14) default NULL, > MEM_ADDRESS2 varchar(30) default NULL, > MEM_CITY2 varchar(30) default NULL, > MEM_STATE2 varchar(30) default NULL, > MEM_ZIP2 varchar(10) default NULL, > MEM_PHONE2 varchar(14) default NULL, > MEM_CODE char(2) default NULL, <---- problem > MEM_CLASS int(11) default NULL, > MEM_BOATS varchar(70) default NULL, > MEM_INTERNET varchar(50) default NULL, > MEM_PW varchar(15) default NULL, > MEM_CHANGE_DATE timestamp(14) NOT NULL, <---- problem > MEM_UP_FNAME varchar(30) default NULL, > MEM_UP_LNAME varchar(30) default NULL, > MEM_PW_CHG char(1) default 'N', > PRIMARY KEY (MEM_NUM), > KEY IDX_MEM_FNAME (MEM_FIRSTNAME), > KEY IDX_MEM_LNAME (MEM_LASTNAME), > KEY IDX_MEM_NUM (MEM_NUM) > ) TYPE=MyISAM; > > > > Jay Blanchard wrote: > > > [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 Members? > > > > Thanks! > > > > Jay > > sql, mysql, query > > > > "Auntie Em: Hate you, hate Kansas, taking the dog." -Dorothy > > > > ************************************* > > * Want to meet other PHP developers * > > * in your area? Check out: * > > * http://php.meetup.com/ * > > * No developer is an island ... * > > ************************************* > > -- > Todd Cary > Ariste Software > 2200 D Street Extension > Petaluma, CA 94952 > 707-773-4523 > [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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
