CLOB field and GetChunk

TheMSsForum.com: The Microsoft Software Forum

Hi there,
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 :
<script language="JavaScript">
pp409217=window. open
('','','scrollbars=no,resize=no,height=200,wid

th=350');

Once retrieved with GetChunk, I get :
language="JavaScript">
pp409217=window. open
('','','scrollbars=no,resize=no,height=200,wid

th=350');

(<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)
response.write tempcod

Does anyone have an idea of what would be causing the
problem ?

Thanks

Salem
Top

Re: CLOB field and GetChunk by Aaron

Aaron
Thu Aug 28 20:49:23 CDT 2003

Why are you getting by chunk rather than value? are you attempting to fetch
a segment of the field?
"Salem" <salembouras@yahoo.com> wrote in message
news:041001c36d99$3c76ac20$a101280a@phx.gbl...
> Hi there,
> 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 :
> <script language="JavaScript">
> pp409217=window. open
> ('','','scrollbars=no,resize=no,height=200,wid
>
> th=350');
>
> Once retrieved with GetChunk, I get :
> language="JavaScript">
> pp409217=window. open
> ('','','scrollbars=no,resize=no,height=200,wid
>
> th=350');
>
> (<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)
> response.write tempcod
>
> Does anyone have an idea of what would be causing the
> problem ?
>
> Thanks
>
> Salem
>
>


Top