vb and variable types?

vb and variable types?

am 02.03.2005 13:36:53 von Mark Ogles

I'm running MySQL 4.1.10 and VB6 with the MySQL ODBC 3.51.11 Driver.

VB returns current date rather than timediff when query: "SELECT
TIMEDiff('10:09:15','10:12:14') as TD;" is used. Is there a work around
for this or am I doing something wrong?


--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 266.5.0 - Release Date: 2/25/2005


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: vb and variable types?

am 02.03.2005 16:06:04 von Mike Hillyer

Timediff will return a time, which is a datatype that VB does not
support. Try casting it to a string on the server side in your query and
you should get back something usable.

Mike

Mark Ogles wrote:
> I'm running MySQL 4.1.10 and VB6 with the MySQL ODBC 3.51.11 Driver.
>
> VB returns current date rather than timediff when query: "SELECT
> TIMEDiff('10:09:15','10:12:14') as TD;" is used. Is there a work around
> for this or am I doing something wrong?
>
>

--
Mike Hillyer, Technical Writer
MySQL AB, www.mysql.com
Office: +1 403-380-6535
Mobile: +1 403-330-0870

MySQL User Conference (Santa Clara CA, 18-21 April 2005)
Early registration until February 28: www.mysqluc.com

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org