[Zope] SQL methods

[Norman Khine]

This is a multi-part message in MIME format.

------=_NextPart_000_0012_01C0B6DF.E3E60A00
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit


Can any one help me understand the concept behind this example:

In the How-To from http://www.zope.org/Members/AlexR/SelectionLists sub
section Filling lists from SQL methods, we have a method

<SELECT name="myList">
 <dtml-in mySQLQuery>
  <OPTION VALUE='<dtml-var Field1 null="">'>
  <dtml-var Field2 null="">
 </dtml-in>
</SELECT>

How can I create a second list so that when I select Field1, the list is
updated from another SQL query using the value of Field1 as the variable.

So for example, I have two tables: ProductGroups and Products
ProductGroups has ProductGrpID, Description
Product has ProductID, Description and FK_ProductGrpID

Therefore if the user select ProductGrp =1 then the second drop-down menu
will only select Products where FK_ProductGrp = 1.

Thanks

Norman


------=_NextPart_000_0012_01C0B6DF.E3E60A00
Content-Type: application/ms-tnef;
	name="winmail.dat"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
	filename="winmail.dat"

eJ8+IjAQAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEGgAMADgAAANEHAwAbABEAAwAAAAIADAEB
A5AGAEQHAAAlAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAB4AcAAB
AAAADAAAAFNRTCBtZXRob2RzAAIBcQABAAAAFgAAAAHAttd5BYqgB3IikRHVmhMAYJcWaGAAAAIB
HQwBAAAAIAAAAFNNVFA6S0hJTkVAQk1QVUJMSUNBVElPTlMuQ08uVUsACwABDgAAAABAAAYOANJK
Zde2wAECAQoOAQAAABgAAAAAAAAANIcE9Sk91BGZDAAAHNYEI8KAAAALAB8OAQAAAAIBCRABAAAA
+wIAAPcCAAB5BAAATFpGdWm9UUADAAoAcmNwZzEyNRYyAPgLYG4OEDAzM08B9wKkA+MCAGNoCsBz
8GV0MCAHEwKDAFAQb1cIVQeyAoB9CoF2CJB30msLgGQ0DGBjAFALAzcLtgqxCoBDA5EAcHkgAQIg
ZSBoZWxwINkHgCB1FLAEkHMBkBSwFCB0FxAgBaBuY2VxBTFiZWgUoRgxBAAgkGV4YW0LUGU6FfQN
FfRJA6AYQkhvdy04VG8gA1IXAAJAcDoILy93HKAuem9whGUuBbBnL01lBtCJF8EvQRoQeFIvBmBR
GhBjdGkCIEwEAHQxBCBzdWIfMB6EIEblAxBsC4BnICAwHwIb4zhTUUwXURhABHBzLKQgdxbxYXYW
8GEhZR8aSgr0DNABQAzQOTU5IQzBMTkxOAzBMjiENzcMwTM4MzYMwYw0NySADME1NzUU0KEM0DY3
MTMMwTcnECMOUAzQODYzEhExIAA8U0VMRUNUIIJuGeBlPSJteR7iDCI+FfQoYGR0bWxWLQuAF1B5
ITFRClByBnkpxihgT1BUSU8ATiBWQUxVRT26JypEdgrBIAAXIGQoUNxudSAgKTApsCcreC0M9jIt
9ynWLypVKcUxICiEvynFFScWAxtxGHADkUkYcPkJcGF0ImIfgQIgGCAggv8fMBvAGEA0wCHwFxA0
UhEgPx5yLYUh4BhCNZMZkXVw3mQ0wRggG+MAcG8YQQXA/SEycSsyF4AAkCBRGEItUOsKQRbAZi2G
YQQgOtQHIfcCYB0QGkpTG8EFsRnFIeAzNHAiM3R3NfE8wnM6lCBQA2BkFPB0RwNg/ziABCAYAkAF
ELAWA0AMEPCjBCBAB3BJRCHgRAeQPwUDHrFBq0LaQ81A00ZL9l9DKhpKVDmRARAFsBbwPwaQGDM6
cBORNtVDKCA9LyhQGEEbFDUlZANgcC3uZBuAKrEJ8HUh8CARFsH+bBawSpwEIDZhSaFHi0ug3CAx
PQtJMABwa0GVFfS+TgWwA4EjahYDFBEAVIAACwABgAggBgAAAAAAwAAAAAAAAEYAAAAAA4UAAAAA
AAADAAOACCAGAAAAAADAAAAAAAAARgAAAAAQhQAAAAAAAAsAFIAIIAYAAAAAAMAAAAAAAABGAAAA
AIKFAAABAAAAAwAcgAggBgAAAAAAwAAAAAAAAEYAAAAAUoUAACdqAQAeAB2ACCAGAAAAAADAAAAA
AAAARgAAAABUhQAAAQAAAAQAAAA5LjAACwAegAggBgAAAAAAwAAAAAAAAEYAAAAABoUAAAAAAAAD
AB+ACCAGAAAAAADAAAAAAAAARgAAAAABhQAAAAAAAAsAKIAIIAYAAAAAAMAAAAAAAABGAAAAAA6F
AAAAAAAAAwApgAggBgAAAAAAwAAAAAAAAEYAAAAAEYUAAAAAAAADACuACCAGAAAAAADAAAAAAAAA
RgAAAAAYhQAAAAAAAB4AOoAIIAYAAAAAAMAAAAAAAABGAAAAADaFAAABAAAAAQAAAAAAAAAeADuA
CCAGAAAAAADAAAAAAAAARgAAAAA3hQAAAQAAAAEAAAAAAAAAHgA8gAggBgAAAAAAwAAAAAAAAEYA
AAAAOIUAAAEAAAABAAAAAAAAAAIB+A8BAAAAEAAAADSHBPUpPdQRmQwAABzWBCMCAfoPAQAAABAA
AAA0hwT1KT3UEZkMAAAc1gQjAgH7DwEAAAB3AAAAAAAAADihuxAF5RAaobsIACsqVsIAAFBTVFBS
WC5ETEwAAAAAAAAAAE5JVEH5v7gBAKoAN9luAAAAQzpcUHJvZ3JhbSBGaWxlc1xDb21tb24gRmls
ZXNcU3lzdGVtXE1hcGlcMTAzM1xOVFxvdXRsb29rLnBzdAAAAwD+DwUAAAADAA00/TcAAAIBfwAB
AAAAOgAAADxORUJCSkpBTURFSUhCSUNEQ05CT0dFRE9DSEFBLmtoaW5lQGJtcHVibGljYXRpb25z
LmNvLnVrPgAAAAMABhDej96TAwAHEIgCAAADABAQAAAAAAMAERAAAAAAHgAIEAEAAABlAAAAQ0FO
QU5ZT05FSEVMUE1FVU5ERVJTVEFORFRIRUNPTkNFUFRCRUhJTkRUSElTRVhBTVBMRTpJTlRIRUhP
Vy1UT0ZST01IVFRQOi8vV1dXWk9QRU9SRy9NRU1CRVJTL0FMRVhSLwAAAABKlw==

------=_NextPart_000_0012_01C0B6DF.E3E60A00--