Help with inserting record

Ask a Question related to Macromedia Flash Data Integration, Design and Development.

  1. #1

    Default 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

  2. Similar Questions and Discussions

    1. 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...
    2. 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,...
    3. 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...
    4. 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...
    5. 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...
  3. #2

    Default 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

  4. #3

    Default 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

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139