SELECT Clicks,UniqueID,File FROM documents WHERE UniqueID = #id# UPDATE documents SET Clicks=1 WHERE UniqueID=#URL.id# UPDATE documents SET Clicks=#IncrementValue(RS1.Clicks)# WHERE UniqueID=#URL.id# There is an error in the url supplied.
SELECT DISTINCT category FROM documentscategories ORDER BY Category #DocumentsSort# SELECT DISTINCT Year FROM documents WHERE Year <> '' ORDER BY Year #DocumentsSort# SELECT DISTINCT Type FROM documents ORDER BY Type #documentsSort# SELECT Count(Type) AS sum FROM documents SELECT Count(Type) AS sum FROM documents WHERE Type = 'text' SELECT Count(Type) AS sum FROM documents WHERE Type = 'pdf' SELECT Count(Type) AS sum FROM documents WHERE Type = 'xml' SELECT Count(Type) AS sum FROM documents WHERE Type = 'html' SELECT Count(Type) AS sum FROM documents WHERE Type = 'link'

#RSDocumentCount.sum# documents; #RSDocumentCountText.sum# text, #RSDocumentCountHtml.sum# html, #RSDocumentCountXml.sum# XML, #RSDocumentCountPdf.sum# PDF and #RSDocumentCountLink.sum# links

SELECT Category,Year,Type FROM documents WHERE Category = '#RS1.Category#' WHERE Year = '#RS1.Year#' WHERE Type = '#RS1.Type#' ORDER BY Year, Month, Date, Author ASC #RS1.Category#,. #RS1.Year#,. #RS1.Type#,.

SELECT DISTINCT Category FROM documentscategories ORDER BY Category #DocumentsSort# SELECT DISTINCT Year FROM documents ORDER BY Year #DocumentsSort# SELECT DISTINCT Type FROM documents ORDER BY Type #documentsSort#

SELECT * FROM documents WHERE Category = '#RS1.Category#' WHERE Year = '#RS1.Year#' WHERE Type = '#RS1.Type#' ORDER BY Year, Month, Date, Author ASC

#RS1.Category#

#RS1.Year#

#RS1.Type#

#RS2.Description# [external link] (#RS2.Clicks#)
Date: #RS2.Date# #RS2.Month# #RS2.Year#	Date: n/a	Author: #RS2.Author#	Author: n/a
#RS2.InDetail#

SELECT * FROM filepacks WHERE id = 5 SELECT * FROM filepacks WHERE id = 7

#fulltitle#
#summarydes#
"#fulldes#"
Last revised on #dateFormat(lastrevised,"d-mmmm, yyyy")#

#fulltitle#
#summarydes#
#fulldes#
Last revised on #dateFormat(lastrevised,"d-mmmm, yyyy")#