Hello.
I'm looking for some best practice advice with this one.
In our membership database, we have a table where we assign membership to a
community/group. A user can join or leave these groups on the web (simple
checkbox form), or staff can add or remove group membership through the desktop
client. By nature of the desktop client, there is the possibility of a data
error, ex: populated fieldA and fieldB, but not fieldC.
For the web application, upon submitting the form, I'm looping through a list
of "itemsToAdd" and inserting those. In the event that there are bad records
because of bad data entry from the desktop client, should I be deleting the
to-be-inserted record before inserting?
(Please forgive the ham-fisted, partial object orientation of invoking the
component for each item.)
So, if I call the insert method:
<cfloop list="#itemsToAdd#" index="itemsToAddIndex">
<cfinvoke component="components.myComponent" method="insertMethod">
<cfinvokeargument name="fieldA" value="#itemsToAddIndex#" />
<cfinvokeargument name="fieldB" value="#form.fieldB#" />
<cfinvokeargument name="fieldC" value="#form.fieldC#" />
</cfinvoke>
</cfloop>
Should I be calling the delete method first?
<cfloop list="#itemsToAdd#" index="itemsToAddIndex">
<cfinvoke component="components.myComponent" method="deleteMethod">
<cfinvokeargument name="fieldA" value="#itemsToAddIndex#" />
<cfinvokeargument name="fieldB" value="#form.fieldB#" />
<cfinvokeargument name="fieldC" value="#form.fieldC#" />
</cfinvoke>
<cfinvoke component="components.communities" method="insertCommunities">
<cfinvokeargument name="fieldA" value="#itemsToAddIndex#" />
<cfinvokeargument name="fieldB" value="#form.fieldB#" />
<cfinvokeargument name="fieldC" value="#form.fieldC#" />
</cfinvoke>
</cfloop>
I've never seen something like this, but it seems like an OK idea. Anyone have
a better solution or suggestion? Please note that I have to keep to inserts and
deletes; no updates.
Thanks for the help.
Cameron
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306389
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
