[forte]

Hello gurus, i salute you!

Having a HUGE problem displaying text data type with Informix:

Some specs:
- Informix 9
- CLI Informix 3.30
- IIS/IIS .net

CODE: test.asp
CONN_STRING = "DSN=workdsn;"
Set Conn_Informix = Server.CreateObject("ADODB.Connection")
Conn_Informix.Open CONN_STRING

qwe1="select desc from texttabel"

Set rs1 = Server.CreateObject("ADODB.Recordset")
set rs1=Conn_Informix.Execute(qwe1)

while not rs1.eof
label = rs1.FIELDS("desc").value
response.write label & "OK"
rs1.movenext
wend

RESULT:
EMPTY page with a bunch of OKs

Q:
- how do i get the data displayed? Heard of the texttoclob thingy but how do i use it?
- Is this a CLI problem?
- am able to display the result from dbaccess .....
- tried the same query with SQL server with same data types. No problems!

PLEASE HELP!

[forte]

solved:
http://dbforums.com/showthread.php?p...57#post2745457