Stan, As I didn't know what the underlying field name was I used the available information (in this case the field label) and presumed that you would understand what I was talking about (as you apparently did).
To specifically answer your first question, the '^' implies that the preceding field (in this case the field with the label 'Case ID+') is unknown to the code which generates the qualifier structure. If you have the ARS driver tool available, try it in there and see if it returns a valid structure consistently. 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 11:09 AM To: arsperl-users@arsperl.org Subject: Re: [Arsperl-users] ars_LoadQualifier blows in ARSPerl 1.85 Mark, thank you for your help. The schema is the same but the 'Case ID+' is a field label in that view not the field name. This script was always working on ARS 5.1, but when we moved to 6.3 it sometimes breaks. -Stan ----- Original Message ----- From: Mark Vaughan <arsperl-users@arsperl.org> At: 4/10 12:57:35 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=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=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
