----- Original Message -----
From: "Josh Hillman" <admin-maillist@talstar.com>
To: <emerald@iea-software.com>
Sent: Thursday, May 25, 2000 3:13 PM
Subject: Re: [Emerald] billing type
> From: Jeremiah Fulbright <support@pwtel.net>
> > hrmm...... what is the actual lines to type into query analyzer.......
> >
> > need it for Email - Plain Text and Email - HTML
> > to Postal Mail
>
> update masteraccounts
> set sendmethod=0 -- Postal Mail
> where sendmethod=1 -- Email - Text
> or sendmethod=2 -- Email - HTML
>
> Emerald translates the numeric values to the text when you see it in
> Emerald. The names aren't stored in the database anywhere. 3 represents
> "None".
>
> Josh
>
> > ----- Original Message -----
> > From: "Josh Hillman" <admin-maillist@talstar.com>
> > To: <emerald@iea-software.com>
> > Sent: Thursday, May 25, 2000 2:19 PM
> > Subject: Re: [Emerald] billing type
> >
> >
> > > From: Jeremiah Fulbright <support@pwtel.net>
> > > > IS there a query that can be ran to change all Invoice types from
> Email,
> > > to
> > > > Postal Mail?
> > >
> > > update masteraccounts
> > > set sendmethod=0
> > > where sendmethod=1
> > >
> > >
> > > For more information about this list (including removal) go to:
> > > http://www.iea-software.com/support/maillists/liststart
> >
> >
> > For more information about this list (including removal) go to:
> > http://www.iea-software.com/support/maillists/liststart
> >
>
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart