I don't know whether this is a problem with mySQL or Zeos (freeware Delphi components), but I'll ask here: When I use 'count' in a one table query, Zeos defines the resulting field as TIntegerField. When I use 'count' in a two table query, the resulting field is TLargeIntField, which causes problems in my application.
It has been suggested to me to cast the result as an integer, but unfortunately 'cast' isn't present in the version of mySQL which I'm using (3.23.51 on Linux). Does anyone have any ideas how to ensure that the result is an integer? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]