Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to create a guestbook...

Status
Not open for further replies.

GUJUm0deL

Programmer
Jan 16, 2001
3,676
US
Can anyone tell me how to get about creating a guestbook using CF?? I would like to Acess as the DB file. Alos, the guestbook should be able to delete entried or modify them [but ONLY if the user logs in...]
Is this possiable??
 
Sounds like fun:

I don't know how much info you want in the Guest Book or what exactly it is you need help with but I can say that it is very possible, in fact it isn't very hard. So if there is something in particular you need help with (Search the Forum first) then let us know.

As far as how to get started, I always setup the Database first. Decide what fields you need, I imagine it would look something like this:

tableGuest
FirstName
LastName
EmailAddress
Date (Possibly auto-set when they first signup)
Notes (Always good to have a 'whatever' type field)

I'm not clear on who it is that might want to login and delete or change entries. Is that the random user off the web or is it the owner of the guest book. If you want everyone to be able to login to there own page then add
Login
Password
to the above list.


Hope I've helped get you started. If you have any more specific questions please feel free to ask.



 
Hi, first off thanks for the help...
I'll be creating the DB in Acess with the fieldnames of Name, E-mail, Date, webpage url[of the signer, if they have one], and comments, along with rate the site fieldname...the owner of the site is the only one with access to the modify/delete feature...
After I set up the DB how do I get started on the guestbook in CF?? Is there a template I can use or can I just create it from scratch?? I also want the Date to be inputted automatically, so the user can't put in "misleading" dates...
 
PS -- BTW when I create the DB the entries will be blank right?? I mean I only create the fieldnames right, and leave the field values blank right??
 
hey y'all...I created the DB file and that part works fine, then I created the CF files and they seem to work, this is what happends:
two CF files were created: guestbooks_EntryAction.cfm and guestbooks_EntryForm.cfm. In the EntryForm.cfm when you fill out the information, it goes through and the result displays in the EntryForm.cfm, but when I click on the ActionForm.cfm I get this error message:

Error Diagnostic Information
An error occurred while evaluating the expression:
#Form.Name#
Error near line 16, column 33.


Error resolving parameter FORM.NAME

The specified form field cannot be found. This problem is very likely due to the fact that you have misspelled the form field name.

The error occurred while processing an element with a general identifier of (#Form.Name#), occupying document position (16:32) to (16:42).

Date/Time: 06/01/01 16:23:53
Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows 95; DigExt)
Remote Address: 127.0.0.1


Know what that means?? I would also like the guestbook entries to display on the ActionForm.cfm so anyone can see the entries...
 
GUJUm0del.,

What I would do is, on the top of your actionForm.cfm page, put this code:

<cfloop list=&quot;#form.fieldnames#&quot; index=&quot;i&quot;>
<cfoutput>#i#</cfoutput>
</cfloop>
<cfabort>

This will give you a list of all your form field names. If your form method is GET, remember that your variables will have URL scope, not form scope. That one &quot;gets&quot; me all the time.

HTH,
geoff
 
Hi geofflilley, I tried that and I get the same error message...
what can be missing. I would like ALL the guestbook entired to be displyd on the actionForm.cfm. This way anyone can see the postings at all times...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top