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/
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Arsperl-users mailing list
Arsperl-users@arsperl.org
https://lists.sourceforge.net/lists/listinfo/arsperl-users
