insert into tblblogcategories(categoryid,categoryname,categoryalias,blog) values( , , , ) insert into tblblogcomments(id,entryidfk,name,email,website,comments,posted,subscribe,moderated,killcomment,subscribeonly) values(, , , , , , , , ,01, , ) update tblblogcomments set subscribe = 0 where entryidfk = and email = insert into tblblogentries(id,title,body,posted ,morebody ,alias ,username,blog,allowcomments,enclosure,summary,subtitle,keywords,duration,filesize,mimetype,released,views,mailed) values( , , , , , , , ,, , , , , , , , , , ,0 , ) select email from tblblogsubscribers where email = and blog = insert into tblblogsubscribers(email, token, blog, verified) values(, , , 0 ) select id from tblblogtrackbacks where blogName = and title = and postURL = insert into tblblogtrackbacks (id, title, posturl, blogname, excerpt, created, entryid, blog) values ( , , , , , , , , ) update tblblogcomments set moderated = where id = select categoryidfk from tblblogentriescategories where categoryidfk = and entryidfk = insert into tblblogentriescategories(categoryidfk,entryidfk) values(,) select username from tblusers where username = and password = and username in () select categoryid from tblblogcategories where categoryid = categoryname = and blog = update tblblogsubscribers set verified = 1 where token = where email = delete from tblblogentriescategories where categoryidfk = delete from tblblogcategories where categoryid = delete from tblblogcomments where id = delete from tblblogentries where id = and blog = delete from tblblogentriescategories where entryidfk = delete from tblblogcomments where entryidfk = delete from tblblogtrackbacks where id = select tblblogentries.id from tblblogentries where tblblogentries.id = and tblblogentries.blog = and posted < and released = 1 #xmlFormat(instance.blogTitle)##xmlFormat(arguments.additionalTitle)# #xmlFormat(instance.blogDescription)# #xmlFormat(instance.blogURL)# #xmlFormat(title)# ]*>","","ALL")) gte arguments.excerpt>#xmlFormat(left(REReplaceNoCase(body,"<[^>]*>","","ALL"),arguments.excerpt))#...#xmlFormat(body)# [More] #xmlFormat(makeLink(id))# #dateStr# #xmlFormat(catlist)# ")> #xmlFormat(instance.blogTitle)##xmlFormat(arguments.additionalTitle)# #xmlFormat(instance.blogURL)# #xmlFormat(instance.blogDescription)# #replace(lcase(instance.locale),'_','-','one')# #dateFormat(blogNow(),"ddd, dd mmm yyyy") & " " & timeFormat(blogNow(),"HH:mm:ss") & utcPrefix & numberFormat(z.utcHourOffset,"00") & "00"# {LAST_BUILD_DATE} BlogCFC http://blogs.law.harvard.edu/tech/rss #xmlFormat(instance.owneremail)# #xmlFormat(instance.owneremail)# #xmlFormat(instance.itunesSubtitle)# #xmlFormat(instance.itunesSummary)# #xmlFormat(instance.itunesKeywords)# #xmlFormat(instance.itunesAuthor)# #xmlFormat(instance.owneremail)# #xmlFormat(instance.itunesAuthor)# #xmlFormat(instance.itunesImage)# #xmlFormat(instance.blogTitle)# #xmlFormat(instance.blogURL)# #xmlFormat(instance.itunesExplicit)# #xmlFormat(title)# #xmlFormat(makeLink(id))# ]*>","","ALL")) gte arguments.excerpt> #xmlFormat(left(REReplace(body,"<[^>]*>","","All"),arguments.excerpt))#... #xmlFormat(body)# [More] #xmlFormat(categories[currentRow][catid])# #dateStr# #xmlFormat(makeLink(id))# #xmlFormat(instance.itunesAuthor)# #xmlFormat(instance.itunesExplicit)# #xmlFormat(duration)# #xmlFormat(keywords)# #xmlFormat(subtitle)# #xmlFormat(summary)# ")> select distinct datepart(dd, #preserveSingleQuotes(posted)#) extract(day from #preserveSingleQuotes(posted)#) datepart('d', #preserveSingleQuotes(posted)#) to_char(#preserveSingleQuotes(posted)#, 'dd') as posted_day from tblblogentries where #preserveSingleQuotes(posted)# >= and #preserveSingleQuotes(posted)# <= and blog = and #preserveSingleQuotes(posted)# < and released = 1 select tblblogcategories.categoryid, tblblogcategories.categoryname, tblblogcategories.categoryalias, count(tblblogentriescategories.entryidfk) as entryCount from (tblblogcategories left outer join tblblogentriescategories ON tblblogcategories.categoryid = tblblogentriescategories.categoryidfk) left join tblblogentries on tblblogentriescategories.entryidfk = tblblogentries.id where tblblogcategories.blog = and isNull(tblblogentries.posted, '1/1/1900') < and isNull(tblblogentries.released, 1) = 1 group by tblblogcategories.categoryid, tblblogcategories.categoryname, tblblogcategories.categoryalias order by tblblogcategories.categoryname select tblblogcategories.categoryid, tblblogcategories.categoryname, tblblogcategories.categoryalias from tblblogcategories where tblblogcategories.blog = order by tblblogcategories.categoryname select count(tblblogentriescategories.entryidfk) as total from tblblogentriescategories, tblblogentries where tblblogentriescategories.categoryidfk = and tblblogentriescategories.entryidfk = tblblogentries.id and tblblogentries.released = 1 select tblblogcategories.categoryID, tblblogcategories.categoryname from tblblogcategories, tblblogentriescategories where tblblogcategories.categoryID = tblblogentriescategories.categoryidfk and tblblogentriescategories.entryidfk = select categoryname, categoryalias from tblblogcategories where categoryid = and blog = select categoryid from tblblogcategories where categoryalias = and blog = select categoryid from tblblogcategories where categoryname = and blog = select id, entryidfk, name, email, website, comments, posted, subscribe, moderated, killcomment from tblblogcomments where id = select id, entryidfk, name, email, website, comments AS comment, posted, subscribe, moderated, killcomment from getC select tblblogcomments.id, tblblogcomments.name, tblblogcomments.email, tblblogcomments.website, tblblogcomments.commentto_char(tblblogcomments.comments) as comments, tblblogcomments.posted, tblblogcomments.subscribe, tblblogentries.title as entrytitle, tblblogcomments.entryidfk from tblblogcomments, tblblogentries where tblblogcomments.entryidfk = tblblogentries.id and ( tblblogcomments.comment comments like or tblblogcomments.name like ) and tblblogcomments.entryidfk = and tblblogentries.blog = and tblblogcomments.moderated = 1 and (subscribeonly = 0 or subscribeonly is null) order by tblblogcomments.posted #arguments.sortdir# select id, name, email, website, comments AS comment, posted, subscribe, entrytitle, entryidfk from getC order by posted #arguments.sortdir# select tblblogentries.id, tblblogentries.title, dateAdd('h', #instance.offset#, tblblogentries.posted) as posted, dateAdd(hh, #instance.offset#, tblblogentries.posted) as posted, tblblogentries.posted + (#instance.offset#/24) as posted, date_add(posted, interval #instance.offset# hour) as posted, tblblogentries.body, tblblogentries.morebody, tblblogentries.alias, tblusers.name, tblblogentries.allowcomments, tblblogentries.enclosure, tblblogentries.filesize, tblblogentries.mimetype, tblblogentries.released, tblblogentries.mailed, tblblogentries.summary, tblblogentries.keywords, tblblogentries.subtitle, tblblogentries.duration from tblblogentries, tblusers where tblblogentries.id = and tblblogentries.blog = and tblblogentries.username = tblusers.username select categoryid,categoryname from tblblogcategories, tblblogentriescategories where tblblogentriescategories.entryidfk = and tblblogentriescategories.categoryidfk = tblblogcategories.categoryid update tblblogentries set views = views + 1 where id = SELECT * FROM ( select top #arguments.params.maxEntries# tblblogentries.id, tblblogentries.title, tblblogentries.alias, dateAdd('h', #instance.offset#, tblblogentries.posted) as posted, dateAdd(hh, #instance.offset#, tblblogentries.posted) as posted, tblblogentries.posted + (#instance.offset#/24) as posted, date_add(posted, interval #instance.offset# hour) as posted, tblusers.name, tblblogentries.allowcomments, tblblogentries.enclosure, tblblogentries.filesize, tblblogentries.mimetype, tblblogentries.released, tblblogentries.views, tblblogentries.summary, tblblogentries.subtitle, tblblogentries.keywords, tblblogentries.duration , tblblogentries.body, tblblogentries.morebody from tblblogentries, tblusers ,tblblogentriescategories where 1=1 and blog = and tblblogentries.username = tblusers.username and tblblogentries.posted >= and day(dateAdd(hh, #instance.offset#, tblblogentries.posted)) and day(dateAdd('h', #instance.offset#, tblblogentries.posted)) and dayOfMonth(date_add(posted, interval #instance.offset# hour)) and to_number(to_char(tblblogentries.posted + (#instance.offset#/24), 'dd')) = = and month(dateAdd(hh, #instance.offset#, tblblogentries.posted)) = and month(dateAdd('h', #instance.offset#, tblblogentries.posted)) = and month(date_add(posted, interval #instance.offset# hour)) = and to_number(to_char(tblblogentries.posted + (#instance.offset#/24), 'MM')) = and year(dateAdd(hh, #instance.offset#, tblblogentries.posted)) = and year(dateAdd('h', #instance.offset#, tblblogentries.posted)) = and year(date_add(posted, interval #instance.offset# hour)) = and to_number(to_char(tblblogentries.posted + (#instance.offset#/24), 'YYYY')) = and tblblogentries.title = and tblblogentriescategories.entryidfk = tblblogentries.id and tblblogentriescategories.categoryidfk in () and (tblblogentries.title like '%#arguments.params.searchTerms#%' OR tblblogentries.body like '%#arguments.params.searchTerms#%' or tblblogentries.morebody like '%#arguments.params.searchTerms#%') and (lower(tblblogentries.title) like '%#lcase(arguments.params.searchTerms)#%' OR lower(tblblogentries.body) like '%#lcase(arguments.params.searchTerms)#%' or lower(tblblogentries.morebody) like '%#lcase(arguments.params.searchTerms)#%') and tblblogentries.id = and tblblogentries.alias = and to_char(tblblogentries.posted + (#instance.offset#/24), 'YYYY-MM-DD HH24:MI:SS') <= and posted < and released = 1 order by tblblogentries.#arguments.params.orderBy# #arguments.params.orderByDir# limit #arguments.params.maxEntries# ) WHERE rownum <= #arguments.params.maxEntries# select count(id) as commentCount, entryidfk from tblblogcomments where entryidfk in () and moderated = 1 and (subscribeonly = 0 or subscribeonly is null) group by entryidfk select categoryid,categoryname from tblblogcategories, tblblogentriescategories where tblblogentriescategories.entryidfk = and tblblogentriescategories.categoryidfk = tblblogcategories.categoryid select count(id) as trackbackCount, entryid from tblblogtrackbacks where entryid in () group by entryid select tblblogentries.id from tblblogentries, tblusers ,tblblogentriescategories where 1=1 and blog = and tblblogentries.username = tblusers.username and tblblogentries.posted >= and day(dateAdd(hh, #instance.offset#, tblblogentries.posted)) and day(dateAdd('h', #instance.offset#, tblblogentries.posted)) and dayOfMonth(date_add(posted, interval #instance.offset# hour)) and to_number(to_char(tblblogentries.posted + (#instance.offset#/24), 'dd')) = = and month(dateAdd(hh, #instance.offset#, tblblogentries.posted)) = and month(dateAdd('h', #instance.offset#, tblblogentries.posted)) = and month(date_add(posted, interval #instance.offset# hour)) = and to_number(to_char(tblblogentries.posted + (#instance.offset#/24), 'MM')) = and year(dateAdd(hh, #instance.offset#, tblblogentries.posted)) = and year(dateAdd('h', #instance.offset#, tblblogentries.posted)) = and year(date_add(posted, interval #instance.offset# hour)) = and to_number(to_char(tblblogentries.posted + (#instance.offset#/24), 'YYYY')) = and tblblogentries.title = and tblblogentriescategories.entryidfk = tblblogentries.id and tblblogentriescategories.categoryidfk in () and (tblblogentries.title like '%#arguments.params.searchTerms#%' OR tblblogentries.body like '%#arguments.params.searchTerms#%' or tblblogentries.morebody like '%#arguments.params.searchTerms#%') and (lower(tblblogentries.title) like '%#lcase(arguments.params.searchTerms)#%' OR lower(tblblogentries.body) like '%#lcase(arguments.params.searchTerms)#%' or lower(tblblogentries.morebody) like '%#lcase(arguments.params.searchTerms)#%') and tblblogentries.id = and tblblogentries.alias = and to_char(tblblogentries.posted + (#instance.offset#/24), 'YYYY-MM-DD HH24:MI:SS') <= and posted < and released = 1 order by tblblogentries.#arguments.params.orderBy# #arguments.params.orderByDir# select tblblogentries.id, tblblogentries.title, tblblogentries.alias, dateAdd('h', #instance.offset#, tblblogentries.posted) as posted, dateAdd(hh, #instance.offset#, tblblogentries.posted) as posted, tblblogentries.posted + (#instance.offset#/24) as posted, date_add(posted, interval #instance.offset# hour) as posted, tblusers.name, tblblogentries.allowcomments, tblblogentries.enclosure, tblblogentries.filesize, tblblogentries.mimetype, tblblogentries.released, tblblogentries.views, tblblogentries.summary, tblblogentries.subtitle, tblblogentries.keywords, tblblogentries.duration , tblblogentries.body, tblblogentries.morebody from tblblogentries, tblusers where tblblogentries.id in () and blog = and tblblogentries.username = tblusers.username order by tblblogentries.#arguments.params.orderBy# #arguments.params.orderByDir# select count(id) as commentCount, entryidfk from tblblogcomments where entryidfk in () and moderated = 1 and (subscribeonly = 0 or subscribeonly is null) group by entryidfk select categoryid,categoryname from tblblogcategories, tblblogentriescategories where tblblogentriescategories.entryidfk = and tblblogentriescategories.categoryidfk = tblblogcategories.categoryid select count(id) as trackbackCount, entryid from tblblogtrackbacks where entryid in () group by entryid select name from tblusers where username = select count(c.moderated) as unmoderated from tblblogcomments c, tblblogentries e where c.moderated=0 and e.blog = and c.entryidfk = e.id SELECT * FROM ( select top #arguments.maxEntries# e.id as entryID, e.title, c.id, c.entryidfk, c.name, c.commentto_char(c.comments) as comments, dateAdd('h', #instance.offset#, c.posted) as posted dateAdd(hh, #instance.offset#, c.posted) as posted c.posted + (#instance.offset#/24) as posted date_add(c.posted, interval #instance.offset# hour) as posted from tblblogcomments c inner join tblblogentries e on c.entryidfk = e.id where blog = and c.moderated = 1 order by c.posted desc limit #arguments.maxEntries# ) WHERE rownum <= #arguments.maxEntries# SELECT entryID, title, id, entryidfk, name, comments AS comment, posted FROM getRecentComments ORDER BY posted desc select posted from tblblogentries where id = select distinct relatedid from tblblogentriesrelated where entryid = union select distinct entryid as relatedid from tblblogentriesrelated where relatedid = select tblblogentries.id, tblblogentries.title, tblblogentries.posted, tblblogentries.alias, tblblogcategories.categoryname from (tblblogcategories inner join tblblogentriescategories on tblblogcategories.categoryid = tblblogentriescategories.categoryidfk) inner join tblblogentries on tblblogentriescategories.entryidfk = tblblogentries.id where tblblogentries.id = and tblblogentries.blog = and tblblogentries.posted <= #createodbcdatetime(qthisentry.posted)# and tblblogentries.posted <= select * from qrelatedentries order by posted desc select tblblogcategories.categoryname, tblblogentries.id, tblblogentries.title, tblblogentries.posted from tblblogentries inner join (tblblogcategories inner join tblblogentriescategories on tblblogcategories.categoryid = tblblogentriescategories.categoryidfk) on tblblogentries.id = tblblogentriescategories.entryidfk where tblblogcategories.blog = order by tblblogcategories.categoryname, tblblogentries.posted, tblblogentries.title select email, token, verified from tblblogsubscribers where blog = and verified = 1 order by email asc select id, title, posturl, excerpt, created, entryid, blogname from tblblogtrackbacks where id = select id, title, posturl, excerpt, created, blogname from tblblogtrackbacks where blog = and entryid = order by created #arguments.sortdir# select tblblogcomments.id, tblblogcomments.name, tblblogcomments.email, tblblogcomments.website, tblblogcomments.commentto_char(tblblogcomments.comments) as comments, tblblogcomments.posted, tblblogcomments.subscribe, tblblogentries.title as entrytitle, tblblogcomments.entryidfk from tblblogcomments, tblblogentries where tblblogcomments.entryidfk = tblblogentries.id and tblblogcomments.entryidfk = and tblblogentries.blog = and tblblogcomments.moderated = 0 order by tblblogcomments.posted #arguments.sortdir# select id, name, email, website, comments AS comment, posted, subscribe, entrytitle, entryidfk from getC order by posted #arguments.sortdir# delete from tblblogcomments where killcomment = insert into tblblogsearchstats(searchterm, searched, blog) values( , , )

