try ... <dtml-var "getVideoSQL(pCode=pCode)"> hope that helps :-) ryan Ben Edwards wrote:
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 * *+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+*+
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
-- Ryan Dolensek Software Engineer Global Crossing (920)405-4812 rdolense@globalcrossing.com