<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://forums.method.me/cs/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Search results by user ID 6981</title><link>http://forums.method.me/cs/search/SearchResults.aspx?o=DateDescending&amp;u=6981</link><description>Search results by user ID 6981</description><dc:language>en-US</dc:language><generator>CommunityServer 2007.1 SP2 (Build: 31113.47)</generator><item><title>Select distinct values with MethodAPISelect_DataSetV2 operation</title><link>http://forums.method.me/cs/forums/p/7644/28285.aspx#28285</link><pubDate>Thu, 06 Aug 2015 17:06:02 GMT</pubDate><guid isPermaLink="false">3393c1ec-311b-4812-96cb-ad8c611bba4f:28285</guid><dc:creator>Salamander</dc:creator><description>&lt;p&gt;&lt;span id="mce_0_start" style="overflow:hidden;"&gt;Hello,&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span id="mce_0_start" style="overflow:hidden;"&gt;&lt;/span&gt;I have using the api to select four columns from a Method table, no problem.&lt;/p&gt;
&lt;p&gt;However when I used the DISTINCT keyword in the fields portion of the call, the response was blank instead of success. The response was:&lt;span id="mce_1_start" style="overflow:hidden;"&gt;&lt;span id="mce_5_start" style="overflow:hidden;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&amp;lt;?xml version=&amp;quot;1.0&amp;quot; encoding=&amp;quot;windows-1252&amp;quot; ?&amp;gt;&amp;lt;MethodAPI response = &amp;quot;&amp;quot; &amp;gt;&amp;lt;/MethodAPI&amp;gt;&lt;/p&gt;
&lt;p&gt;Since there is no error I&amp;#39;m not sure what my next step is.&lt;/p&gt;
&lt;p&gt;Is using DISTINCT allowed with the Method API? &lt;span id="mce_4_start" style="overflow:hidden;"&gt;&lt;br /&gt;&lt;/span&gt;What is the proper way to have&amp;nbsp;the API &lt;span id="mce_3_start" style="overflow:hidden;"&gt;&lt;/span&gt;give you distinct values?&lt;/p&gt;
&lt;p&gt;Thanks.&lt;/p&gt;</description></item></channel></rss>