Category:

 

Database Connectivity

 

Description: 

 

Specifies that a column index is used in place of a column name, e.g., -dbreplacementids "<<first_name>>=2,<<last_name>>=1,<<company>>=3".Some databases do not handle column names well, so as an alternative, you can select columns by number.

 

Applies to -dbreplacementids and -dbemailcolumn. The example below shows both cases.

 

If your replacements are not working, try using -dbusecolumnindex.

 

Optional?

 

Yes.

 

Overrides:

 

None.

 

Overridden By:

 

None.

 

Other Parameters Required:

 

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

 

See Also:

 

-dbemailcolumn -dbreplacementids -dbquery -dbtable -dbuseaddressee -dsn -dbupdatequery -dbconstants

 

Usage:

 

-dbusecolumnindex

 

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

 

NetMailBot -dbusecolumnindex -dbemailcolumn "0" -dbreplacementids "$first_name$=1" -to email@domain.com -from email@domain.com -server mail.domain.com -subject "test" 

 

Comments:

 

None.