<?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 5324</title><link>http://forums.method.me/cs/search/SearchResults.aspx?o=DateDescending&amp;u=5324</link><description>Search results by user ID 5324</description><dc:language>en-US</dc:language><generator>CommunityServer 2007.1 SP2 (Build: 31113.47)</generator><item><title>Re: Problem with Session IP value in February release</title><link>http://forums.method.me/cs/forums/p/5756/22221.aspx#22221</link><pubDate>Mon, 09 Jun 2014 18:02:56 GMT</pubDate><guid isPermaLink="false">3393c1ec-311b-4812-96cb-ad8c611bba4f:22221</guid><dc:creator>Rolf</dc:creator><description>&lt;p&gt;&lt;span id="mce_0_start" style="overflow:hidden;"&gt;Ok, thanks Ben&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span id="mce_0_start" style="overflow:hidden;"&gt;&lt;/span&gt;I&amp;#39;ll repost once I notice it working.&lt;/p&gt;
&lt;p&gt;Rolf&lt;/p&gt;</description></item><item><title>Re: Problem with Session IP value in February release</title><link>http://forums.method.me/cs/forums/p/5756/22189.aspx#22189</link><pubDate>Fri, 06 Jun 2014 19:31:30 GMT</pubDate><guid isPermaLink="false">3393c1ec-311b-4812-96cb-ad8c611bba4f:22189</guid><dc:creator>Rolf</dc:creator><description>&lt;p&gt;&lt;span id="mce_0_start" style="overflow:hidden;"&gt;Could someone please respond to this? &amp;nbsp;I need to at know that the old version won&amp;#39;t be removed until this issue is fixed.&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;/p&gt;
&lt;p&gt;thanks,&lt;/p&gt;
&lt;p&gt;Rolf&lt;/p&gt;</description></item><item><title>Re: Problem with Session IP value in February release</title><link>http://forums.method.me/cs/forums/p/5756/22124.aspx#22124</link><pubDate>Mon, 02 Jun 2014 19:14:33 GMT</pubDate><guid isPermaLink="false">3393c1ec-311b-4812-96cb-ad8c611bba4f:22124</guid><dc:creator>Rolf</dc:creator><description>&lt;p&gt;&lt;span id="mce_0_start" style="overflow:hidden;"&gt;Hi Ben,&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;/p&gt;
&lt;p&gt;I&lt;span id="mce_1_start" style="overflow:hidden;"&gt; was&amp;nbsp;&lt;/span&gt; wondering if any progress has been made on this issue&amp;nbsp;&lt;span id="mce_2_start" style="overflow:hidden;"&gt; and to remind you that we need to continue &lt;span id="mce_3_start" style="overflow:hidden;"&gt;to&amp;nbsp;&lt;/span&gt;have the October version available until it&amp;#39;s resolved.&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="overflow:hidden;"&gt;thanks,&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="overflow:hidden;"&gt;Rolf&lt;/span&gt;&lt;/p&gt;</description></item><item><title>Problem with Session IP value in February release</title><link>http://forums.method.me/cs/forums/p/5756/21715.aspx#21715</link><pubDate>Fri, 02 May 2014 18:48:56 GMT</pubDate><guid isPermaLink="false">3393c1ec-311b-4812-96cb-ad8c611bba4f:21715</guid><dc:creator>Rolf</dc:creator><description>&lt;p&gt;We use the &amp;quot;Value from session &amp;nbsp; User:IP address&amp;quot; value in a customized screen to set a default global value. &amp;nbsp; This has worked consisten&lt;span id="mce_1_start" style="overflow:hidden;"&gt;t&lt;/span&gt;ly&amp;nbsp;&lt;span id="mce_2_start" style="overflow:hidden;"&gt; until the February rele&lt;span id="mce_11_start" style="overflow:hidden;"&gt;a&lt;/span&gt;se version. &amp;nbsp;Whereas this value returned the correct IP value in the past, it now &lt;span id="mce_3_start" style="overflow:hidden;"&gt; always&amp;nbsp;&lt;/span&gt;returns the value&amp;nbsp;10.183.248.250&amp;nbsp;&lt;span id="mce_4_start" style="overflow:hidden;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;We are continuing to use the October version release &lt;span id="mce_5_start" style="overflow:hidden;"&gt; and will need to &lt;span id="mce_8_start" style="overflow:hidden;"&gt;&lt;/span&gt;&amp;nbsp;do so until&amp;nbsp;&amp;nbsp;this is resloved.&lt;span id="mce_7_start" style="overflow:hidden;"&gt; &amp;nbsp;Could you please look into this and correct the problem prior to removing the October version access.&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;thanks,&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;Rolf&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;</description></item><item><title>Re: Reports being minimized</title><link>http://forums.method.me/cs/forums/p/5054/19366.aspx#19366</link><pubDate>Fri, 11 Oct 2013 21:16:06 GMT</pubDate><guid isPermaLink="false">3393c1ec-311b-4812-96cb-ad8c611bba4f:19366</guid><dc:creator>Rolf</dc:creator><description>&lt;p&gt;&lt;span id="mce_0_start" style="overflow:hidden;"&gt;Nelson,&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span id="mce_29_start" style="overflow:hidden;"&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;On further testing, this is what I&amp;#39;ve found.&lt;/p&gt;
&lt;p&gt;&lt;span id="mce_1_start" style="overflow:hidden;"&gt;&lt;/span&gt;&amp;nbsp;When the reports load, &lt;span id="mce_2_start" style="overflow:hidden;"&gt;I can see&amp;nbsp;&lt;/span&gt;they all stack up on top of each other, as before. Then, when I delete &lt;span id="mce_3_start" style="overflow:hidden;"&gt;the top &lt;span id="mce_6_start" style="overflow:hidden;"&gt;&lt;/span&gt;&amp;nbsp;&lt;/span&gt;one, the rest are all minimized&lt;span id="mce_4_start" style="overflow:hidden;"&gt;&lt;/span&gt;.&amp;nbsp; If, after generating the report, &lt;span id="mce_9_start" style="overflow:hidden;"&gt;&lt;/span&gt;&lt;span id="mce_10_start" style="overflow:hidden;"&gt;&lt;i&gt;I&amp;nbsp;&lt;/i&gt;&lt;/span&gt;&lt;span id="mce_8_end" style="overflow:hidden;"&gt;&lt;/span&gt;first grab the bar on the window and move it, then &lt;span id="mce_13_start" style="overflow:hidden;"&gt;I&lt;/span&gt;&amp;nbsp;can see the report below, and it may work as previously&lt;span id="mce_14_start" style="overflow:hidden;"&gt;&lt;/span&gt;.&amp;nbsp; Sometimes&lt;span id="mce_16_start" style="overflow:hidden;"&gt; though,&lt;/span&gt;&amp;nbsp;after moving the top window, and deleting it, the other windows are minimized and not on &lt;span id="mce_15_start" style="overflow:hidden;"&gt;&lt;/span&gt;the screen.&lt;/p&gt;
&lt;p&gt;If, however, &lt;span id="mce_18_start" style="overflow:hidden;"&gt;&lt;span id="mce_22_start" style="overflow:hidden;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;span id="mce_23_start" style="overflow:hidden;"&gt;I&amp;nbsp;&lt;span id="mce_24_start" style="overflow:hidden;"&gt;&lt;span id="mce_25_start" style="overflow:hidden;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span id="mce_20_end" style="overflow:hidden;"&gt;&lt;/span&gt;move the top window, and the one underneath, this seems to then keep all windows open.&amp;nbsp; &lt;span id="mce_26_start" style="overflow:hidden;"&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="overflow:hidden;"&gt;&lt;span id="mce_27_start" style="overflow:hidden;"&gt;&lt;span id="mce_30_start" style="overflow:hidden;"&gt;Also, FYI, I&amp;#39;m using Chrome with pop-ups set to blocked, and the Method domain allowed. I also tried allowing all pop-ups and still get the same results.&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="overflow:hidden;"&gt;&lt;span id="mce_27_start" style="overflow:hidden;"&gt;&lt;span id="mce_30_start" style="overflow:hidden;"&gt;&lt;/span&gt;&lt;/span&gt;cheers,&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="overflow:hidden;"&gt;Rolf&lt;/span&gt;&lt;/p&gt;</description></item><item><title>Re: Reports being minimized</title><link>http://forums.method.me/cs/forums/p/5054/19364.aspx#19364</link><pubDate>Fri, 11 Oct 2013 18:34:53 GMT</pubDate><guid isPermaLink="false">3393c1ec-311b-4812-96cb-ad8c611bba4f:19364</guid><dc:creator>Rolf</dc:creator><description>&lt;p&gt;&lt;span id="mce_0_start" style="overflow:hidden;"&gt;Nelson,&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span id="mce_0_start" style="overflow:hidden;"&gt;&lt;/span&gt;I&amp;#39;m using&amp;nbsp;&lt;span&gt;Version 30.0.1599.69 m&lt;/span&gt;&lt;span id="mce_1_start" style="overflow:hidden;"&gt; &amp;nbsp;&lt;span id="mce_4_start" style="overflow:hidden;"&gt;&lt;span id="mce_5_start" style="overflow:hidden;"&gt;&lt;span id="mce_7_start" style="overflow:hidden;"&gt; with&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;Windows 7&lt;span id="mce_2_start" style="overflow:hidden;"&gt; .&lt;span id="mce_9_start" style="overflow:hidden;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;cheers,&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;Rolf&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;</description></item><item><title>Re: Reports being minimized</title><link>http://forums.method.me/cs/forums/p/5054/19358.aspx#19358</link><pubDate>Fri, 11 Oct 2013 17:00:29 GMT</pubDate><guid isPermaLink="false">3393c1ec-311b-4812-96cb-ad8c611bba4f:19358</guid><dc:creator>Rolf</dc:creator><description>&lt;p&gt;&lt;span id="mce_0_start" style="overflow:hidden;"&gt;Hi Nelson,&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span id="mce_0_start" style="overflow:hidden;"&gt;&lt;/span&gt;This is happening with google chrome on multiple computers. &amp;nbsp;No updates have been done recently.&lt;/p&gt;
&lt;p&gt;&lt;/p&gt;
&lt;p&gt;Rolf&lt;/p&gt;</description></item><item><title>Reports being minimized</title><link>http://forums.method.me/cs/forums/p/5054/19346.aspx#19346</link><pubDate>Fri, 11 Oct 2013 00:47:09 GMT</pubDate><guid isPermaLink="false">3393c1ec-311b-4812-96cb-ad8c611bba4f:19346</guid><dc:creator>Rolf</dc:creator><description>&lt;p&gt;&lt;span id="mce_0_start" style="overflow:hidden;"&gt;&lt;span id="mce_1_start" style="overflow:hidden;"&gt;We have been using a custom action that generates multiple reports for over a year now. &amp;nbsp;This has always created an open window for each report, with the windows stacked-up, and available for printing. &amp;nbsp;As of last Friday, only one report window is open, and the rest are minimized. &amp;nbsp;This is not nearly as convenient for us and I&amp;#39;m wondering what has happened and how to fix it.&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;/p&gt;
&lt;p&gt;thanks,&lt;/p&gt;
&lt;p&gt;Rolf&lt;/p&gt;</description></item><item><title>Re: Retrieving distinct values from tables</title><link>http://forums.method.me/cs/forums/p/4710/18099.aspx#18099</link><pubDate>Thu, 04 Jul 2013 20:52:16 GMT</pubDate><guid isPermaLink="false">3393c1ec-311b-4812-96cb-ad8c611bba4f:18099</guid><dc:creator>Rolf</dc:creator><description>&lt;p&gt;&lt;span id="mce_0_start" style="overflow:hidden;"&gt;Sam,&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span id="mce_0_start" style="overflow:hidden;"&gt;&lt;/span&gt;Thanks for you efforts on this issue. &amp;nbsp;I got it to work by doing my own distinct value test using a conditional within&lt;span id="mce_1_start" style="overflow:hidden;"&gt;&lt;/span&gt;&lt;span id="mce_0_start" style="overflow:hidden;"&gt;&lt;/span&gt; the loop.&lt;/p&gt;
&lt;p&gt;&lt;/p&gt;
&lt;p&gt;Rolf&lt;/p&gt;</description></item><item><title>Re: Retrieving distinct values from tables</title><link>http://forums.method.me/cs/forums/p/4710/18087.aspx#18087</link><pubDate>Wed, 03 Jul 2013 22:52:39 GMT</pubDate><guid isPermaLink="false">3393c1ec-311b-4812-96cb-ad8c611bba4f:18087</guid><dc:creator>Rolf</dc:creator><description>&lt;p&gt;&lt;span id="mce_0_start" style="overflow:hidden;"&gt;Hi Sam,&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span id="mce_0_start" style="overflow:hidden;"&gt;&lt;/span&gt;Thanks for your suggestion on this. &amp;nbsp;I had hoped you were going to suggest some implementation &lt;span id="mce_2_start" style="overflow:hidden;"&gt;with&amp;nbsp;&lt;/span&gt;&amp;nbsp;the SQL &lt;span id="mce_3_start" style="overflow:hidden;"&gt;&lt;/span&gt;&amp;nbsp;&lt;span id="mce_5_start" style="overflow:hidden;"&gt;&amp;#39;&lt;/span&gt;Distinct&lt;span id="mce_6_start" style="overflow:hidden;"&gt;&amp;#39;&lt;/span&gt; keyword with my Action &amp;nbsp;Result to achieve this.&lt;/p&gt;
&lt;p&gt;As to your&amp;nbsp;&lt;span id="mce_4_start" style="overflow:hidden;"&gt;&lt;span id="mce_7_start" style="overflow:hidden;"&gt;suggested approach, I had &lt;span id="mce_16_start" style="overflow:hidden;"&gt;&lt;/span&gt;already tried something like that. &amp;nbsp;The problem is that not only do I need to count distinct customers, but I need to do this for multiple locations. Unfortuneatly I am one &amp;#39;where condition&amp;#39; short in the &amp;#39;loop through table&amp;#39; command.&lt;span id="mce_39_start" style="overflow:hidden;"&gt;&lt;span id="mce_40_start" style="overflow:hidden;"&gt;&lt;span id="mce_41_start" style="overflow:hidden;"&gt;&lt;span id="mce_42_start" style="overflow:hidden;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt; &amp;nbsp;So, what I did was in that loop, I put in a standard conditional statement, and if the location identifier (&amp;nbsp;which I already had added to the Invoice Line table&lt;span id="mce_9_start" style="overflow:hidden;"&gt;)&lt;/span&gt;&amp;nbsp;matched the location I wanted,&amp;nbsp;&lt;span id="mce_10_start" style="overflow:hidden;"&gt;then I incremented my counter.&lt;span id="mce_12_start" style="overflow:hidden;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;What I found&lt;span id="mce_13_start" style="overflow:hidden;"&gt; was&amp;nbsp;&lt;/span&gt; that when I did not select &amp;#39;distinct&amp;#39; in the &amp;#39;loop through table&amp;#39; command, this all worked fine and I was able to count the total number of customer records per location this way, as I would expect, but of course I counted the customers multiple times. &amp;nbsp;When I set the&amp;nbsp;&lt;span id="mce_15_start" style="overflow:hidden;"&gt;&lt;span id="mce_18_start" style="overflow:hidden;"&gt;loop to &amp;#39;distinct Customer&amp;#39; , then the looping function failed in retrieving the &amp;#39;location&amp;#39; value, and allocated all location&lt;span id="mce_31_start" style="overflow:hidden;"&gt;s&lt;/span&gt; to the value of the &lt;span id="mce_19_start" style="overflow:hidden;"&gt;&lt;/span&gt;first&lt;span id="mce_20_start" style="overflow:hidden;"&gt; location alphabetically.&lt;span id="mce_23_start" style="overflow:hidden;"&gt; &amp;nbsp;Somehow the &lt;span id="mce_24_start" style="overflow:hidden;"&gt;&amp;#39;&lt;/span&gt;distinct&lt;span id="mce_26_start" style="overflow:hidden;"&gt;&amp;#39;&lt;/span&gt; option cause the&amp;nbsp;&lt;span id="mce_28_start" style="overflow:hidden;"&gt;&amp;#39;value from row&amp;#39; fetch of the location to be incorrect. I even tried doing a &lt;span id="mce_29_start" style="overflow:hidden;"&gt;&amp;#39;&lt;/span&gt;retrieve value from table with the current record ID&lt;span id="mce_30_start" style="overflow:hidden;"&gt;&amp;#39; in the loop, which also failed. (although I think that was because it&amp;#39;s not allowed in the loop).&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span id="mce_33_start" style="overflow:hidden;"&gt;I know this explanation seems convoluted, so I&amp;#39;ll give an example to hopefully make it clearer. &amp;nbsp; For the time period I was checking, I had four customers from two locations. &amp;nbsp;Chronologically, they were &amp;nbsp; Lan&lt;span id="mce_34_start" style="overflow:hidden;"&gt;g&lt;/span&gt;ford, Victoria, Langford, Langford.&lt;span id="mce_35_start" style="overflow:hidden;"&gt; &amp;nbsp;The&lt;span id="mce_36_start" style="overflow:hidden;"&gt;y all returned Langford as the location. &amp;nbsp;Only when I changed the time period to only include the one record from Victoria, did I get that returned as the location.&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span id="mce_33_start" style="overflow:hidden;"&gt;&lt;span id="mce_35_start" style="overflow:hidden;"&gt;&lt;span id="mce_36_start" style="overflow:hidden;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;One further bit of info. &amp;nbsp;When I used the &amp;#39;value from row&amp;#39; in the conditional command, it created an error if the &amp;#39;loop through table&amp;#39; was distinct, but not if it wasn&amp;#39;t &amp;nbsp; I got around this by assinging an action result to the value in the loop, and using the action result in the conditional command.&lt;span id="mce_37_start" style="overflow:hidden;"&gt; &amp;nbsp;At first I thought this was a bug in the program, but maybe it&amp;#39;s a feature if other fields are not available in &amp;#39;distinct&amp;#39; mode, but then it should have failed on the action result assignment.&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;Any thoughts on how &lt;span id="mce_38_start" style="overflow:hidden;"&gt;to&amp;nbsp;&lt;/span&gt;proceed from here ?&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;Rolf&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span id="mce_21_start" style="overflow:hidden;"&gt;&lt;span id="mce_22_start" style="overflow:hidden;"&gt;&lt;span id="mce_25_start" style="overflow:hidden;"&gt;&lt;span id="mce_27_start" style="overflow:hidden;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;span style="overflow:hidden;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;</description></item></channel></rss>