var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: CLOB field and GetChunk
Hope someone will be able to help with that weird problem I'm facing.
I'm querying a CLOB field from an Oracle 8 DB, in an ASP page. I manage to retrieve the value of my CLOB field by using the GetChunk (the value is an HTML code).
My problem is that each time, the first 6 or 7 characters of my code are missing (but when looking directly in the DB, I see that the HTML codes in my table are fine).
For example, I've one of my code starting with :
Once retrieved with GetChunk, I get :
(<script is missing).
The code I use is :
sql_query = ""
sql_query = sql_query + " select text as code "
sql_query = sql_query + " from rendering"
sql_query = sql_query + " where id = " & id
'cnnprod is my connection object
set requete = cnnprod.execute(sql_query)
tempcod = requete.fields("code").getChunk(15000)
Does anyone have an idea of what would be causing the problem ?