It should only be creating a record for each form field that has been
added to the list. Should be about 10-20 I would think.
The problem I am having at the moment is that whilst the setPosition
method is inserting/updating a row in the db the setPerson method is
not. I added some cflog tags to watch what was happening and as far as
I can tell a record is created or loaded with a PersonID and then the
save() method is called before. At the moment I am only sending one
form field through so it should only be called once (which it is) but
the data is not getting save into the db. If I run an Insert using
MySQL query browser using just the data that I am submitting to it
(PersonID, Title) the it works. Initially I had some NOT NULLS which
had no default values but I have changed these and deleted the Reactor
generated files. Still not saving.
Is there a way to destroy a record object once I have done the save in
readiness for the next loop? I am effectively doing the following
(Pseudo code):
loop (in controller calls saveField())
(saveField calls setPerson() which:
creates or Loads record
setField
save
endloop
The loop then runs for each form field submitted. I have tried with
just 1 field or multiples and it still doesn't save. Is there any way
to look at any exceptions it might be throwing?
Cheers,
Dave
On 25 Apr 2008, at 12:40, Dominic Watson wrote:
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.
As long as it doesn't create unneccessary records and isn't grinding
the system to a slowdown then I'd say go with it to meet your
deadline. Sounds like there is another phase to the project which
might just render the code obsolete or give you the chance to
rethink it if neccessary.
It doesn't sound bad though at all.
Dominic
On 25/04/2008, David Phipps <[EMAIL PROTECTED]> wrote:
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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- --
--
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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
