Can someone explain why this WHERE clause works WHERE ('Assignee Login ID' LIKE "%joeuser%") AND ('7' = 1)
but this one does _not_ WHERE ('Assignee Login ID' LIKE "%joeuser%") AND ('Status' = 1) The error it throws is Unknown field referenced in query line (position 51 (...) AND ('Status'^ = 1))) I double-checked and the field name for field 7 on this table is 'Status'. ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ -- Arsperl-users mailing list Arsperl-users@arsperl.org https://lists.sourceforge.net/lists/listinfo/arsperl-users