User Tools

Site Tools


reference:spamrules_statement_dbinsert

Spam Filter Rules: DBInsert

Statement DBInsert
Version 6.16+
Purpose Inserts a record into the spam filter database

The DBInsert statement requires a type, component name, key and value, in the format

DBInsert <type> <component name> <key> <value>
  • <type> may be either 'unique' or 'multi'
  • If <type> is 'unique', then the record will only be created if that component/key combination does not already exist
  • If <type> is 'multi', the record will always be created

Example

DBInsert unique sender ${Sender} 1

This will create a record for the 'sender' component with the key in the ${Sender} variable, with the value '1'. If ${Sender} already exists in the 'sender' component, then it will not be added. (To “update or insert” see the DBUpdate statement.)

reference/spamrules_statement_dbinsert.txt · Last modified: 2018/11/14 10:45 by 127.0.0.1