Craig,
Here is a quick tip, try to use some more white space (both in your code and
in your email). Both your code and the email were tough for me to read.
Since I'm on the clock when I check this mailing list, I usually skip
messages that I find hard to read.
That said, let me see if I can help you out some.
What it looks like you want to do is have a form at the top of the page that
submits to itself and below the form display the resulting guest book
entries below it. If I'm wrong, tell me. The key to making this work,
especially if you are new to Cold Fusion, is to liberally use comments to
describe what the intent of the code is, not what the code is doing. Then
you can look at the comments and the code and see if they don't match.
Try using this structure:
Set defaults for form variables
Was this a form submission? (Use a hidden field that has a CFPARAM to FALSE
but a submitted value of TRUE)
Yes - Insert data into database
Display for header
Display form hidden fields
Display guestbook fields
Display form footer and buttons
Get the Guest book entries
Display the guestbook entries
Let me know if you have some questions.
> -----Original Message-----
> From: Craig Kiessling [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 12, 2001 10:39 AM
> To: CF-Talk
> Subject: Forms+SQL+Params
>
>
> 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:
> [snip]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