#entry.title#

URL: #makeLink(entry.id)#
Author: #entry.name#
#renderEntry(entry.body,false,entry.enclosure)# [Continued at Blog]

You are receiving this email because you have subscribed to this blog.
To unsubscribe, please go to this URL: #getRootURL()#unsubscribe.cfm?email=#email#&token=#token#

#theMessage# #theMessage# update tblblogentries set mailed = where id = select categoryalias from tblblogcategories where categoryid = select posted, alias from tblblogentries where id = #theMessage# #theMessage# delete from tblblogentriescategories where categoryidfk = and entryidfk = delete from tblblogentriescategories where entryidfk = select email from tblblogsubscribers where email = and token = delete from tblblogsubscribers where email = and token = and blog = delete from tblblogsubscribers where blog = and verified = 0 ",arguments.string) and findNoCase("",arguments.string)> ",arguments.string)> )(.*)()(.*)",arguments.string,1,1)> ",arguments.string,counter)> " & arguments.string> " & arguments.string> "> update tblblogcategories set categoryname = , categoryalias = where categoryid = update tblblogcomments set name = , email = , website = , comment = , comments = , subscribe = , moderated= where id = update tblblogentries set title = , body = body = ,morebody = ,morebody = ,morebody = ,morebody = ,alias = ,posted = ,allowcomments = ,allowcomments = ,enclosure = ,summary = ,subtitle = ,keywords = ,duration = ,filesize = ,mimetype = ,released = ,released = where id = and blog = delete from tblblogentriesrelated where entryid = insert into tblblogentriesrelated( entryid, relatedid ) values ( , ) update tblblogcomments set moderated=1 where id= select entryidfk from tblblogcomments where id = and email = update tblblogcomments set subscribe = 0 where entryidfk = and email = select password from tblusers where username = and password = update tblusers set password = where username = " & arguments.strTextBlock & "

", "\r+\n\r+\n", "

", "ALL") />