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 named

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

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 MA