On Thu, Nov 25, 2010 at 9:21 PM, James B. Byrne
<byrnejb@harte-lyne.ca> wrote:
I am getting this error:
PGError: ERROR: missing FROM-clause entry for table "ca_customs_entry"
LINE 1: ..._entries"."is_cadex_transmitted" = 'f') ORDER BY
ca_customs...
The code is generated by a Ruby-on-Rails-3.0.1 ActiveRecord model:
SELECT "ca_customs_shipments".* FROM "ca_customs_shipments" INNER
JOIN "ca_customs_entries" ON
"ca_customs_entries"."ca_customs_shipment_id" =
"ca_customs_shipments"."id" WHERE
("ca_customs_entries"."is_cadex_transmitted" = 'f') ORDER BY
ca_customs_entry.is_across_transmitted,
ca_customs_entry.is_across_rejected,
ca_customs_entry.is_across_accepted,
ca_customs_entry.is_cadex_released LIMIT 5 OFFSET 0
Looks to me like the problem is you are trying to ORDER BY columns in "ca_customs_entry", but there is no such table for that (don't confuse it with "ca_customs_entries"). You need to either set a matching alias, or fix the table name qualifier in those order by columns.
Robert Treat