Re: Problem with

[Bernd Mueller]

i don't use <csp:query> tag ... now i know why ;-)
please remove them and change them into ...
<script language=sql name=lnList>
select ID,Reference ... [your sql-code]
</script>
and
<script language=sql name=colList>
select ID,ColReference ... [your sql-code]
</script>
fill in the sql-code from your class MediaOnline.Length, query ln
and class MediaOnline.Column, query Colqry
This is the way i prefer and this will work for sure.
Regards...
Bernd!
Bernd Mueller wrote:
remove the cspbind's and try ... you don't need them because you 
populate them via the querys.

Bernd!
farzou wrote:
Hi All
I have got the following problem, when I put 2 queries on a web page use
their result to populate a drop down.  Only the 1st drop down gets
populated.  The second one just get the last data.  Here is my code in 
HTML,
I'm sure I'm missing something.

Thanks
<csp:query name=lnList CLASSNAME="MediaOnline.Length" QUERYNAME="ln">
  <td>  <select name="Lengthlength" cspbind="Length.length" size="1">
    <option value="*" selected>Any Category</option>
    <csp:while condition="lnList.Next()">
     <option 
value=#(lnList.Get("ID"))#>#(lnList.Get("Reference"))#</option>
    </csp:while>
   </select></td>

    <csp:QUERY NAME=colList CLASSNAME="MediaOnline.Column"
QUERYNAME="Colqry">
      </tr>
      <tr>
        <td><b>
          <div align="RIGHT">Column:</div>
          </b></td>
    <td>  <select name="Columnlength" cspbind="Column.length" size="1">
    <option value="*" selected>Any Category</option>
    <csp:while condition="colList.Next()">
     <option
value=#(colList.Get("ID"))#>#(colList.Get("colReference"))#</option>
    </csp:while>
   </select></td>