Use a checkbox to Select All

[rcaesar]

I have a dropdown with a list of managers. I would like to give the use the option to select all in the list by checking a checkbox.
Thanks a million.

 

[stewm]

I place a value in the table called ' All' and it will appear on the top of the drop down list.

Mark Stewart

Consultants Club Corp.

 

[stewm]

I actually do a UNION Select ' ALL' for the item I want to select all on in the SQL statement.

Consultants Club Corp.

 

[rcaesar]

Thanks - The problem though is I cannot include "ALL" in the table. The manager list comes from a different application.

Is there a way I can add a checkbox for the user to select all in the dropdown. BTW, I am using powerprompts (in COGNOS) -- here is a part of the code :

<form method=&quot;POST&quot;>

<select multiple name=&quot;Status&quot; size=&quot;10&quot;>
<%
var oConn = Server.CreateObject(&quot;ADODB.Connection&quot;
// This is any valid ODBC DSN
oConn.Open(&quot;CATS-POWER-PROMPT&quot;
// This is any value SQL for the above DSN



var oRs = oConn.Execute(&quot;Select distinct Sts_tx from CATW.VAMNDED_CNTRCT_W&quot;, &quot;CATS-POWER-PROMPT&quot;
while(!oRs.EOF)
{
Response.Write(&quot;<option>&quot; + oRs.Fields(&quot;Sts_tx&quot.Value + &quot;</option>&quot;
oRs.MoveNext();

}
oRs.Close();

___
Thanks again.