SitePoint Sponsor

User Tag List

Results 1 to 1 of 1
  1. #1
    SitePoint Member
    Join Date
    Apr 2005
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    ASP/Mysql empty text field query error

    I'm getting an error when I'm retreaving from a "text field" in the database and it has no data in it. I'm using MYSQL version 3.23.58-nt. I have the same script running a different system and I don't get this error. It justs output nothing and continues with the loop.
    This has to be an ASP problem when retrieving data from the database. I've change the Field for Message to "varchar(252)" vice "text" in the database and stoped giving me error. But I still need to use the type "text" in the database since my "Message" will be longer then 252 caracter.

    <%
    objConnGlobal.open
    set subjectlistRS = objConn.Execute("Select * from BBS where Topic='exemple'")
    If (subjectlistRS.bof and subjectlistRS.eof) then %>
    There are not Topic
    else
    <%
    subjectlistRS.MoveFirst
    Do While not subjectlistRS.EOF
    %>
    Message <%= subjectlistRS("Message")%>Originator <%= subjectlistRS("Originator")%>
    <%subjectListRS.MoveNext
    Loop
    objConnGlobal.close
    ........
    Last edited by Ma_Bel; Apr 18, 2005 at 09:17.


Bookmarks

Posting Permissions

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