Passing a variable
I'm fairly new to all of this, so please bare with me.
I've created a custom control where I can pass an SQL statement to it and this all works.
<iCnt:RC id="clients" runat="server" sSQL="SELECT count(*) FROM vwAdeoClientsNew"/>
but what I want to do is somehow build the sql statement away from the control and then pass it. I know how to do with in ASP
<iCnt:RC id="clients" runat="server" sSQL="<%=MySQL%>"/>
but of course this doesn't work, so how is this done.
Thanks for any help provided