Category:

 

Database Connectivity

 

Description: 

 

Performs a database query after an email is sent in non-TEST mode.  The query itself can contain database replacement ids as specified in -dbreplacementids or -dbconstants.

 

Optional?

 

Yes.

 

Overrides:

 

None.

 

Overridden By:

 

-test

 

Other Parameters Required:

 

-to (required if -dbuseaddressee is NOT "to") -from -server

 

See Also:

 

-dbemailcolumn -dbusecolumnindex -dbreplacementids -dbtable -dbuseaddressee -dsn -dbconstants

 

Usage:

 

-dbupdatequery "<SQL query string>"

 

Example (cut-and-paste right into your batch file):

 

NetMailBot -dsn "mydb" -dbupdatequery "UPDATE tableName SET flag=1 WHERE email=$email$" -dbemailcolumn "email" -to email@domain.com -from email@domain.com -server mail.domain.com -subject "test" 

 

Comments:

 

None.