Apostrophe in FetchXML

Last post 11-18-2008 7:26 AM by Frank Hermes. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 11-18-2008 6:48 AM

    Apostrophe in FetchXML

    We are using FetchXML to display a list of incidents for contacts using their email address.  We have a few contact email address that have apostrophes in there and it causes errors.  I have tried replacing the apostrophes with #apos; with no luck.

    Any ideas?

    Thanks,

    Vincent

  • 11-18-2008 7:26 AM In reply to

    Re: Apostrophe in FetchXML

    Where and how do you render the result?

    If I fetch with

    <fetch mapping="logical">
      <entity name="contact">
        <attribute name="emailaddress1" />
        <attribute name="fullname" />
        <filter>
          <condition attribute="emailaddress1" operator="like" value="%'%" />
        </filter>
      </entity>
    </fetch>

    I get this result:

    <resultset morerecords="0" paging-cookie="&lt;cookie page=&quot;1&quot;&gt;&lt;contactid last=&quot;{96411ADC-F20A-DD11-B08A-000C29A5D332}&quot; first=&quot;{96411ADC-F20A-DD11-B08A-000C29A5D332}&quot; /&gt;&lt;/cookie&gt;">
      <result>
        <emailaddress1>'frank.hermes@test.com'</emailaddress1>
        <fullname>Frank Hermes</fullname>
        <contactid>{96411ADC-F20A-DD11-B08A-000C29A5D332}</contactid>
      </result>
    </resultset>

    Now it depends on what you do with the resultxml!?

Page 1 of 1 (2 items)