Your problem is not simple. If I've understood you have resources record made like this:
something.jpg | somewhere/somethingelse.mov | resourceFound.txt |

Well if this is the point, I think the best way to act is to make some xslt transformation after the sql transformation.
I don't have experiences about parsing text but I think the text generator do such a thing.
If you have to make estraction and elaboration before aggregation I would use cinclude instead xinclude. The main difference between the is the two is the possibility of cinclude to invoke a specific pipeline (so a transformation) as source with the protocol "cocoon:/".
I find this very powerfull even if a little proprietary ;-)

I agree with the orientation of avoiding esql where possible, and I think that here it doesn't help a lot
Sorry if I'm not specific but I should know the project and even so it would take me time. I hope to have been useful somehow

Jeremy Quinn wrote:

Dear All

We are using the SQLTransformer for a project.

Our SQL Database contains a Table called Resource, which keeps information about the resources in our archive. Most of these resources are binary, ie. .gif, .jpg, .swf, .mov etc. So we merely 'embed' the resource reference in the page produced by a Resource record, to show it on the page.

We now find we have a few 'text' resources, that require a bit of markup in them, mainly just paragraphs.

We either need to XInclude the resource into the pipeline from an XML file referred to in the SQL, or keep the actual resource in the SQL and parse it as it comes out.

I know that it is possible to parse SQL fields via the ESQL TagLib, but we prefer the Transformer approach.

Does anyone know if it is possible to Parse fields extracted from SQL via the SQLTransformer?


Thanks for any suggestions.

regards Jeremy






---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>

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.     <http://xml.apache.org/cocoon/faq/index.html>

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

Reply via email to