Re: [Arsperl-users] Qualification string with dates

[Ian T. <I.D...@op...>]

Paizo wrote:
> Hi listeners,
>
> I found some troubles trying to use this qualification:
>
> $str_qual = "'Stato Reclamo' = \"Trasferita\" AND 'Gruppo Competente' 
> = \"the-group\" and 'Data Trasferimento' > \"01-05-2007\" and 'Data 
> Trasferimento'  <  \"30-05-2007\"";
>
> Data trasferimento is a date field.
> Using this qualification with the remedy client works ( advaced search );
>
> with ARSperl i got that error:
>
> ars_LoadQualifier: [ERROR] Cannot open catalog; Message number = 1590 
> (position 111   (... > "01-05-2007"^ and 'Data Tras...)) (ARERR #1590)
>
> I don't understand why it works on the remedy client ad won't using 
> ARSperl.
> Any hints?
>
> ty, Paizo

Paizo,

Dates are funny things when used in qualifications within ARSperl.  The 
string format of the date has to be just right for the server to 
recognise as a proper date.  I find it easier to use some of the Perl 
date functions to turn a date string into an integer value (Date::Calc 
is our favourite tool, but you can use Time::Local, which is (usually) 
built-in).  If using integer date values then you obviously don't need 
to wrap them in quotes.

Hope this helps,

Ian

------------------------------------------------------------------------
Ian Trimnell, AR System Lead Developer (amongst other jobs),
Specialist Support & Information Team, Academic & Administrative 
Computing Service
Open University, MILTON KEYNES, UK
Phone: 01908 653741   web: http://www.open.ac.uk/