I have been working with databases for many years and MySQL for a few months, so I'm almost embarrassed to be asking this question :( I have searched the manual and Deja news and come up blank.
Live environment is MySQL 3.23.56 on Linux, test environment is 3.23.57 on WinXP.
I am using SELECT MAX(intSomeColumn) where intSomeColumn is a basic Integer data type. The data type of the result column is BigInt - which my ASP environment does not like very much. Changing the Unsigned and/or Auto_Increment attributes of intSomeColumn does not help. How can I do a CAST so that the result is an Integer, but without using CAST or CONVERT as they are not available in 3.23? I have come across the trick of doing MAX(intSomeColumn+0.0) to return a Double, but I would rather keep my Ints as Ints if I can.
I am aware of the 'Change BigInt columns to Int' option in the ODBC driver and this works fine for my test environment but I do not have access to these setting in my live environment.
Thanks for reading, Rhys
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
