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* <[EMAIL PROTECTED] <mailto:[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 <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 > [email protected] > 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 [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
