[Arsperl-users] Field id works but field name does not in query
Brought to you by:
jeffmurphy
|
From: Franklin L. <ars...@le...> - 2008-11-25 18:09:17
|
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'.
|