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
Sort the listing
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#
PDF file XML file Text file HTML file HTML link
New document #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