Re: Sanity Check : Error in sql

2004-08-26 Thread Stuart Felenstein
Okay ..got to be looking for id's with string, not numerics. Case closed. Oi Stuart --- Stuart Felenstein <[EMAIL PROTECTED]> wrote: > I'm running into a problem here where mySQL is > saying > unknown column. > Education_table > TypeID Type > HS High School > CO College > M

Re: Sanity Check : Error in sql

2004-08-26 Thread Keith Ivey
Stuart Felenstein wrote: SQL: Select * from Education_table (and no the table is not named table) From: TypeID = Value , Type = Label Choose High School Error Msg: Unknown column 'HS' in 'field list' You need to show the exact SQL statement that you're sending. Obviously "SELECT * FROM Educa

RE: Sanity Check : Error in sql

2004-08-26 Thread Mike Johnson
From: Stuart Felenstein [mailto:[EMAIL PROTECTED] > I'm running into a problem here where mySQL is saying > unknown column. > Education_table > TypeID Type > HS High School > CO College > MA Masters > > SQL: > Select * from Education_table (and no the table is not >

Sanity Check : Error in sql

2004-08-26 Thread Stuart Felenstein
I'm running into a problem here where mySQL is saying unknown column. Education_table TypeID Type HS High School CO College MA Masters SQL: Select * from Education_table (and no the table is not named table) From: TypeID = Value , Type = Label Choose High School Error