[Zope] Newbie Question (dropdown menu)

2000-06-21 Thread joel grimes

I'm trying to fill a combo-box (pardon the vb-centric lingo - I don't know 
what the things are called - it's a select...option... thing) with items 
selected from a table.  I haven't a clue how to do this.  I've got the ODBC 
Connection and SQL Method working, but how do I iterate through the query 
results to fill a drop-down?

Thanks

Joel Grimes

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com


___
Zope maillist  -  [EMAIL PROTECTED]
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 )




Re: [Zope] Newbie Question (dropdown menu)

2000-06-21 Thread Jim Sanford

This is my answer to another seeker's question.
It should also answer yours.

This code assumes that the variable customerid on the form
contains a value that matches up with customerid in 
the query custcompanysearch

___
dtml-let tcustid="customerid"
  select name="customerid"
dtml-in custcompanysearch
  option value=dtml-var customerid
  dtml-if "customerid==tcustid"selected/dtml-if
  dtml-var firstname dtml-var lastname/option
/dtml-in
  /select
dtml-let
 __
 
  Jim Sanford
  .   Database Engineer
 / \  /   Accelerated Technology, Inc.
/   / 720 Oak Circle Drive East
   /  /  \Mobile, AL 36609
  / / \   Voice: 334-661-5770  fax: 334-661-5788
 / \  E-Mail: [EMAIL PROTECTED]
  Web: http://www.atinucleus.com
  
 Nucleus.  All You NEED in an RTOS.  Royalty Free
 __


- Original Message - 
From: joel grimes [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 21, 2000 10:51 AM
Subject: [Zope] Newbie Question (dropdown menu)


I'm trying to fill a combo-box (pardon the vb-centric lingo - I don't know 
what the things are called - it's a select...option... thing) with items 
selected from a table.  I haven't a clue how to do this.  I've got the ODBC 
Connection and SQL Method working, but how do I iterate through the query 
results to fill a drop-down?

Thanks

Joel Grimes

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com


___
Zope maillist  -  [EMAIL PROTECTED]
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 )




___
Zope maillist  -  [EMAIL PROTECTED]
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 )