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 = (select customer_id from $arap where $where
AND ${vc}_id IS NOT NULL order by id DESC limit 1)|;
---
WHERE 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.
THanks again!
Lana
On 6/7/07, Lana Brummett <[EMAIL PROTECTED]> 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 AS vendor, ct.curr AS currency, ct.id AS vendor_id,
current_date + ct.terms AS duedate,
ct.notes ,
ct.curr AS currency
FROM vendor ct
WHERE 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
Having a party? Need a cake? Look no further, ask for details!!!!
www.creativecakecreations.com
Call Today (847)687-5794
Proud mom to Samantha www.yetanotherdomain.org/samantha
--
Start your own business for $10, ask me how today!!!
www.youravon.com/lanabrummett
Having a party? Need a cake? Look no further, ask for details!!!!
www.creativecakecreations.com
Call Today (847)687-5794
Proud mom to Samantha 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
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
