Ask a Question related to Coldfusion Flash Integration, Design and Development.
-
kadman #1
INSERTing record into Access via CFC?
I feel confident people are routinely doing this, but I have not been able to
find a simple, concise tutorial on it...
I have a Cold Fusion Component (with Access=remote) that will insert a six
field record into an Access database. I have tested the CFC from a ColdFusion
page, using a form with <cfform> tags on the .cfm and an SQL statement using
<cfinsert> tags in the .cfc (to allow for optional fields). Anyhow, this works
just fine, so I figure that the issue is arising in the remoting from my flash
movie. I have managed to use other CFC's with SELECT statements to dynamically
populate a number of controls within the flash movie, so I can get to the data
in other tables within this target database, but when I try to invoke the
webservice I have defined pointing to the .cfc with the INSERT method, nothing
seems to happen. I have named the fields in the flash movie the same as the
fields in the .cfm file.
The enviroment is AS2, Flash MX Pro 2004, CFMX7, Access 2000.
I guess what I should be asking is how to make a call from the flash movie to
the .cfc containing the INSERT statement? I had relied on a simple trigger
tied to a button click or an onLoad event to initiate a defined webservice for
the .cfc's containing the SELECT statements. Is there added information I need
to supply somewhere when trying to do an INSERT?
It seems like a straightforward thing, so I imagine that means it will wind up
being rather complicated..
Thanks in advance for any suggestions :confused;
-kadman
kadman Guest
-
INSERTing record into Access
Fellow Flashers, I posted a very similar message to the ColdFusion and Flash integration board last week, but got no responses,so thought I might... -
Help with inserting record
So I've been looking all over these forums, and all over the internet on some kind of tutorial that will explain what I need to do to just insert a... -
Inserting a Record
I am trying to create a web form to insert data into an SQL table that is on another server. So far I have my connection string working great and... -
Error when inserting record
When trying to use the server behavior "Insert Record" I get the following error message: While executing onLOad in Insert Record.htm, the... -
Access the primary key while inserting a record
Is there a way to reference the 'primary key' field of a record you are actually inserting at the moment. Im using an 'int auto increment' field...



Reply With Quote

