Re: Weird character causes statement with paramteters to fail - mike...@mygenerationsoftware.com - com.mysql.lists.dotnet

9 messages in com.mysql.lists.dotnetRe: Weird character causes statement ...

From	Sent On	Attachments
Andrew Preece	23 Aug 2005 08:31
mike...@mygenerationsoftware.com	23 Aug 2005 08:48
Patrick Bennett	23 Aug 2005 08:56
Reggie Burnett	29 Aug 2005 14:29
Andi [ Debug ]	29 Aug 2005 16:45
Patrick Bennett	29 Aug 2005 19:38
Reggie Burnett	30 Aug 2005 09:40
Jorge Bastos	30 Aug 2005 10:30
Patrick Bennett	30 Aug 2005 11:28

Subject:	Re: Weird character causes statement with paramteters to fail
From:	mike...@mygenerationsoftware.com (mike...@mygenerationsoftware.com)
Date:	08/23/2005 08:48:38 AM
List:	com.mysql.lists.dotnet

I believe this is a known problem, see this post in our forums: http://www.mygenerationsoftware.com/phpbb2/viewtopic.php?t=1335

We have a free MySql Architecture for .NET and others have ran into this very issue ...

Hey all, I've got a weird problem with statements failing to execute with an error. The statement is : UPDATE INV_Value SET Quantity = Quantity + 2 WHERE ID = 156 AND Type = 'ORD' ^ after the space, before the 2

The character shows up in the error as well as vs.net as one of the little un-renderable squares and is an 0x01 character.

The statement is generated with parameters, so I have no idea where it is coming from.

The statement that I send to the mysql helper is as follows UPDATE INV_Value SET Quantity = Quantity + ?qty WHERE ID = ?id AND Type = ?typ

The ?qty parameter is a decimal value. And it seems perfectly valid.

Any help would be greatly appreciated, Thanks, Andrew.