Thousands and decimal separator

[peterve]

Hi,

I'm building a small application (VB.Net 2003) that accesses a MySQL database.
When the client settings are set to , (comma) as decimal separator and . (period) as thousands separator (which is common in Europe), the application returns data.
When using . (period) as decimal separator and , (comma) as thousands separator, I'm not getting any results from my select queries
How can I make my application to work with both options ?

thanks

--------------------------------------------------------------------

http://kickme.to/dpsecurity

--------------------------------------------------------------------
How can I believe in God when just last week I got my tongue caught in the roller of an electric typewriter?
---------------------------------------------------------------------

 

[TonyGroves]

Are your queries producing any errors? Can you show us the text of the queries that are generated by your application?