Hi,
I hope someone can help me with my problem, something that has come up when moving code and DB to a new server:

Connection:
driver={MySQL ODBC 3.51 DRIVER};server=localhost;uid=xxxxxxxxxx;pwd=xxxxxxxxxx;database=xxxxxxxxxx;option=16387

SQL:
SELECT (sum_score/sum_votes) AS 'score' FROM xxxxxxxxxx WHERE id = xxxxxxxxxx

Value of "score":
6.2153

ASP:
<%=int(RS("score")*25)-20%>

Error:
Microsoft VBScript runtime (0x800A000D)
Type mismatch

Any help appreciated, I did not have this problem when I had the same set-up but on a server running an earlier version of MySQL and the ODBC driver.
--
David Scott

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to