Re: floor/ceiling with myodbc

2001-08-04 Thread Sinisa Milivojevic
Kevin X Lin writes: > Hi there, > > I'm running into problems with functions "floor/ceiling" when I use > Visual Basic to talk to mySQL through myODBC. > > My code looks like this: > sSQL = "select floor(3.2)" > Set rs = MySQL_conn.Execute(sSQL) > > I got rs.eof = true after execution of the qu

floor/ceiling with myodbc

2001-08-03 Thread Kevin X Lin
Hi there, I'm running into problems with functions "floor/ceiling" when I use Visual Basic to talk to mySQL through myODBC. My code looks like this: sSQL = "select floor(3.2)" Set rs = MySQL_conn.Execute(sSQL) I got rs.eof = true after execution of the query. However the following codes works f