arsperl-users

[Arsperl-users] Field id works but field name does not in query

[Franklin L. <ars...@le...>]

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'.

Re: [Arsperl-users] Field id works but field name does not in query

[Thilo S. <thi...@ap...>]

ars_LoadQualifier doesn't work with field names. According to the manual 
it should work with field labels, which of course are view-dependent. In 
this case the view name has to be passed to ars_LoadQualifier in the 
"displayTag" parameter (see the manual page).
Problems with field labels have been reported occasionally, so the 
preferred method probably is to always use field IDs only.


Regards,
Thilo


Franklin Lee wrote:
> 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
> Ars...@ar...
> https://lists.sourceforge.net/lists/listinfo/arsperl-users
>