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 I
have:
(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>...
<td width="50%" valign="top" align="left">
<font face="Arial, Helvetica, sans-serif" color="#ffffff"><b>Name or
Alias:</b></td>
<td width="50%" valign="top" align="right">
<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>
</td>
</tr>
</table>
<br></td><td width="20%" valign="top" bgcolor="#ffffff"><br></td></tr>
<tr>
<td width="20%" valign="top" bgcolor="#ffffff">
<br></td>
<td width="60%" valign="top" bgcolor="#ffffff"><br></td>
<td width="20%" valign="top" bgcolor="#ffffff"><br></td>
</tr>
</table>
<cfoutput query="getguest">
<blockquote>
#date#<br>
<b>#name#<br>
<cfif #email# is not ""><a href="mailto:#email#";>Email Me</a></cfif><br>
#location#<br>
<cfif #URL# is not ""><a href="#URL#">Visit My Website</a></cfif><br>
#section#<br>
#contribute#
#comments#</b>
</blockquote>
<hr width="50%" align="center">
</cfoutput>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
