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 found. 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>