(and if it *isn't* numeric, you'll need the single quotes around the value in your where clause) ... WHERE IFeel = 'Really dumb' what's the datatype of the user_id column? is it varchar or numeric? if it's numeric, try a cfsqltype of "cf_sql_numeric" instead.