6 messages in com.mysql.lists.dotnetRe: maybe an issue
FromSent OnAttachments
Jorge Bastos12 Jan 2005 13:15 
Ahmet Erispaha12 Jan 2005 13:27 
Jorge Bastos12 Jan 2005 13:32 
Jorge Bastos12 Jan 2005 13:43 
Reggie Burnett13 Jan 2005 05:04 
Jorge Bastos13 Jan 2005 14:21 
Subject:Re: maybe an issue
From:Jorge Bastos (mysq@decimal.pt)
Date:01/12/2005 01:43:07 PM
List:com.mysql.lists.dotnet

ya but... just consider the fact that with the old bytefx 0.76 i didn't had this problem :P

jorge

----- Original Message ----- From: "Bob Dankert" <bo@nvsn-it.com> To: "Jorge Bastos" <mysq@decimal.pt> Sent: Wednesday, January 12, 2005 9:41 PM Subject: RE: maybe an issue

If it's a bug/issue, it should be reported to bugs.mysql.com otherwise it may very easily be overlooked.

Bob

-----Original Message----- From: Jorge Bastos [mailto:mysq@decimal.pt] Sent: Wednesday, January 12, 2005 3:33 PM To: dot@lists.mysql.com Subject: Re: maybe an issue

Yes it's an way, i have other way to deal with it. At least for me i don't need the secunds u just do a left(fields,5) I just think reggie shoud know about it

jorge

----- Original Message ----- From: "Ahmet Erispaha" <ahme@comcast.net> To: "Jorge Bastos" <mysq@decimal.pt>; <dot@lists.mysql.com> Sent: Wednesday, January 12, 2005 9:27 PM Subject: Re: maybe an issue

Try using the MySQL function, TIME_FORMAT, in your query, for example:

SELECT TIME_FORMAT(hora,'%l:%i%p') FROM...

This will allow you to treat the returned value as a string.

----- Original Message ----- From: "Jorge Bastos" <mysq@decimal.pt> To: <dot@lists.mysql.com> Sent: Wednesday, January 12, 2005 4:15 PM Subject: maybe an issue

Reggie, this i think it could be an issue, or maybe not.

Is there any reason when i do a select from a table to a MySqlDataAdapter with the following structure.

+-----------------+--------------+------+-----+------------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+--------------+------+-----+------------+-------+ | cliente | varchar(255) | | PRI | | | | numero | int(10) | | PRI | 0 | | | data | date | | | 0000-00-00 | | | hora | time | | | 00:00:00 | | | pessoa_contacto | varchar(100) | | | | | | assunto | varchar(255) | | | | | | relatorio | text | | | | | +-----------------+--------------+------+-----+------------+-------+

The i get an error from the "hora" time field, like you see below: System.InvalidCastException: Cast from type 'TimeSpan' to type 'String' is not valid.

The error is not direcly from mysql.data.mysqlclient.mysqldataadapter but... is this ok? with the old bytefx 0.76 and older i never had this kind of problem.

jorge

-- MySQL on .NET Mailing List For list archives: http://lists.mysql.com/dotnet To unsubscribe: http://lists.mysql.com/dotnet?unsub=mysq@decimal.pt

-- MySQL on .NET Mailing List For list archives: http://lists.mysql.com/dotnet To unsubscribe: http://lists.mysql.com/dotnet?unsub=bo@nvsn-it.com