RE: Re[2]: [C2] Accessing CLOBs as Documents

[Marty McClelland]

> Hmm.. So ar you saying that if my clobs didn't have the " version="1.0" encoding="UTF-8"?>"  then get-xml would work?
Removing the top PI worked for me - and it makes sense after thinking
about it since it is only valid when it is the first line in the
document.  When the get-xml is executed, the result is to add a node to
the current document with the value of get-xml. 

marty 




> 
> When I tried:
>
> It didn't work, but perhaps that is because it is a document.
> Thursday, October 18, 2001, 7:13:50 AM, you wrote:
> 
> MM> I have a similar application - but the clob is an xml 
> fragment ( meaning
> MM> it doesn't have processing instruction tags ).  So I can 
> use get-xml
> MM> instead of the get-ascii you use.  Then I can access data 
> in the xml
> MM> fragment with the XSL stylesheet.
> 
> MM> marty
> 
> >> -Original Message-
> >> From: Russell Castagnaro [mailto:[EMAIL PROTECTED]]
> >> Sent: Thursday, October 18, 2001 12:48 PM
> >> To: [EMAIL PROTECTED]
> >> Subject: [C2] Accessing CLOBs as Documents
> >> 
> >> 
> >> Hello cocoon-users,
> >> 
> >>   I've got a problem.
> >> 
> >>   I have a table that has a few fields and a clob in it.  I want to
> >>   use the esql taglibs or SQLTransfromer to access this as 
> a document.
> >>   The column 'doc_content' is
> >> 
> >>   currently I'm using xml like this:
> >> 
> >> 
> >> 
> >>  >>   language="java"
> >>   xmlns:xsp="http://apache.org/xsp";
> >>   xmlns:esql="http://apache.org/cocoon/SQL/v2";
> >> >
> >> 
> >>   
> >>A Database XML DOC Page
> >>
> >> 
> >> 
> >>  fun
> >>  
> >>Select * from XML_DOC where doc_id in 
> >> (select max(doc_id) from xml_doc) 
> >> 
> >>  
> >> 
> >> 
> >> >> column="doc_content"/>
> >>
> >>  
> >>
> >>  
> >>
> >> 
> >>
> >>   
> >> 
> >> 
> >> 
> >> the 'doc_content' field'  is returned escaped out:
> >> 
> >>   
> >> /templates/seattletimes/  
> >>   
> >>  >> handleError="false">header.jsp  
> >>  >> handleError="true">donation2.jsp  
> >>  >> handleError="false">footer.jsp  
> >>   
> >> error2.jsp  
> >> 
> >> 
> >> 
> >> 
> >> Is there any way to have this content integrated into the document?
> >> 
> >> 
> >> Thanks,
> >> rrc
> >> 
> >> -- 
> >> Best regards,
> >>  Russell  mailto:[EMAIL PROTECTED]
> >> 
> >> 
> >> 
> -
> >> Please check that your question has not already been 
> answered in the
> >> FAQ before posting. 
> >> 
> >> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> >> For additional commands, e-mail: <[EMAIL PROTECTED]>
> >> 
> >> 
> 
> MM> 
> -
> MM> Please check that your question has not already been 
> answered in the
> MM> FAQ before posting. 
> 
> MM> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> MM> For additional commands, e-mail: 
> <[EMAIL PROTECTED]>
> 
> 
> 
> 
> -- 
> Best regards,
>  Russellmailto:[EMAIL PROTECTED]
> 
> 
> -
> Please check that your question has not already been answered in the
> FAQ before posting. 
> 
> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> For additional commands, e-mail: <[EMAIL PROTECTED]>
> 
> 

-
Please check that your question has not already been answered in the
FAQ before posting. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>

Re[2]: [C2] Accessing CLOBs as Documents

[Russell Castagnaro]

Hello Marty,

Hmm.. So ar you saying that if my clobs didn't have the ""  then get-xml would work?

When I tried:
   
It didn't work, but perhaps that is because it is a document.
Thursday, October 18, 2001, 7:13:50 AM, you wrote:

MM> I have a similar application - but the clob is an xml fragment ( meaning
MM> it doesn't have processing instruction tags ).  So I can use get-xml
MM> instead of the get-ascii you use.  Then I can access data in the xml
MM> fragment with the XSL stylesheet.

MM> marty

>> -Original Message-
>> From: Russell Castagnaro [mailto:[EMAIL PROTECTED]]
>> Sent: Thursday, October 18, 2001 12:48 PM
>> To: [EMAIL PROTECTED]
>> Subject: [C2] Accessing CLOBs as Documents
>> 
>> 
>> Hello cocoon-users,
>> 
>>   I've got a problem.
>> 
>>   I have a table that has a few fields and a clob in it.  I want to
>>   use the esql taglibs or SQLTransfromer to access this as a document.
>>   The column 'doc_content' is
>> 
>>   currently I'm using xml like this:
>> 
>> 
>> 
>> >   language="java"
>>   xmlns:xsp="http://apache.org/xsp";
>>   xmlns:esql="http://apache.org/cocoon/SQL/v2";
>> >
>> 
>>   
>>A Database XML DOC Page
>>
>> 
>> 
>>  fun
>>  
>>Select * from XML_DOC where doc_id in 
>> (select max(doc_id) from xml_doc) 
>> 
>>  
>> 
>> 
>>> column="doc_content"/>
>>
>>  
>>
>>  
>>
>> 
>>
>>   
>> 
>> 
>> 
>> the 'doc_content' field'  is returned escaped out:
>> 
>>   
>> /templates/seattletimes/  
>>   
>> > handleError="false">header.jsp  
>> > handleError="true">donation2.jsp  
>> > handleError="false">footer.jsp  
>>   
>> error2.jsp  
>> 
>> 
>> 
>> 
>> Is there any way to have this content integrated into the document?
>> 
>> 
>> Thanks,
>> rrc
>> 
>> -- 
>> Best regards,
>>  Russell  mailto:[EMAIL PROTECTED]
>> 
>> 
>> -
>> Please check that your question has not already been answered in the
>> FAQ before posting. 
>> 
>> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
>> For additional commands, e-mail: <[EMAIL PROTECTED]>
>> 
>> 

MM> -
MM> Please check that your question has not already been answered in the
MM> FAQ before posting. 

MM> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
MM> For additional commands, e-mail: <[EMAIL PROTECTED]>




-- 
Best regards,
 Russellmailto:[EMAIL PROTECTED]


-
Please check that your question has not already been answered in the
FAQ before posting. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>