<p>&lt;SelectCommand CommandText="Select @portalid as PortalID"&gt;<br>&lt;parameter name="portalid" value='[[Portal:ID]]' /&gt;<br>&lt;parameter name="portalname" value='[[Portal:ID]]' /&gt;<br>&lt;/SelectCommand&gt;<br> <br> <br>&lt;SelectCommand CommandText="Select [PortalName] FROM PortalLocalization"&gt;<br>&lt;Parameter name="PortalName" Value='[[PortalName]]'<br>&lt;/SelectCommand&gt;<br> <br> <br>&lt;strong&gt;Portal Id:&lt;/strong&gt; [[PortalId]] &lt;br/&gt;<br>&lt;strong&gt;Portal Name:&lt;/strong&gt; [[PortalName]]&lt;br/&gt;<br><br>Result when omitting the second selectcommand:<br><br>Portal Id: 1 (Correct Value returned)<br>Portal Name: (No value returned)<br><br>Result when including the second selectcommand:<br><br>Portal Id: (No value returned)<br>Portal Name: Village Sq (Correct Value returned but last item in the list)<br><br>I need to be able to use a 'WHERE' clause to return the PortalName that corresponds to the PortalId but I can't seem to get both values at the same time. I get either PortalID or PortalName.<br><br>Hints?<br>Ideas?<br><br>Thanks<br>Bob</p></p>