Hello All!
Version - 7.2.1
OS - FreeBSD
I've encountered the following error when ever doing a select
statement on any table in my DB:
PostgreSQL said: ERROR: Attribute 'id' not found
The select statement I'm doing is:
select * from s_users where ID = 1;
This fails when I do an "ID" or an "id".
I've tried it both in PHP PG Admin and from the command line.
My table looks like this:
CREATE TABLE "s_users" (
"ID" int8 DEFAULT nextval('"s_users_seq"'::text) NOT NULL,
"fname" text NOT NULL,
"lname" text NOT NULL,
"ako" text NOT NULL,
"phone" text,
"email" text NOT NULL,
"rank_id" int8,
"status_id" int8 DEFAULT 2 NOT NULL,
CONSTRAINT "s_users_pkey" PRIMARY KEY ("ID")
);
Anyone know why this is happening and how to fix it? Thanks in
advance!
Eric Jones (Contractor)
FDIC Web Enabler
E-mail: jonese@hua.army.mil
Office - 520-533-6628
Cell - 520-930-2136
Email Pager - 5209802136@messaging.nextel.com