Hello Jens, DOMAIN is a 'not_reserved_key_word' and should not be used to designate DB-objects as mentioned in the manual. Maybe this causes your problems, so it would be a solution to rename the table (perhaps WEBDOMAIN ;)).
HTH & Kind regards > --- Ursprüngliche Nachricht --- > From: Jens-Peter C. HillersDate: September 8 2005 6:56pm > Subject: Prbleme mit ODBC > > Hello, > > I Have a table name named DOMAIN > I already inserted one row to it > > doing a select * from domain > odbc_num_rows retuns a -1 ! > > ALL other tables work well with the same sequence > > Could it be that DOMAIN is reserved by ODBC ? > ( by the way the only row in that table was inserted via ODBC ! ) > > any Idea or help ? > regards > jph > --------- > Environment: > > php 4.0 on a LINUX 9.3 machine > MaxDB 7.6.00.12 > > CREATE TABLE domain ( > domain varchar(255) NOT NULL default '', > description varchar(255) NOT NULL default '', > aliases integer NOT NULL default 0, > mailboxes integer NOT NULL default 0, > maxquota integer NOT NULL default 0, > transport varchar(255) default NULL, > backupmx smallint NOT NULL default 0, > created timestamp default TIMESTAMP, > modified timestamp default TIMESTAMP, > active smallint NOT NULL default 1, > Constraint domain_key Primary Key (domain) > ) > > ___________________________ > Dipl.-Ing. Jens-Peter C. Hillers > Remote Web Services GmbH > Tel: +49 40 25 49 06 22 > Fax: +49 40 36 00 67 27 > Email: [EMAIL PROTECTED] -- Lust, ein paar Euro nebenbei zu verdienen? Ohne Kosten, ohne Risiko! Satte Provisionen für GMX Partner: http://www.gmx.net/de/go/partner -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
