Re: [GENERAL] PGError: ERROR: missing FROM-clause entry for table

2010-11-25 Thread James B. Byrne
On Thu, November 25, 2010 21:58, Robert Treat wrote: > On Thu, Nov 25, 2010 at 9:21 PM, James B. Byrne > wrote: >> > > 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")

Re: [GENERAL] PGError: ERROR: missing FROM-clause entry for table

2010-11-25 Thread Robert Treat
On Thu, Nov 25, 2010 at 9:21 PM, James B. Byrne 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 ActiveRecor

[GENERAL] PGError: ERROR: missing FROM-clause entry for table

2010-11-25 Thread James B. Byrne
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_shipment