Re: Mysql ODBC 8.0.17 / Classic ASP / Stored procedures returns always 0 instead of integer

[Mark Taylor]

You might want to check your data types in the tables that you are selecting to see if any of the columns in your queried tables match any of those dataTypes that I had mentioned. I only way this because I would imagine that the way Stored Procedures and Prepared Statements is similar The other thing to try that i discovered worked was in the query to CAST the INT column into a CHAR:

SELECT txtStr, CAST(intVal AS CHAR) AS intVal, textStr FROM `testDB`.`test`

and see if that helps return the expected values to your Stored Procedure request...


Mark