Hi all!

I'm rather new with Cocoon but I think I've got a somehow tricky question:

In my ORACLE database XML formatted records are stored e.g. for users (also
for other types of records but these are the easy ones I want to try with)
in CLOB fields - so the record could look like:

-- CLOB content ---
some XML stuff
...
<user>
    <system_user_name>My user name</system_user_name>
    <name>My real name</name>
    <adress>My street and number</adress>
    <phone>My full phone number</phone>
    <fax>My full fax number</fax>
    <email>My email adress</email>
</user>
-- end of CLOB content ---

One of my pages should be a 'Search for users' form.
Result of processing the above form should show a page (simple list) which
provides
- page title
- some descriptive information
- a list with only the content of  <system_user_name> for let's say the
first 20 results but each element being a link to a detailed page
- navigational elements (button or links) like 'previous 10' or 'next 10'.

Below is an example for the simple list with the first found result already
stated in html like form:
-------------------- simple list -----------------------------
    Results of user search
    Your search for 'searched name' resulted in 21 hits.
    Results 1 - 10

    <a href="http://myserver/detaileduser?name=Real name1">Real name1</a>
    Real name2
...
    Real name9
    Real name10

    <previous> 1 2 <next>
-------------------- end of simple list -----------------------------

When clicking on a name the detailed page should provide whole information
about the user in a formatted way like:
---------------------- detailed page -------------------------------
    System user name:   My user name

    Real name:          My real name

    Adress:             My street and number

    Phone:              My full phone number
    FAX:                        My full fax number
    Email:              My email adress
---------------------- end of detailed page -------------------------------

My intention was to use an action which performs the search and stores the
results in an XML file (or maybe something which is XML like but does not
include e.g. the <?xml version="1.0"?> if this more convenient for the
temporary existing file). An XSP reads that XML file via some code in the
logic-section and provides the XML with the buttons/or links at the end. So
an XSL has to do the filtering of the information for the simple list and
the transformation to provide the links (which need to have some dynamic
parameters for finding the single person record in the database later on
when selected from the list) to the detailed persons.
BUT somehow I find it rather hard to get the XML (which is dynamically
produced from the database) to be included in the XSP.

Is this the right way or can you point me to a more clever one?
Maybe I don't need the XSP but how can I then get the navigation elements on
my simple list page. Is it just that simple to
- create the XML file in the action
- transform and filter to get the clickable list of names
- transform to include the page header, the descriptive text and the
navigation elements
- serialize with the html serializer

For the user pages I could also read database attributes (system user name,
adress ...) directly but I have other kinds of information and functionality
in my system which forces me to stick to already existing XML formatted
information from the database.

Thanks in advance
Kurt Majcen


---------------------------------------------------------------------
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