Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Posts
    9

    Unanswered: Problem displaying text datatype from ASP

    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!

  2. #2
    Join Date
    Apr 2003
    Posts
    9

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •