Select problem with BigInt

2004-03-09 Thread Randall Cayford
workaround it messes up my data accesses. Is there something special about bigint that prevents range based selects from working they way I expect them to? This is using mysql 4.0.16 on Mac OS X 10.3 server. Randall Cayford Institute of Transportation Studies UC Berkeley -- MySQL General Mailing

empty tables return non-empty result sets

2004-03-09 Thread Randall Cayford
I am new to mysql so this may be an obvious mistake on my part... I am using JDBC to acess some mysql data tables. I am having trouble with the following code: Statement s; ResultSet rset; longcorrectedclock; s = conn.createStatement(); rset =