Stan, It looks as though the field 'Case ID+' is not found in the schema. I'm just guessing that the schema you are using is tied to a variable and not hardcoded. Please verify that the schema being used when it fails contains the field as requested and, conversely, that the same schema is used when it properly generates the qualifier.
HTH, Mark Vaughan TTS Development Comcast Cable Corporation 720.268.8591 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of STAN HOLODNAK, BLOOMBERG/ 731 LEXIN Sent: Tuesday, April 10, 2007 10:13 AM To: ARSPERL-USERS@ARSPERL.ORG Subject: [Arsperl-users] ars_LoadQualifier blows in ARSPerl 1.85 for Remedy6.3 It runs OK sometimes but sometimes it exits with this message ars_LoadQualifier: [ERROR] Unknown field referenced in query line (position 39 (... AND 'Case ID+'^ = "00000000037...)) (ARERR #1587) Print out query just before ars_LoadQualifier says 'Case Status' = "Closed" AND 'Case ID+' ="000000000373200". So the query itself is correct. Why the error message shows '^' and why does it exit? Thank you. ------------------------------------------------------------------------ - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDE V _______________________________________________ Arsperl-users mailing list Arsperl-users@arsperl.org https://lists.sourceforge.net/lists/listinfo/arsperl-users ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Arsperl-users mailing list Arsperl-users@arsperl.org https://lists.sourceforge.net/lists/listinfo/arsperl-users
