ColdFusion

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

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

Official Programmer's Heaven Blogs
Web Hosting | Browser and Social Games | Gadgets

Popular resources on Programmersheaven.com
Assembly | Basic | C | C# | C++ | Delphi | Flash | Java | JavaScript | Pascal | Perl | PHP | Python | Ruby | Visual Basic
© Copyright 2011 Programmersheaven.com - All rights reserved.
Reproduction in whole or in part, in any form or medium without express written permission is prohibited.
Violators of this policy may be subject to legal action. Please read our Terms Of Use and Privacy Statement for more information.
Operated by CommunityHeaven, a BootstrapLabs company.