Doug,
It is relatively simple to incorporate a custom form in
Commonspot and
save the data in a database outside of Commonspot. Just
create your
custom form in the customcf directory of Commonspot,
register your
external datasource in ColdFusion, and drop the custom
script element onto
a page thru CommonSpot authoring. For the datasheet view,
create your
datasheet and use the "Custom Query Result Sheet"
selection from the edit
datasheet option. Add your datasource name, username,
password and select
custom query. Ready to go.
You can see a simple example here.
http://www.auth.shu.edu/applying/under
graduate/events/open-house/index.cfm
In this example, we dynamically add/remove fields ( drop
downs,
checkboxes, etc.) and field edits on the fly, by changing
the
"attributes" passed in the custom script element
parameters. This way we
can quickly deploy a campaign with little or no coding
involved.
Apply security to the form page and to the datasheet page.
Kevin W. Whary
Sr. Internet Developer
Seton Hall University
Division of Information Technology
973.275.2103
"Morand, Douglas" <dmorand healthalliance.com>
Sent by: commonspot-bounceschattyfig.figleaf.com
10/10/2007 09:07 AM
Please respond to
Commonspot Mailing List <commonspotchattyfig.figleaf.com>
To
"Commonspot Mailing List" <commonspotchattyfig.figleaf.com>
cc
Subject
[Commonspot] Looking for suggestions
I'm going to be building three coldfusion applications in
the near
future, and I want to see how I can utilize the tools
available in
Commonspot when I build them. Is it possible to create a
custom form,
and file the data to an external database as well as use the
datasheet
functionality? I'd like to be able to use the Commonspot
security in my
applications.
Can I create the page in Commonspot, but modify the html to
add my
custom coldfusion/javascript code? I haven't found anywhere
to modify
the html code of a page.
Doug Morand
Sr. Systems Analyst
HealthAllance Hospital
60 Hospital Road
Leominster, MA 01453
Phone: 978-466-2085
Fax: 978-466-2139
_______________________________________________
Commonspotchattyfig.figleaf.com
To change your subscription options or search the archive:
http://chattyfig.figleaf.com/mailman/listinfo/commonspot
Brought to you by Fig Leaf Software
Premier Authorized Paperthin Consulting and Training
http://www.figleaf.com
http://training.figleaf.c
om
_______________________________________________
Commonspotchattyfig.figleaf.com
To change your subscription options or search the archive:
http://chattyfig.figleaf.com/mailman/listinfo/commonspot
Brought to you by Fig Leaf Software
Premier Authorized Paperthin Consulting and Training
http://www.figleaf.com
http://training.figleaf.c
om
|
