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
