insert into #variables.tableprefix#messages(id,title,body,useridfk,threadidfk,posted,attachment,filename) values(, , , , , , , ) Title: #arguments.message.title# Thread: #tmpThread.name# Forum: #forum.name# Conference: #tmpConference.name# User: #arguments.username# #wrap(body,80)# #variables.settings.rootURL#/messages.cfm?threadid=#arguments.threadid#&last##last select filename from #variables.tableprefix#messages where id = delete from #variables.tableprefix#messages where id = select id, title, body, posted, useridfk, threadidfk, attachment, filename from #variables.tableprefix#messages where id = select #variables.tableprefix#messages.id, #variables.tableprefix#messages.title, #variables.tableprefix#messages.body, #variables.tableprefix#messages.attachment, #variables.tableprefix#messages.filename, #variables.tableprefix#messages.posted, #variables.tableprefix#messages.threadidfk, #variables.tableprefix#messages.useridfk, #variables.tableprefix#threads.name as threadname, #variables.tableprefix#users.username, #variables.tableprefix#forums.name as forumname, #variables.tableprefix#conferences.name as conferencename from (((#variables.tableprefix#messages left join #variables.tableprefix#threads on #variables.tableprefix#messages.threadidfk = #variables.tableprefix#threads.id) left join #variables.tableprefix#forums on #variables.tableprefix#threads.forumidfk = #variables.tableprefix#forums.id) left join #variables.tableprefix#conferences on #variables.tableprefix#forums.conferenceidfk = #variables.tableprefix#conferences.id) left join #variables.tableprefix#users on #variables.tableprefix#messages.useridfk = #variables.tableprefix#users.id where #variables.tableprefix#messages.threadidfk = order by posted asc select distinct #variables.tableprefix#subscriptions.useridfk, #variables.tableprefix#users.emailaddress from #variables.tableprefix#subscriptions, #variables.tableprefix#users where (#variables.tableprefix#subscriptions.threadidfk = or #variables.tableprefix#subscriptions.forumidfk = or #variables.tableprefix#subscriptions.conferenceidfk = ) and #variables.tableprefix#subscriptions.useridfk <> and #variables.tableprefix#subscriptions.useridfk = #variables.tableprefix#users.id A post has been made to a thread, forum, or conference that you are subscribed to. You can change your subscription preferences by updating your profile. You can visit the thread here: #variables.settings.rootURL#/messages.cfm?threadid=#arguments.threadid#&last##last Conference: #conference.name# Forum: #forum.name# Thread: #arguments.threadname# User: #username# Message: #wrap(arguments.body,80)# "> #quotename# said:#quoteportion#"> No HTML is allowed in your message. Basic Formatting Rules:

[b]...[/b] for bold
[i]...[/i] for italics
[code]...[/code] for code

[pre]...[/pre] for preformatted text
[link]...[/link] for URLs
[img]...[/img] for images

View Complete BBML Syntax DBML support courtesy of DP_ParseBBML

update #variables.tableprefix#messages set title = , body = , threadidfk = , useridfk = , posted = , attachment = , filename = where id = select m.id, m.title, m.threadidfk, t.forumidfk, f.conferenceidfk from #variables.tableprefix#messages m, #variables.tableprefix#threads t, #variables.tableprefix#forums f where m.threadidfk = t.id and t.forumidfk = f.id and ( (title like or body like '%#aTerms[x]#%' ) #joiner# title like or body like '%#arguments.searchTerms#%' )