ColdFusion

Moderators: None (Apply to moderate this forum)
Number of threads: 19
Number of posts: 37

This Forum Only
Post New Thread
Single Post View       Linear View       Threaded View      f

Report
i am trying to insert the form fields into the microsoft access databa Posted by Tochie on 30 Oct 2008 at 10:21 AM
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>




 

Recent Jobs