<html><head></head><body>D'oh. Right. Haven't done it in a decade.<br>
<br>
This. <br><br><div class="gmail_quote">On April 7, 2015 5:46:42 PM EDT, Kenneth Brody <kenbrody@spamcop.net> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<pre class="k9mail">On 4/7/2015 4:44 PM, Jay Ashworth wrote:<br /><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #729fcf; padding-left: 1ex;"> As your single -r parameter, send<br /><br /> KEY1|KEY2|KEY3|ETC<br /><br /> And in the -v table, do<br /><br /> IF @PM co "|"{keyfield SELECT<br /> IF @PM co KEYFIELD{"|" SELECT<br /></blockquote><br />I believe you mean:<br /><br /> @PM co "|"{keyfield{"|"<br /><br />And you need to start and end your parameter value with "|" as well. <br />Otherwise, using your example, "KEY" and "Y2" would both match your code.<br /><br />[...]<br /><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #729fcf; padding-left: 1ex;"> But multiple SELECTS in one record are atomic, I think.<br /></blockquote>[...]<br /><br />By that, I assume you mean that executing SELECT more than once on a single <br />record will only select it once. That is the correct, documented,
behavior.<br /></pre></blockquote></div><br>
-- <br>
Sent from my Android phone with K-9 Mail. Please excuse my brevity.</body></html>