A repeating field is one that is bound just once on a form to an xml
attribute, but you want to repeat for each time the xml element appears in
your document. Mainly because when designing your template, you don't know
how many times something will appear in the list.
Think of a grocery list... you have your items that you purchased listed
along with the price of each item.
You might have xml that looks like this.
<data>
<itempurchased>
<Name>toothpaste</Name>
<price>$2</price>
</itempurchased>
<itempurchased>
<Name>watermelon</Name>
<price>$5</price>
</itempurchased>
<itempurchased>
<Name>Apples</Name>
<price>$3</price>
</itempurchased>
</data>
But on your document, you want it look something like this:
ITEM PRICE
Toothpaste $2
Watermelon $5
Apples $3
You wouldn't want to create 3 different fields for toothpaste, watermelon,
and Apples (what if the person bought 4 items?). Instead you'd want to
create field and just have it repeat for each time that element is found in
the xml.
Hope that makes sense...
Dennis
-----Original Message-----
From: Andrew Douglas Pitonyak [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 10, 2007 10:27 PM
To: [email protected]
Subject: Re: [users] XForms repeating fields
I will repeat the original question from [EMAIL PROTECTED]
What do you mean by repeating fields?
I assume that you mean that you want a single set of fields to then
represent multiple data rows (as in mailing labels), but I am only guessing.
As for security:
Much would depend on your security model for your EJBs and J2EE. How do
you authenticate? How does an EJB know that it is allowed to do
something? If you have already authenticated, using the method of your
choice, then in your secure location (I am assuming a multi-tiered
setup) you can do your stuff after you have already verified your users...
that said, Yes, Base can access other database systems such as MYSQL.
Swanson, Dennis wrote:
I looked at it... but my understanding (correct me if I'm wrong cuz I'm
pretty new to OpenOffice) is that OpenOffice Base basically allows you to
just get the data directly from the database. That won't work for us
because all of our security, processing, etc is done in EJB's in a J2EE
architecture. So hitting the database directly basically by-passes all of
that. Unless OpenOffice Base allows you to use something other than a
database as its source (like xml, a webservice, etc.) it won't work for
us.
That's why we were looking at the OpenOffice Writer XForm functionality
for
what we need. But like I said, I'm an OpenOffice-newbie so I could have
very well missed something that could make Base work for us.
-----Original Message-----
From: S Perry [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 10, 2007 3:19 PM
To: [email protected]
Subject: Re: [users] XForms repeating fields
Have you checked OpenOfficeBase's REPORT capability?
Repeating fields is how you make a sheet of labels with the same
address.
You do not use NEXT RECORD for the second and subsequent labels if you
want
a sheet that has the same address on every label, such as your return
address labels.
If you want to make a sheet of mailing labels that are all different,
you
use the fields you want for each label for the first label, then NEXT
RECORD
for the subsequent labels.
[EMAIL PROTECTED] wrote:
Not quite sure what you mean - could you give an example of repeating
fields?
Quoting "Swanson, Dennis" :
We are interested in using OpenOffice xforms to create some reports based
off of xml that we pass to the document. The problem we're running into
now
is that it doesn't appear that OpenOffice currently supports repeating
fields with xforms (to display more than one record of something). Can
someone confirm this?
Also, if OOo does not currently support repeatable fields with xforms, my
next question is: I see that a report designer is being planned for OOo
3.0 next year, does anyone know if it will include this capability?
Thanks,
Dennis
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------
Get the free Yahoo! toolbar and rest assured with the added security of
spyware protection.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
