arsperl-users

[Arsperl-users] ars_LoadQualification problem...

[<Chr...@Ve...>]

Hi,

Bizarre problem.  I have a program I wrote on Windows (ActiveState Perl
5.8/ARSperl 1.82) that worked fine (for more than 1 week with hundreds of
entries).  After putting it on the UNIX box (Solaris 8/Perl 5.8/ARSperl
1.83) this happens...

I'm iterating through a list of logins and calling ars_LoadQualication as
follows for every login:

$queryForThis = "'Login Name +' = \"$loginOld\"";
( $q = ars_LoadQualifier( $c, "User", $queryForThis ) ) || die $ars_errstr;

This always works on the first time.  However, on the second try it will
always fail and pass back:
 [ERROR] Unknown field referenced in query line (position 14   ('Login Name
+'^=...  

I know that is the name of the field on User.  I can paste the query line
directly into the advanced search bar (immediately before it fails) on User
and it works every time.  I tried to set $q and $c to undef after using them
but that didn't work either.  Any ideas?  The boss wants this run off the
UNIX box and not a PC...

--Chris  
___________________________________________________________________
The information contained in this message and any attachment may be
proprietary, confidential, and privileged or subject to the work
product doctrine and thus protected from disclosure.  If the reader
of this message is not the intended recipient, or an employee or
agent responsible for delivering this message to the intended
recipient, you are hereby notified that any dissemination,
distribution or copying of this communication is strictly prohibited.
If you have received this communication in error, please notify me
immediately by replying to this message and deleting it and all
copies and backups thereof.  Thank you.

Re: [Arsperl-users] ars_LoadQualification problem...

[David A. <D.J...@so...>]

Chris,

I believe that ars_LoadQualification uses the field label rather than the 
field name, though that doesn't explain what you're seeing.

You could try the workaround of replacing 'Login Name +' with the fieldId in 
single quotes.

David Adams
Corporate Information Services
Information Systems Services
University of Southampton

----- Original Message ----- 
From: <Chr...@Ve...>
To: <ars...@ar...>
Sent: Thursday, May 12, 2005 10:30 PM
Subject: [Arsperl-users] ars_LoadQualification problem...


> Hi,
>
> Bizarre problem.  I have a program I wrote on Windows (ActiveState Perl
> 5.8/ARSperl 1.82) that worked fine (for more than 1 week with hundreds of
> entries).  After putting it on the UNIX box (Solaris 8/Perl 5.8/ARSperl
> 1.83) this happens...
>
> I'm iterating through a list of logins and calling ars_LoadQualication as
> follows for every login:
>
> $queryForThis = "'Login Name +' = \"$loginOld\"";
> ( $q = ars_LoadQualifier( $c, "User", $queryForThis ) ) || die 
> $ars_errstr;
>
> This always works on the first time.  However, on the second try it will
> always fail and pass back:
> [ERROR] Unknown field referenced in query line (position 14   ('Login Name
> +'^=...
>
> I know that is the name of the field on User.  I can paste the query line
> directly into the advanced search bar (immediately before it fails) on 
> User
> and it works every time.  I tried to set $q and $c to undef after using 
> them
> but that didn't work either.  Any ideas?  The boss wants this run off the
> UNIX box and not a PC...
>
> --Chris
> ___________________________________________________________________
> The information contained in this message and any attachment may be
> proprietary, confidential, and privileged or subject to the work
> product doctrine and thus protected from disclosure.  If the reader
> of this message is not the intended recipient, or an employee or
> agent responsible for delivering this message to the intended
> recipient, you are hereby notified that any dissemination,
> distribution or copying of this communication is strictly prohibited.
> If you have received this communication in error, please notify me
> immediately by replying to this message and deleting it and all
> copies and backups thereof.  Thank you.
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by Oracle Space Sweepstakes
> Want to be the first software developer in space?
> Enter now for the Oracle Space Sweepstakes!
> http://ads.osdn.com/?ad_id=7393&alloc_id=16281&op=click
> _______________________________________________
> Arsperl-users mailing list
> Ars...@ar...
> https://lists.sourceforge.net/lists/listinfo/arsperl-users
>