[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
SQL error printing Packing List.
- Subject: SQL error printing Packing List.
- From: "M Lubratt" <..hidden..>
- Date: Mon, 30 Apr 2007 22:24:38 -0500
FreeBSD 6.2
LS 1.1.12
I'm trying to print a packing slip and I'm getting the following error:
DBD::Pg::st execute failed: ERROR: column a.true does not exist
LINE 8: ORDER BY a.TRUE
^
Error!
SELECT p.partnumber, p.description, p.unit, a.qty,
pg.partsgroup, p.partnumber AS sku, p.assembly, p.id, p.bin
FROM assembly a
JOIN parts p ON (a.parts_id = p.id)
LEFT JOIN partsgroup pg ON (p.partsgroup_id = pg.id)
WHERE a.bom
= '1'
AND a.id = '11018'
ORDER BY a.TRUE
ERROR: column a.true does not exist
LINE 8: ORDER BY a.TRUE
^
I searched the archives/forums/bug tracker for this and I found 2 messages, one of which was saying it was being looked into, but there wasn't a followup after that.
Can anyone help with this?
Thanks!
Mark