Description:
When i try to print a "binary" value using the object "response.write" and concatenate a string value, i receive an error:
"Microsoft VBScript runtime error '800a000d'
Type mismatch
The instruction with error:
<%
Response.Write rs(1) & " Chupa-Cabras"
%>
The instruction without error:
<%
Response.Write rs(1)
%>
I try to using a another driver and i getting successful with 3.51.12 version using the same code. So I think this is a kind of bug, someone already had this problem ?
Thanks =D
Dayvison Pellegrina
How to repeat:
The example code:
<%
Set con = Server.CreateObject("ADODB.Connection")
con.open "Driver={MySQL ODBC 3.51 Driver}; (...) "
set rs = con.execute("SELECT NTeste, Teste FROM Teste")
While not rs.eof
response.write rs("NTeste") & "<br>"
response.write " - "
response.write rs("Teste") & "<br>"
response.write "<br>"
rs.movenext
wend
rs.close
con.close
Set rs= Nothing
Set con = Nothing
%>
The Database:
MySQl Version: 5.0.41
Table:
CREATE TABLE `Teste` (
`NTeste` int(11) NOT NULL,
`Teste` binary(1) NOT NULL default '0',
PRIMARY KEY (`NTeste`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
Data:
INSERT INTO `Teste` VALUES(1, '0');
Description: When i try to print a "binary" value using the object "response.write" and concatenate a string value, i receive an error: "Microsoft VBScript runtime error '800a000d' Type mismatch The instruction with error: <% Response.Write rs(1) & " Chupa-Cabras" %> The instruction without error: <% Response.Write rs(1) %> I try to using a another driver and i getting successful with 3.51.12 version using the same code. So I think this is a kind of bug, someone already had this problem ? Thanks =D Dayvison Pellegrina How to repeat: The example code: <% Set con = Server.CreateObject("ADODB.Connection") con.open "Driver={MySQL ODBC 3.51 Driver}; (...) " set rs = con.execute("SELECT NTeste, Teste FROM Teste") While not rs.eof response.write rs("NTeste") & "<br>" response.write " - " response.write rs("Teste") & "<br>" response.write "<br>" rs.movenext wend rs.close con.close Set rs= Nothing Set con = Nothing %> The Database: MySQl Version: 5.0.41 Table: CREATE TABLE `Teste` ( `NTeste` int(11) NOT NULL, `Teste` binary(1) NOT NULL default '0', PRIMARY KEY (`NTeste`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; Data: INSERT INTO `Teste` VALUES(1, '0');