[Zope-dev] My ZSql method return the result of Query!

[Victor.Zhai@ogilvy.com]

Hi,all
 I query from a DTML Method that call the ZSql method like this:
ZSQl method named "sqlQueryCustomer":
           select * from customers
           where customer_id = <dtml-sqlvar customer_id type=string>
It can work by using TEST.
But I want to use it through one DTML Document named "QueryCustomer": <The
one which I query interface>
               <dtml-var standard_html_header>
               <h2><dtml-var title_or_id></h2>
               <form action="dtPerformQueryCustomer">
          <table>
           <tbody>
            <tr>
                <th aligh="left">Customer ID</th>
                 <td><input type="text" name="customer_id"></td>
           </tr>
           </tbody>
          </table>
          <input type="submit" value="Query Customer">
          </form>
          </table>
          </form>
My DTML Method named "dtPerformQueryCustomer":
          <dtml-var standard_html_header>
          <dtml-call sqlQueryCustomer>
          <h3>This is <dtml-var customer_id> was queried.</h3>
          <dtml-var standard_html_footer>
It can only return "This is XXX was queried".And cannot return the result like "*** **** *** ***".
What is the problem, Give me your hand.
Thanks a lot.



"WorldSecure Server <ogilvy.com>" made the following
 annotations on 01/20/00 04:55:42
------------------------------------------------------------------------------
Privileged/Confidential Information may be contained in this message.  If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email. Please advise immediately if you or your employer does not consent to email for messages of this kind.  Opinions, conclusions and other information in this message that do not relate to the official business of the Ogilvy Group shall be understood as neither given nor endorsed by it.

==============================================================================