Hi,
Thanks to Dominic and Chris, I am a little further forward. The next
phase of the project will be a little more like View Person > see list
of positions w/dates but at the moment we have a form which shows
information for many users in many positions (It is a Church form).
The data is then saved to a duplicate set of tables. In the admin side
the Validators view the updated duplicate records and compare them to
the existing data (2 forms side by side in accordions for each
position - some forms have 750 input fields!!). If any info has
changed they can approve the change which copies the data for the
approved field from the duplicate table to the live table in the db.
The main problem I had originally was the way this approved data had
to be added. I couldn't just submit all dup data as some fields may
not have been approved so using jquery I added a little icon next to
each field. The validator then clicks on each icon next to the field
they wish to approve. Once they have finished they click a button and
this sends a list of approved fieldid's and their corresponding values
to my save fuseaction. I then loop over the fieldid list and save each
field individually.
I use 3 methods in my serviceCFC: saveField (receives ID,fieldid and
fieldvalue). This then calls a setPerson method which is a general
method able to accept all possible values for a Person (It creates or
loads a Person) and sets each field. The saveField also calls
setPosition which saves the Person into this Position along with Start
and/or Finish Dates.
The upside is I have the flexibility to approve a single field or all
the fields for a person or multiple people if needed. The downside is
the setPosition method is called each and every time the setPerson
method is called and really it only needs to be called the first time
for a given Person.
I could pass a loop count to the saveField method which would work but
I am not comfortable passing a loop count number from my controller
into my cfc?
Can anyone see a big floor in the above architecture? Unfortunately I
am up against the wall on the deadline - so it is more about getting
to work than how it works!
Any suggestions would be great.
Cheers,
Dave
On 23 Apr 2008, at 15:38, Dominic Watson wrote:
How are you getting to the page on which you need to display the
data on a single record here? I assume it will be something like:
View person ->
-> -> See list of positions w/ dates - click on one...
-> -> -> See position info
If that's the kind of situation - you should be able to use the new
PK you have created (and not have to extend the object).
To 'overide' an inherited method, simply create a new method with
the same name in the extended component. If you need to call the
original base method you can use the super scope:
<cffunction name="save" hint="Overriding save method">
...
...
<cfset something = super.save(...)>
</cffunction>
HTH
Dominic
On 23/04/2008, David Phipps <[EMAIL PROTECTED]> wrote:
Many thanks Chris and Dominic. I just discovered the table already
has a Unique index based upon the PersonID,PositionID and StartDate
but how do I get Reactor to use that info or do I use a gateway
query to grab the record matching the 3 fields and then use the
resulting id (I just added a pk to the table) to create a Record
object?
It is looking a lot more promising and not having to restructure the
db is going to save me a bundle of time.
I was reading the docs before I sent the first mail and whilst I
understand that I can add new methods to a record object I can't
seem to see the next step which I guess is to extend the save()
method to include any extras I add to the record object? Does that
even make sense?! Although I think if I am on the right lines with
my first paragraph above I won't need to extend the record object as
I will be able retrieve an individual record.
Cheers,
Dave
P.S. OT: Has anyone managed to get Verity running on a standalone
server (we have it running in VMWare on an OS X server) and then
return search results? We are able to connect,create collections and
index them but all searches result in 0 records found. The index is
a query based index. ColdFusion 8 on OS X has a helluva hole in it -
no search engine. Using some code from Ray Camden and various others
I have managed to get a basic Lucene search running but sheesh what
a nightmare!
On 23 Apr 2008, at 14:58, Dominic Watson wrote:
Aha, the live docs:
http://livedocs.reactorframework.com/Reactor_Documentation.htm
Dominic
Just realised that link wasn't very useful, damned ajax!
Once in the docs do:
Reactor Crash Course -> Customizing reactor objects
--
Blog it up: http://fusion.dominicwatson.co.uk
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- -- --
Reactor for ColdFusion Mailing List
[EMAIL PROTECTED]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- -- --
_______________________________________________________________________
David Phipps
Director, Chapel Studios
T +44 (0)20 7100 6980 F +44 (0)20 7100 6981 M +44 (0)7765 240899
New Broad Street House, 35 New Broad Street, London, EC2M 1NH, UK
http://www.chapel-studios.co.uk
_______________________________________________________________________
The Chapel Studios group of companies are registered in England.
'Chapel Studios' and the Chapel Studios logo are registered
trademarks of Chapel Studios. The information in this email is
confidential, intended solely for the addressee, and may be legally
privileged. If you are not the addressee or authorized to receive
this for the addressee, you must not use, copy, disclose or take any
action based upon this message or any information herein. If you
have received this message in error, please advise the sender
immediately by reply e-mail.
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- --
Reactor for ColdFusion Mailing List
[EMAIL PROTECTED]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- --
--
Blog it up: http://fusion.dominicwatson.co.uk
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- --
Reactor for ColdFusion Mailing List
[EMAIL PROTECTED]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- --
_______________________________________________________________________
David Phipps
Director, Chapel Studios
T +44 (0)20 7100 6980 F +44 (0)20 7100 6981 M +44 (0)7765 240899
New Broad Street House, 35 New Broad Street, London, EC2M 1NH, UK
http://www.chapel-studios.co.uk
_______________________________________________________________________
The Chapel Studios group of companies are registered in England.
'Chapel Studios' and the Chapel Studios logo are registered trademarks
of Chapel Studios. The information in this email is confidential,
intended solely for the addressee, and may be legally privileged. If
you are not the addressee or authorized to receive this for the
addressee, you must not use, copy, disclose or take any action based
upon this message or any information herein. If you have received
this message in error, please advise the sender immediately by reply e-
mail.
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[EMAIL PROTECTED]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
