INSERT INTO thescenenewscomments (blogID, obcTime, nick, subject, comment) VALUES ( #FORM.newsID#NULL, #CreateODBCDateTime(ParseDateTime(FORM.obcTime))#NULL, '#FORM.nick#'NULL, '#FORM.subject#'NULL, '#FORM.comment#'NULL) SELECT id, Views FROM thescenenews WHERE id = #url.id# UPDATE thescenenews SET Views='1' WHERE id=#url.ID# UPDATE thescenenews SET Views='#IncrementValue(TSNRS.Views)#' WHERE id=#url.ID# There is an error in the url supplied. There is an error in the url supplied. Note this form seems to have problems with some browsers such as Google's Chrome. SELECT Title FROM thescenenews WHERE id = #url.id# ORDER BY id DESC Defacto2 - #newsRS.Title# Defacto2 - News Item
SELECT * FROM thescenenews WHERE id = #url.id# ORDER BY id DESC SELECT * FROM thescenenewscomments WHERE blogID = #url.id# ORDER BY obcTime DESC
The Scene News logo
#newsRS.Title# #newsRS.Title#
#newsRS.source# | #LSDateFormat(DateConvert('local2utc',newsRS.OBCTime),'DD MMM YYYY')# (#LSTimeFormat(DateConvert('local2utc',newsRS.OBCTime),'h:mm tt')#) GMT | #newsRS.Author# | 0#newsRS.Views# clicks
#newsRS.Description#
#subject#
by #nick#   #LSTimeFormat(DateConvert('local2utc',obcTime),'h:mm')##LSTimeFormat(DateConvert('local2utc',obcTime),'tt')# #LSDateFormat(DateConvert('local2utc',obcTime),'d.mmm.yyyy')# GMT
You can use these format tags in the comment field to modify the format of your text [a][/a] insert a hyperlink, example [a]http://www.defacto2.net[/a] [b][/b] strong text [i][/i] italic text [u][/u] underlined text