<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1276" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN class=768384020-03012004>I can't seem to
figure out what the equivalent code would be to use in a ZPT. Can someone
provide me the answer?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=768384020-03012004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=768384020-03012004>I have the following
statement working in my dtml-documents:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=768384020-03012004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=768384020-03012004><dtml-in
expr="methods.dropdown( listname='state' )" ></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=768384020-03012004><option
value="<dtml-var item_value>"><dtml-var
item_name></option></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=768384020-03012004></dtml-in></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=768384020-03012004>Here is an
explanation of what the code does. The end result is that the contents of select
lists are based off of data from the database.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2><dtml-in expr="methods.dropdown(
listname='state' )" > # this line calls to the dropdown zsql method in the
methods folder and tells it that the variable listname should equal
state</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2><option value="<dtml-var
item_value>"><dtml-var item_name></option> # this line just
puts in the two variables that the zsql method has returned and puts in
item_value and item_name (two columns in the db table) into the correct
place</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></dtml-in> # this is just the closing
tag</FONT></DIV></BODY></HTML>