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
> Arsperl-users@arsperl.org
> https://lists.sourceforge.net/lists/listinfo/arsperl-users
> 


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

Reply via email to