Ask a Question related to Macromedia Flash Data Integration, Design and Development.
-
ShivaElliott #1
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 record
into a database using a Flash form. I know it's certainly possible, but I
haven't seen anything that just deals with "I built a form in Flash. I want
users to fill it out, and then have the fields they fill out populate my
database. That is all."
I don't care about updating this information, I don't care about displaying
this information, I just want it to fill in the fields of a database. I feel
like its something really easy, but somehow I'm just not getting it. Can
anyone give me a quick explanation/tutorial on this?
ShivaElliott 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... -
Check record before Inserting
Hi, I have troble in inserting new records into database, I have a unique date field it should not repeate again, i.e. one record per single day,... -
Please Help! Error inserting record...
I am using ColdFusion MX 6.1 and am having issues with inserting a record into an access database. Any help on what is wrong? Error Executing... -
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... -
s0mus #2
Re: Help with inserting record
<cfif IsDefined("Form.val1")>
<CFQUERY NAME="queryname" DATASOURCE="datasource">
insert into tablename (col1,col2,clo3,clo4)
values ('#Form.val1#','#Form.val2#','#form.val3#','#Form. val4#');
</CFQUERY>
<cfelse>
Values not sent correctly
</cfif>
s0mus Guest
-
s0mus #3
Re: Help with inserting record
First line checks to make sure that a essential value exists, if so, go to next
line. Just to make sure that this page is not being misused we ask it to
accept only form variables containing a vaule that you specify.
Next line, query name, doesn?t matter
datasource, your datasource as defined in your datasource section of the
Administrator
Next line, insert into your table then list the columns
Next line, list your values to insert that correspond to the columns just
mentioned. The #form. Indicates that they are from a form which passes those
named fields. Use the ; to terminate the SQL statement.
End cfinsert
Next line, refers to the first line. If the essential value is missing print:
Values not sent correctly
End
s0mus Guest



Reply With Quote

