4-Feb-05 (Created: 4-Feb-05) | More in 'Property file examples: AKC'

Properties cheat sheet 1 for builds below 20

Aspire Tags URL JSP URL 
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=(your-sql-statement)

#the loop of public items
request.BUFH.publicitemsloop.class_request.className=\
com.ai.htmlgen.GenericTableHandler6

request.BUFH.publicitemsloop.query_request.className=\
com.ai.db.DBRequestExecutor2

request.BUFH.publicitemsloop.query_request.db=reportsDB
request.BUFH.publicitemsloop.query_request.stmt=(your-select-statement)

#basics
blogsURL=/reports/blogs/blogs.jsp
blogsURL.transformType=JSP
request.blogsURL.transform.classname=com.ai.jsp.JSPTransform
blogsURL.formHandlerName=BUFH

#Data definition
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=(your-sql-statement)

#the loop of public items
request.BUFH.publicitemsloop.class_request.className=\
com.ai.htmlgen.GenericTableHandler6
request.BUFH.publicitemsloop.query_request.className=\
com.ai.db.DBRequestExecutor2
request.BUFH.publicitemsloop.query_request.db=reportsDB
request.BUFH.publicitemsloop.query_request.stmt=\
(your-select-statement)
Aspire Tags With empaty data JSP URL with empty data 
blogsURL=aspire:\\reports\\blogs\\blogs.html
blogsURL.formHandlerName=EmptyData
request.EmptyData.form_handler.class_request.classname\
com.ai.htmlgen.DBHashTableFormHandler1

#basics
blogsURL=/reports/blogs/blogs.jsp
blogsURL.transformType=JSP
request.blogsURL.transform.classname=com.ai.jsp.JSPTransform
blogsURL.formHandlerName=EmptyData

#Data definition
Request.EmptyData.form_handler.class_request.classname=\
com.ai.htmlgen.DBHashTableFormHandler1
Simple update Update with a multirequest 
# Move to folder: folderId, reports
request.MoveReports.classname=com.ai.db.DBRequestExecutor2
request.MoveReports.query_type=update
request.MoveReports.db=reportsDB
request.MoveReports.stmt=\
	update filed_items \
	set folder_id = {folderId} \
	where item_id in ({reportIds})
request.MoveReports.redirectURL=\
/akc/servlet/DisplayServlet?url=ShowFiledReportsJSPURL&somearg={abc-arg}

request.MoveReports.failureRedirectURL=\
/akc/servlet/DisplayServlet?url=SomeErrorURL&somearg={abc-arg}

# MoveReports(folderId, reports)
# Perform a multi-exec
request.MoveReports.classname=\
com.ai.db.DBPreTranslateArgsMultiRequestExecutor

#Define a database
request.MoveReports.query_type=update
request.MoveReports.db=reportsDB

#Define the pipeline
request.MoveReports.request.1=MoveReports1
request.MoveReports.request.2=MoveReports2

#Redirect on successful execution to
request.MoveReports.redirectURL=\
/akc/servlet/DisplayServlet?url=ShowFiledReportsJSPURL

#Redirect on failure
request.MoveReports.failureRedirectURL=\
/akc/servlet/DisplayServlet?url=SomeErrorURL&somearg={abc-arg}

#request 1
request.MoveReports1.classname=com.ai.db.DBRequestExecutor2
request.MoveReports1.stmt=some-select-statement

#request 2
request.MoveReports2.classname=com.ai.db.DBRequestExecutor2
request.MoveReports2.stmt=\
some-insert-or-delete-or-update-statement
request.MoveReports2.query_type=update