Lana Brummett wrote:
> My husband just looked at the query and made the following change:
>
> # diff LedgerSMB/Form.pm.orig LedgerSMB/Form.pm
> 2399a2400
> > my $id_field = ( $vc eq 'customer' ) ? 'customer_id' : 'vendor_id';
> 2419c2420
> < WHERE ct.id <http://ct.id> = (select customer_id from
> $arap where $where AND ${vc}_id IS NOT NULL order by id DESC limit 1)|;
> ---
> > WHERE ct.id <http://ct.id> = (select $id_field from
> $arap where $where AND ${vc}_id IS NOT NULL order by id DESC limit 1)|;
>
> Was this the right thing to change or will this mess up something
> somewhere else? It seems to have fixed my problem but I just want to
> make sure that it will post right and that nothing else will break.
>
Yes. This is actually fixed in the upcoming 1.2.6.
Joshua D. Drake
> THanks again!
> Lana
>
> On 6/7/07, *Lana Brummett* <..hidden.. <mailto:..hidden..>>
> wrote:
>
> We just switched over from sql-ledger 2.6.12 and we installed
> ledgersmb 1.2.5 and I am trying to enter a vendor
> invoice for the first time. I get this error:
>
> *DBD::Pg::st execute failed: ERROR: column "customer_id" does not
> exist at character 189
> *
>
>
> Error!
>
> *
> SELECT ct.name <http://ct.name> AS vendor, ct.curr AS currency,
> ct.id <http://ct.id> AS vendor_id,
> current_date + ct.terms AS duedate,
> ct.notes ,
> ct.curr AS currency
> FROM vendor ct
> WHERE ct.id <http://ct.id> = (select customer_id from ap where 1 = 1
> AND vendor_id IS NOT NULL order by id DESC limit 1)
> ERROR: column "customer_id" does not exist at character 189
>
> It looks to me like it should be saying "select vendor_id" and not
> "select customer_id" but I can't see where this needs to be
> changed. Any help would be appreciated!
>
> Thanks,
> Lana
> *--
> Start your own business for $10, ask me how today!!!
> www.youravon.com/lanabrummett <http://www.youravon.com/lanabrummett>
> Having a party? Need a cake? Look no further, ask for details!!!!
> www.creativecakecreations.com <http://www.creativecakecreations.com>
> Call Today (847)687-5794
> Proud mom to Samantha www.yetanotherdomain.org/samantha
> <http://www.yetanotherdomain.org/samantha>
>
>
>
>
> --
> Start your own business for $10, ask me how today!!!
> www.youravon.com/lanabrummett <http://www.youravon.com/lanabrummett>
> Having a party? Need a cake? Look no further, ask for details!!!!
> www.creativecakecreations.com <http://www.creativecakecreations.com>
> Call Today (847)687-5794
> Proud mom to Samantha www.yetanotherdomain.org/samantha
> <http://www.yetanotherdomain.org/samantha>
>
>
> ------------------------------------------------------------------------
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users