Thanks Fred, I tried your suggestion and I'm still getting this error.
I even tried: <urn:Qualification> 'Change Status' <= "NOT COMPLETED" </urn:Qualification> and I get the error. When I change the <= to >= it's fine. I think it has something to do with the < symbol. It's like it has to be matched with an opposite >. This is in SOAP. The whole reason why I'm testing this is because my customer is getting back different data than I am in the WUT, so I thought I would test his query in SOAP to see what records would come back, but I can't even test it if SOAP doesn't like the < symbol.... Thanks! Lisa -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Tuesday, April 24, 2012 10:25 AM To: arslist@ARSLIST.ORG Subject: Re: Webservices and Queries If the field is a Date/Time field I would think that the web service would expect it to be in a valid XML Date/Time format. The XML Date/Time format is YYYY-MM-DDThh:mm:ss.0000-05:00 (http://www.w3schools.com/schema/schema_dtypes_date.asp) With a web service try 'Start Date and Time' <= "2012-04-23T15:30:00" AND 'Change Status' = "CANCELED" Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Tuesday, April 24, 2012 8:25 AM To: arslist@ARSLIST.ORG Subject: Webservices and Queries ** We just upgraded to 7.6.04 SP2 (ARS) and when I run a query in the WUT or MidTier of: 'Start Date and Time' >= "4/23/2012 03:30:00 PM" AND 'Change Status' = "CANCELED" I get records back just fine. When I use SOAP to run this query in our Webservice, everything is fine. But when I try 'Start Date and Time' <= "4/23/2012 03:30:00 PM" AND 'Change Status' = "CANCELED", WUT and Midtier is fine, but I'm getting this error in SOAP: "org.xml.sax.SAXParseException: The content of elements must consist of well-formed character data or markup" Does anyone know why this would error out? Lisa Kemes AR System Developer TEIS - USA +1 717 810 2408 tel +1 717 602 9460 mobile lisa.ke...@te.com 100 Amp Drive Harrisburg, PA 17112 www.te.com _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
