Hello all.

I'm a total newbie to Zope (a few days).

I have a problem with getting some results throuh a ZSQL method.
(I've been playing with a sample baseball database that came with

I have a form that accepts multiple choice:  (generated by the wizard)

<form action="search_data_result" method="get">

<tr><th>Home team</th>
    <td><select name="home_team" size="10" multiple>
<option value="Indians">Indians</option>
<option value="Blue Jays">Blue Jays</option>
<option value="White Sox">White Sox</option>
<option value="Red Sox">Red Sox</option>

<input type="SUBMIT" name="SUBMIT" value="Submit Query">
My ZSQL method, called get_all_from_game is the following:

select * from game
where home_team=
<dtml-sqlvar home_team type=string>

and I have specified 1 argument: home_team
the output page: search_data_result looks like that:  (it's been
generated by the wizard)

<dtml-in get_all_from_game size=50 start=query_start>
   <dtml-if sequence-start>

      <dtml-if previous-sequence>

        <a href="<dtml-var URL><dtml-var sequence-query
        (Previous <dtml-var previous-sequence-size> results)

      </dtml-if previous-sequence>

      <table border>
          <th>Home team</th>
          <th>Visiting team</th>
          <th>Home team runs</th>
          <th>Visiting team runs</th>
          <th>Game date</th>
          <th>Game number</th>

   </dtml-if sequence-start>

          <td bgcolor="#A6A6A6"><dtml-var home_team null=""></td>
          <td><dtml-var visiting_team null=""></td>
          <td><dtml-var home_team_runs null=""></td>
          <td><dtml-var visiting_team_runs null=""></td>
          <td><dtml-var game_date null=""></td>
          <td><dtml-var game_number null=""></td>

   <dtml-if sequence-end>

      <dtml-if next-sequence>

         <a href="<dtml-var URL><dtml-var sequence-query
         (Next <dtml-var next-sequence-size> results)

      </dtml-if next-sequence>
   </dtml-if sequence-end>


  There was no data matching this <dtml-var title_or_id> query.



When I select one item in the list I get the results as specified in the
SQL query.  However, I get nothing when I select more than one item.
What am I doing wrong?

Thanks in advance.


Zope maillist  -  [EMAIL PROTECTED]
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-dev )

Reply via email to