Forums (Obsolete)


Member	Eriksk - 10/17/2008 8:47:12 AM Guestbook Hello, Is there some way to create a guestbook? I can't imagine it's not possible, but I can't find a solution. Regards, Erik


Kentico Developer	kentico_helenag - 10/17/2008 4:18:18 PM RE:Guestbook Hello Erik, we really do not have a clasic GuestBook. You could use for example a Forum - or BizForm together with Repeater with custom query (query to table with BizForm data) to display the messages. Best regards, Helena Grulichova

Member

Eriksk - 10/22/2008 2:14:07 PM

RE:Guestbook

Hi Helena,

I tried to use a document type (Simple article for testing) and a datalist. I specified I wanted to use the "new button" in the datalist. It didn't worked as I didn't saw it. Later, I tried it on a licensed edition (instead of free) and gave "cms public users" all rights (on the page as well on the document type). But the new button wasn't displayed for anonymous users.

Do you have an explanation for this?

Currently I followed your advise. A bizform, repeater, custom transformation and custom (select) query works...
Can I get a CAPTCHA control in it?

Regards,
Erik

Kentico Developer

kentico_helenag - 10/23/2008 7:38:07 AM

RE:Guestbook

Hi Erik,

as you could read the documentation (context help, CMSWebParts - http://devnet.kentico.com/downloads/KenticoCMS_WebParts.pdf ):

Show New button: Indicates if the button for adding new items should be displayed in the editing mode when viewing the page.

If you view the page in other mode than the editing one (preview or live site) you should not see a New button even if you are a Global Administrator.

Regards the CAPTCHA:
You could add a new field to your BizForm. The field type would be a Security code. Then it displays a CAPTCHA code in your form.

Best regards,
Helena Grulichova


Member	Eriksk - 10/23/2008 11:26:41 AM RE:Guestbook I thought I used the new buttons before, but it was indeed when the user was in editting mode... Captcha: Works like a charm! Thank you


Member	Hendrik - 6/25/2009 5:18:11 AM RE:Guestbook Hi, I want to create a simple, classic guestbook, too, so I found this thread. I have added a BizForm and a "Repeater with custom query" to my page. And now my question: How do I create this custom query that gets the data out of my BizForm table? Thanks for your help Best regards, Hendrik

Kentico Consulting

kentico_mirekr - 7/2/2009 5:59:50 AM

RE:Guestbook

Hi,

Repeater with custom query has Query Name property. You need to specify there name of the query to be used for retrieving data from Kentico CMS Database. You can create your custom query in Site Manager -> Document types -> edit some document type -> Queries. Following example will show you how the query name needs to be specified:

Query Name: CMS.BlogPost.selectall

Then you can navigate into CMS Site Manager -> Development -> Document types -> Edit Blog Post document type -> Queries -> edit appropriate query. There should be following query:


SELECT ##TOPN## ##COLUMNS## FROM CONTENT_BlogPost WHERE ##WHERE## ORDER BY ##ORDERBY##

In this way you can create your own query. BizForms are using table names in database in following format:

Form_<BizformCodeName>

Example:

Form_ContactUs

I hope this will help you.

Best Regards,
Miroslav Remias