Maik, Ed, Thanks for the help. It took a bit of tweaking, but basically Maik was right. So this now works... <dtml-in mutein_id prefix=list> <dtml-if sequence-odd> <tr bgcolor='#7685bE'> <dtml-else> <tr bgcolor='#A5C7CC'> </dtml-if> <dtml-in expr="retrieveOligoData(mutein_id = list_item)"> <td align='center'><font color='black'><dtml-var mutein_id></font></td> <td align='center'><font color='black'><dtml-var molecule></font></td> <td align='center'><font color='black'><dtml-var vendor></font></td> <td align='center'><font color='black'><dtml-var vendor_id></font></td> ...... <dtml-else> <td colspan='15'><font color='black'>No data for <dtml-var list_item></font></td> </dtml-in> </tr> </dtml-in> One more question though...what does prefix=list do in <dtml-let> and why is it required? (this doesn't work if that snippet is removed) Why won't sequence-item work instead of list_item? Thanks, Mark |---------+---------------------------------> | | Maik Jablonski | | | <maik.jablonski@uni-bi| | | elefeld.de> | | | | | | 04/11/2003 09:20 AM | | | | |---------+--------------------------------->
------------------------------------------------------------------------------------------------------------------------------------------| | | | To: Mark Evans <mark.evans.b@bayer.com> | | cc: | | Subject: Re: Processing ZSQL results | ------------------------------------------------------------------------------------------------------------------------------------------|
Mark Evans wrote:
I should know this, but here goes anyway. I want to retrieve data from a table if an id that is submitted from a form is present. If I submit three id's, but only two are present in the table, two results are returned. I want to trap the missing id and display a "no data found" message. How can I do this?
<table> <dtml-in getResults> <tr><td><dtml-var ID></td</tr> <dtml-else> <tr><td>No Data</td></tr> </dtml-in>
This shows only the two results. The <dtml-else> is triggered only if none of the three ID's are present.
My first guess would be something like this: <dtml-in yourIdList prefix=list> <dtml-let result="getResults(id=list_item)"> <dtml-if result> <tr><td><dtml-var ID></td</tr> <dtml-else> <tr><td>No Data</td></tr> </dtml-if> </dtml-in> Cheers, Maik