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

[Ryan]

Nope that did not fix it.

On Thu, Dec 10, 2009 at 5:53 PM, Jason Etheridge <jason at esilibrary.com>wrote:

> > 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
>



-- 
Ryan Laverdiere
Head Webmaster: http://www.my-ne.com
Blog: http://www.capecodtoday.com/blogs/index.php/Tracker
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20091210/3e390182/attachment.htm