Connecting Tech Pros Worldwide Help | Site Map

Decimal value gone AWOL in ASP when MySQL updated!

  #1  
Old February 15th, 2008, 12:35 PM
Laphan
Guest
 
Posts: n/a
Hi All

My ASP driven site has always used MySQL as the DB backbone, mainly as the
hosting costs of MySQL are far cheaper than SQL Server at the mo, and it has
worked fine until my ISP thought that they were doing everybody a favour by
upgrading to v5 from v4.

What happens now is that any ASP query that I do that involves any of my
MySQL Decimal data type fields goes belly up. It will not work.

Looks to be an issue with ASP, MyODBC and MySQL, but I just wanted to check
if there was a better/more reliable data type than Decimal (which obviously
performs the same numerical functions) and if there was a quick way to
convert all of my Decimal fields to this new type.

Thanks



Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
Decimal value gone AWOL in ASP when MySQL updated! Laphan answers 1 February 15th, 2008 01:15 PM