[Zope-DB] Get value from selected item

Kerstin Petersen Kerstin.Petersen@giub.uni-bonn.de
Wed, 29 Jan 2003 12:51:55 +0100


Hi,
this is probably a beginners question.

My question:

1. I created a database connection
2. a sql method (GetMitarbeiter) is called by a dtml method 
(Mitarbeiter) to display a list of empoyees.

<h1>Mitarbeiter </h1>

  <h3>
   <dtml-in GetMitarbeiter>
    <li>
      <a href=MitarbeiterEmail>
      <dtml-var Titel> <dtml-var Vorname> <dtml-var Nachname>
     </a>
   <dtml-var statusname>
   </dtml-in>
  </h3>

SQL method GetMitarbeiter:
select MitarbeiterNr,Titel,Vorname,Nachname,StatusName
from Mitarbeiter,M_Status
where Mitarbeiter.status1=M_Status.statusNr order by MitarbeiterNr

DTML method MitarbeiterEmail:
<h1>Email</h1>
  <h1>
   <dtml-in GetEmail>
       <li><dtml-var email>
   </dtml-in>
  </h1>

GetEmail:
argument: Mitarbeiter=1
select email from Mitarbeiter where
<dtml-sqltest MitarbeiterNr op=eq type=string>

3. in the dtml method object(Mitarbeiter) the names of the employees are 
referenced to an other dtml method object(MitarbeiterEmail) that calls 
an other sql method (GetEmail) to get the email from the selected employee.

My question: How can I get the value of the MitarbeiterId of the 
selected employee or write it to a variable instead of an input 
argument. I would like to use the result, that is dependend on the 
selected employee, in the sql method to get only the email of the 
selected employee.

Thank you for help
Kerstin