[OPEN-ILS-DEV] ***SPAM*** Re: 1.6 Billing Problem

[Jason Etheridge]

> INSERT INTO config.billing_type (id, name, owner) SELECT DISTINCT 101,
> oils_i18n_gettext(101, 'Misc', 'cbt', 'name'), 1 FROM
> config.billing_type_id_seq WHERElast_value < 101;
> SELECT SETVAL('config.billing_type_id_seq'::TEXT, 101) FROM
> config.billing_type_id_seq WHERE last_value < 101;

Or rather:

INSERT INTO config.billing_type (id, name, owner) SELECT DISTINCT 101,
oils_i18n_gettext(101, 'Misc', 'cbt', 'name'), 1 FROM
config.billing_type_id_seq WHERE last_value < 101;
SELECT SETVAL('config.billing_type_id_seq'::TEXT, 101) FROM
config.billing_type_id_seq WHERE last_value < 101;

Lost a space between WHERE and last_value in my previous cut/paste.

-- 
Jason Etheridge
 | VP, Tactical Development
 | Equinox Software, Inc. / The Evergreen Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  jason at esilibrary.com
 | web:  http://www.esilibrary.com

Please come by and visit the Equinox team
and learn more about Evergreen
ALA MidWinter
January 15-18, 2010
booth # 2064