4 messages in com.mysql.lists.mysqlRe: Sanity Check : Error in sql
FromSent OnAttachments
Stuart Felenstein26 Aug 2004 12:47 
Mike Johnson26 Aug 2004 13:01 
Keith Ivey26 Aug 2004 13:02 
Stuart Felenstein26 Aug 2004 13:04 
Subject:Re: Sanity Check : Error in sql
From:Stuart Felenstein (stua@yahoo.com)
Date:08/26/2004 01:04:38 PM
List:com.mysql.lists.mysql

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 Msg: Unknown column 'HS' in 'field list'

I tried adding where typeid = type but that makes not sense. I'm now wondering and running (after I post) if type is a no-no-word.

I know I post way to often.

Stuart

-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: