Re: [SQL] ERROR: column "crc" does not exist

2007-04-12 Thread Bart Degryse
Try either - defining the field as: crc character varying(255) - rewrite your select as: Select * from base.points where "CRC" = 'e19e26330a0db2f2435106b16623fa82'; >>> <[EMAIL PROTECTED]> 2007-04-12 14:23 >>> Hi list, I have a table with many fields and the latest field is: "CRC" character var

Re: [SQL] ERROR: column "crc" does not exist

2007-04-12 Thread Andrew Sullivan
On Thu, Apr 12, 2007 at 09:23:39AM -0300, [EMAIL PROTECTED] wrote: > > "CRC" character varying(255), ^ > Select * from base.points where crc = 'e19e26330a0db2f2435106b16623fa82' ^^^ "CRC" != crc. You need to spell the column name correctly. Or don't quot

Re: [SQL] ERROR: column "crc" does not exist

2007-04-12 Thread A. Kretschmer
am Thu, dem 12.04.2007, um 9:23:39 -0300 mailte [EMAIL PROTECTED] folgendes: > Hi list, > > I have a table with many fields and the latest field is: > > "CRC" character varying(255), You have created a field called "CRC", with upper-case. > > When I try to access the table with a select wi

Re: [SQL] ERROR: column "crc" does not exist

2007-04-12 Thread George Weaver
Original Message From: <[EMAIL PROTECTED]> I have a table with many fields and the latest field is: "CRC" character varying(255), ^^ Select * from base.points where crc = 'e19e26330a0db2f2435106b16623fa82' What happens when you enter: Select * from base.points where "CRC" = 'e19e26

[SQL] ERROR: column "crc" does not exist

2007-04-12 Thread ezequias
Hi list, I have a table with many fields and the latest field is: "CRC" character varying(255), When I try to access the table with a select with a where clause like Select * from base.points where crc = 'e19e26330a0db2f2435106b16623fa82' The error on the Subject of this e-mail allways appear