Hi Rahul Torvi, and MySQL user group
>you can use perror 28 to see what does that error code mean > >Rahul T > >-----Original Message----- >From: Kittiphum Worachat [mailto:[EMAIL PROTECTED]] >Sent: Monday, May 13, 2002 10:50 AM >To: [EMAIL PROTECTED] >Subject: Error code 28 > > >Hello, mysql, > >In select field list if they have some field that field type is text or blob >and if I use group by some filed MySQL will generate "Got error 28 from >table handler" the query like this > >select a.f1,a.f2,a.f3,b.f1,b.f2 >from table_a as a,table_b as b >where a.f1=b.f1 >and a.f1='xxx' >group by b.f2 > >if f2.b if mediumtext I will got error 28 but when change type to varchar it >OK but I realy need mediumtext type how to solve this problem > > I found this error when use with MySQL verion 4.0.1 but with 3.23.49a it work find so that may be bug for 4.0.1 and again I still don't know what about code 28. Thanks. Kittiphum Worachat,M.T. www.hatyailab.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
