Bug #30818 isNULL empty Text fields
Submitted: 5 Sep 2007 8:17 Modified: 6 Sep 2007 10:54
Reporter: Oscar Tordera Email Updates:
Status: Duplicate Impact on me:
None 
Category:Connector / ODBC Severity:S2 (Serious)
Version:3.51.19 OS:Windows
Assigned to: CPU Architecture:Any

[5 Sep 2007 8:17] Oscar Tordera
Description:
i have an aplication running in Asp.vbscript and MySql and im having problems with the next code

Set Conn = Server.CreateObject("ADODB.Connection")
sConnection = "Driver={MySQL ODBC 3.51 Driver};" & "Server=...;uid=...;pwd=...;database=torres;option=3;"
Conn.Open(sConnection)

miApp="TDL"

set rslan = Server.CreateObject("ADODB.RecordSet")
sqllan = "SELECT * FROM " & miApp & "Descripcion WHERE Nombre like 'pie'"
rslan.Open sqllan,Conn

if not rslan.EOF then
	response.Write("antes " & len(rslan("Texto")) & " antes")
	response.Write("<br>IsNULL -> " & isNULL(rslan("Texto")) & "<br>")
	response.Write("despues " & len(rslan("Texto")) & " despues")
end if

the first response.write prints 351 and the last 0 the instruction isNULL seems to empty all Text fields of my recordset

How to repeat:
I think making a select of a text field printing a text field testing if IsNull and then printing the content again
[5 Sep 2007 11:43] Tonci Grgin
Hi Oscar and thanks for your report. You have stated two problems here:
 1) RecordSet persistance
 2) IFNULL testing
There are bug reports describing both problems already in BugsDB, I'll find them and see if they truly describe your case. In the meantime please post as much info as possible:
 - MyODBC version
 - MySQL server version
 - OS details
and attach
 - full self-contained test case (or add SQL script with all the data necessary for testing)
[5 Sep 2007 12:06] Oscar Tordera
Thanks Tonci and sorry for miss information.

MyOdbc version: 3.51.12 (tested too with 3.51.19)
MySql version: 5.0.18-nt
Os Windows 2003 Server R2 Standar Edition Service Pack1

I think thats all
[5 Sep 2007 12:06] Oscar Tordera
script with database

Attachment: torres.sql (application/octet-stream, text), 1.49 KiB.

[6 Sep 2007 9:44] Tonci Grgin
Oscar, this is a duplicate of Bug#28891 which is, in turn, duplicate of Bug#27458. Please see discussion there.
[6 Sep 2007 10:54] Oscar Tordera
Thanks Tonci, I make a mistake with my versions im so sorry.

MySQL 5.0.27-comunity-nt
ODBC 3.51.19
Os I suppose w2003 server (its a hosting company and i dont know exactly)

Excuse me for the mistake
[6 Sep 2007 11:19] Tonci Grgin
Oscar, no worries. Hope this will get fixed soon.

Thanks for your interest in MySQL.
[11 Sep 2007 15:37] Tonci Grgin
Oscar, new info posted in Bug#28891.