Jump to content

Akasha

Members
  • Posts

    71
  • Joined

  • Last visited

About Akasha

  • Birthday 07/27/1983

Contact Methods

  • AIM
    wtf?
  • MSN
    Akasha
  • Website URL
    https://www.facebook.com/AkashaValo
  • ICQ
    0
  • Yahoo
    nope

Profile Information

  • Gender
    Male
  • Location
    Netherlands
  • Interests
    web design, Graphic Design, drawing, learning how to play the bass guitar, watching movies, listen to music, reading books, Art, having fun :) vampires

Akasha's Achievements

Newbie

Newbie (1/7)

0

Reputation

  1. Yes is an oracle database. Unfortunately not mine, so I’m not able to change the datatype. I will take a look at the articles thanks
  2. Yes, pretty sure. Here is the data from the database. The first query shows only a few characters, then i set long to 2000 and then you see all data. https://www.dropbox.com/s/hq899w71tzsg8bn/data.PNG Second is what asp is showing me. https://www.dropbox.com/s/ope3aehesg2roju/asp.PNG Maybe my query is wrong? set rs1 = Server.CreateObject("ADODB.recordset")rs1.Open "select tc.id_number, tc.x_cust_ref_num, tc.title as tct, tg.title as tcg, login_name, case_history from table_case tc, table_site ts, table_gbst_elm tg, table_user tu where (ts.objid = tc.case_reporter2site) and (ts.name like 'blabla%') and (tg.objid = tc.casests2gbst_elm) and (tu.objid = tc.case_owner2user) and tc.x_cust_ref_num like '%" + ticket + "%'", conn,1,1 regards Leandra
  3. Thanks for the reply, unfortunately it gives the same result I just replaced rs1.fields("case_history") with rs1.fields.item("case_history").value, but stil the first 70 characters are shown. I have the same problem if i go to sqlpus with cmd. In that case I use Set Long 2000. Isn't there some kind solution in asp?
  4. Hello, I use asp to retrieve data from a sql database. One of the fields to display has the data type LONG. But for some reason only the first 70 karakters are shown. if ticket <> "" then set rs1 = Server.CreateObject("ADODB.recordset") rs1.Open "select case_history ........etc , conn,1,1 if rs1.RecordCount > 0 then do until rs1.EOF Response.write(rs1.fields("case_history")) rs1.MoveNext loop else response.write("No data Found") end if rs1.closeend if Is there a possibilty so that the full text from the field case_history is shown? thnx Akasha
×
×
  • Create New...