INSERT INTO dbo.JWhiteArt (ADate, ATitle, AMain1, APublish) VALUES ( NULL , '' , '' , '' ) DELETE FROM dbo.JWhiteArt WHERE ID = '#Form.DeleteArticleID#' UPDATE dbo.JWhiteArt SET ADate= NULL , ATitle= '' , AMain1= '' , APublish= '' WHERE ID= UPDATE dbo.JWhiteArt SET APublish= 'Yes' 'No' WHERE ID= GC LAX | ALUMNI
SELECT * FROM dbo.JWhiteArt WHERE ID = '#URL.a#' ORDER BY ADate DESC SELECT * FROM dbo.JWhiteArt WHERE APublish = 'Yes' ORDER BY ADate DESC

Jake White's Articles

#rsJakeWReport.ATitle# #DATEFORMAT(rsJakeWReport.ADate, "mm/dd/yyyy")#

#rsJakeWReport.AMain1#
SELECT * FROM dbo.JWhiteArt ORDER BY ADate DESC

Article Archives

SELECT * FROM dbo.JWhiteArt ORDER BY ADate DESC

Article Archives
Article Title:

Main Body:

Publish:
Yes | No


SELECT * FROM dbo.JWhiteArt WHERE ID = #FORM.JWArticleID#
Article Title:

Main Body:
Publish:
Yes checked="checked" /> | No checked="checked" />
 SELECT * FROM dbo.JWhiteArt WHERE ID = '#URL.a#' ORDER BY ADate DESC SELECT * FROM dbo.JWhiteArt WHERE ID = '#FORM.ArticleID#' ORDER BY ADate DESC

Jake White's Articles

#rsJakeWReport.ATitle# #DATEFORMAT(rsJakeWReport.ADate, "m/d/yyyy")#

#rsJakeWReport.AMain1#
JS IW CW P