Bug #17132 ASP related
Submitted: 5 Feb 2006 8:52 Modified: 6 Feb 2006 20:44
Reporter: Kobus Theron Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0 OS:Windows (Windows 2003)
Assigned to: CPU Architecture:Any

[5 Feb 2006 8:52] Kobus Theron
Description:
All queries containing numeric values should now be used with the TRIM option after upgrading from ver.4.

How to repeat:
Pull data into an ASP page from a table containing numerical values.
[5 Feb 2006 23:15] Hartmut Holzgraefe
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.
[6 Feb 2006 20:45] Kobus Theron
Instead of using 'Select * From Table' one must now specify 'Select TRIM(Numeric_Field1), Field2, TRIM(Numeric_Field3) From Table', otherwise the numeric data just wouldn't be displayed in the ASP pages.