i am trying to insert the form fields into the microsoft access databa

Thu, 30 Oct 2008 10:21:24 -0700

Posted the message 'i am trying to insert the form fields into the microsoft access databa' on the ColdFusion forum.

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>

Tochie's Feed - Programmer's Heaven

i am trying to insert the form fields into the microsoft access databa