How can i insert the data from my feedback form into microsoft access database

Discussion in 'Programming' started by Tochie, Oct 30, 2008.

0
  1. #1
    i am using a coldfusion web page to connect to my data base. i am using microsoft access and i named it feedback. i created a table which i named enquiry. i am trying to insert the form fields into the microsoft access database and also to send a mail from the database to my mail.

    please what scripts can i use for this.

    i tried used the field shown below but it gave me an error message which says the datasource feedback cannot be foud. why is this so?

    Below is the scripts i used.

    <CFQUERY DATASOURCE="feedback" NAME="Enquiry">

    INSERT INTO feedback(fullname, telephone, email, Enquiry, comments)

    VALUES('#form.fullname#', '#form.telephone#', '#form.email#', '#form.Enquiry#', '#form.comments#'

    </CFQUERY>
    <CFMAIL TO="mymail@domain.com" FROM="#email#" subject="Enquiry">

    #fullname#

    #telephone#

    #email#

    #Enquiry#

    #comments#



    </CFMAIL>
     
    Tochie, Oct 30, 2008 IP