Hi Kevin,
Thanks for responding. Here is the original question:
Hello folks,
I am fairly new in the CF arena, and am in need of some simple help here.
I have an Access database (pretty small), and a form on a template, to add
an entry into a "Guestbook."
I would like for the database to updated with the new information, then the
form is submitted and takes them to the "View the Guestbook" page, which
should now show their new entry.Any help would be surely appreciated!
Sincerely,
Craig S. Kiessling ----------->Code Below
I am doing something wrong, but can not figure out what. Here is what Ihave:
(First on template)<cfparam name="Name" default="">
<cfparam name="Email" default=""><cfparam name="Location" default="">
<cfparam name="URL" default=""><cfparam name="Section" default="">
<cfparam name="Contribute" default="">
<cfparam name="Comments" default="">
-----------------html code-------------
<cfform action="guest.cfm" method="post">
<input type="text" size="25" name="#Name#"><br><br>
<input type="text" size="25" name="#Email#"><br><br>
<input type="text" size="25" name="#Location#"><br><br>
<input type="text" size="25" name="#URL#"><br><br>
<input type="text" size="25" name="#Section#"><br><br>
<input type="text" size="25" name="#Contribute#"><br><br>
<input type="text" size="25" name="#Comments#"><br><br>
<input type="submit" name="submit" value="submit">
</cfform>
<cfif isdefined("Form.Submit")>
<cfquery datasource="Northwind">
INSERT into Guestbook(Name,Email,Location,URL,Section,Contribute,Comments)
Values('#Name#','#Email#','#Location#','#URL#','#Section#','#Contribute#','#Comments#')
</cfquery>
</cfif>
--------------more html code------------
>From: Kevin Mansel <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: RE:
>Date: Thu, 12 Jul 2001 13:20:43 -0700
>
>what is your question Craig?
>
>~~~~~~~~~~~~~~~~~
>Kevin Mansel
>Senior Web Developer
>Fox Communications
>[EMAIL PROTECTED]
>DL : 425-649-1321
>C : 425-346-7221
>
>
>
>-----Original Message-----
>From: Craig Kiessling [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, July 12, 2001 1:20 PM
>To: CF-Talk
>Subject: RE:
>
>
>Why is it that no one will even attempt to answer my question? It is way
>lower level than that of the other questions being posted - c'mon folks.
>some help me out.
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
