akc/blogs.properties

Demonstrates how the akc blogs page is implemented. Also accomplishes page by page display using RandomTableHandler6.

###################################
# BlogsURL: ownerUserId, publicitemsloop_controlstring 
###################################
#basics
blogsURL=aspire:\\reports\\blogs\\blogs.html
blogsURL.formHandlerName=BUFH
Request.BUFH.form_handler.class_request.classname=com.ai.htmlgen.DBHashTableFormHandler1

#main data
request.BUFH.maindatarequest.classname=com.ai.db.DBRequestExecutor2
request.BUFH.maindatarequest.db=reportsDB
request.BUFH.maindatarequest.stmt=\
\
select first_name as user_first_name \
	,last_name as user_last_name \
	,email as user_email \
from users \
where user_id = {ownerUserId.quote}

#children specification for XML support
BUFH.loopnames=publicitemsloop

#To cover the last page
BUFH.publicitemsloop.eliminateLoop=yes
request.BUFH.publicitemsloop.eliminateLoop=yes


#the loop of public items
request.BUFH.publicitemsloop.class_request.className=com.ai.htmlgen.RandomTableHandler6
request.BUFH.publicitemsloop.query_request.className=com.ai.db.DBRequestExecutor2
request.BUFH.publicitemsloop.query_request.db=reportsDB
request.BUFH.publicitemsloop.query_request.stmt=\
SELECT * \
FROM filed_items AS fi, \
	reports AS r, \
	folders AS f \
WHERE 1=1  \
	And fi.item_id=r.report_id \
	And fi.folder_id=f.folder_id \
	and f.public='Y' \
	and f.owner_user_id={ownerUserId.quote} \
ORDER BY r.last_updated_on DESC