[Zope] Using results of SQL in form

[Ben Edwards]

I have a Z SQL Method which returns one row and I want to use the data from 
it in a form (I am going to detault the input fields with the values from 
the SQL).  I thought using the dtml-in tag would be a simple way of doing 
this but am having problems passing the method the parameter.  In the code 
below the line

   Edit Video <dtml-var pCode>

renders pCode into the page but the line

   <dtml-in expr="getVideoSQL(pCode)">

generates a runtime error saying pCode not found.

Can anyone advise me as to what I ma doing wrong?

Regards,
ben

editVideo DHTML Method:
<dtml-var standard_html_header>
<dtml-var table_top>
Edit Video <dtml-var pCode>
<dtml-var table_middle>
<dtml-in expr="getVideoSQL(pCode)">
<form action="addVideoMethod">
   <table width="100%" border="0" cellspacing="0" cellpadding="0">
     <tr valign="middle" align="left">
       <td class="NormalText">
         <div align="right"><b>Code:</b></div>
       </td>
       <td class="NormalText" colspan="3">
         <input type="text" name="code" size="7">
         <b>Titile:</b>
         <input type="text" name="title" size="20">
       </td>
     </tr>
     <tr valign="top">
       <td class="NormalText" width="100">
         <div align="right"><b>Abstract:</b></div>
       </td>
       <td class="NormalText" colspan="3">
         <textarea name="abstract" cols="30" rows="3"></textarea>
       </td>
     </tr>
     <tr valign="top">
       <td class="NormalText" width="100">
         <div align="right"><b>Desc:</b></div>
       </td>
       <td class="NormalText" colspan="3">
         <textarea name="description" cols="30" rows="8"></textarea>
       </td>
       </tr>
       <tr valign="top" align="left">
         <td class="NormalText">
           <div align="right"><b>Producer:</b></div>
         </td>
         <td class="NormalText" colspan="3" valign="middle">
           <input type="text" name="author" size="15">
           <b>Duration: </b>
           <input type="text" name="duration_hours" size="3"><b>:</b>
           <input type="text" name="duration_minutes" size="3">
         </td>
       </tr>
       <tr valign="middle">
         <td class="NormalText" width="100">
           <div align="right"><b>Price:</b></div>
         </td>
         <td class="NormalText" colspan="3">
         <p><input type="text" name="price" size="10"></p>
       </td>
     </tr>
     <tr valign="top">
       <td class="NormalText" width="100"><b></b></td>
       <td class="NormalText" colspan="3">
         <input type="submit" name="Submit" value="Submit">
         <input type="reset" name="Submit2" value="Reset">
       </td>
     </tr>
   </table>
</form>
</dtml-in>
<dtml-var table_bottom>
<dtml-var standard_html_footer>

getVideoSQL Z SQL Method with paramater pCode:
select * from products where code=<dtml-sqlvar pCode type="string">
*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+
* Ben Edwards lostit@videonetwork.org    +44 (0)7970 269 522 *
* Campaign Against proper English, Dyslexia division         *
* Homepage                http://www.gifford.co.uk/~bedwards *
* i-Contact Progressive Video    http://www.videonetwork.org *
* Smashing the Corporate image     http://www.subvertise.org *
* Bristol's radical news            http://www.bristle.co.uk *
* Open Directory Project                 http://www.dmoz.org *
*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+