[Zope] FW: Filling lists from SQL methods

[Norman Khine]

This is a multi-part message in MIME format.

------=_NextPart_000_0006_01C0B782.81AE5010
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit


> Hello,
> 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_0006_01C0B782.81AE5010
Content-Type: application/ms-tnef;
	name="winmail.dat"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
	filename="winmail.dat"

eJ8+IjMLAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEIAAUABAAAAAAAAAAAAAEJAAQAAgAAAAAA
AAABBoADAA4AAADRBwMAHAAMABsAAAADACEBAQOQBgDQBwAAKAAAAAsAAgABAAAACwAjAAAAAAAD
ACYAAAAAAAsAKQAAAAAAAwAuAAAAAAADADYAAAAAAB4ATQABAAAAAQAAAAAAAAAeAHAAAQAAAB8A
AABGaWxsaW5nIGxpc3RzIGZyb20gU1FMIG1ldGhvZHMAAAIBcQABAAAAGwAAAAHAtf211Qsp3fIh
zBHVmhIAYJcWaGAAXxK4IAALABcMAAAAAAIBHQwBAAAAIAAAAFNNVFA6S0hJTkVAQk1QVUJMSUNB
VElPTlMuQ08uVUsACwABDgAAAABAAAYOABotAXq3wAECAQoOAQAAABgAAAAAAAAANIcE9Sk91BGZ
DAAAHNYEI8KAAAALAB8OAQAAAAIBCRABAAAATwMAAEsDAAAPBQAATFpGdbqPDUsDAAoAcmNwZzEy
NRYyAPgLYG4OEDAzM48B9wKkA+MCAHBycQ5QCGZjaArAc2V0MPAgVGFoA3ECgwBQEGb/EUcHEwKD
ERESvghVB7ICgEp9CoF2CJB3awuAZBo0DGBjAFALA2ZpLcgxNDQBQGxpF/MM0JsX9A8TMhcQEOBv
dAWQ8nQLpDE2CqIKghnEAUAfCwQZxQ8GEmQB0CBIZWpsCQAsGqRDA5EAcHkiIAIgZSBoHZBwINkH
gCB1FvAEkHMBkBbwFCB0HwAgBaBuY2VxBTFiZWgW4SAhBAAgkGV4YW0LUGU6GqYNGsJJA6AgMkhv
dy04VG8gA1Ie8AJAcDoILy93JJAuem9whGUuBbBnL01lBtCJH7EvQSIAeFIvBmCrIgAaAGkCIEwE
AHQEIJhzdWInICZ0IEYDEDsYQA8gIBhAJvIj01NRDkwfQSAwBHBzLCB36R7hYXYe4GEpVSI6Gw9H
GdQM0BiSOTU5GKI5hDE4DMEyODc3DMGYMzgzGpAM0DQ3LYAxDME1NzUXEAzQNjd2MRzgDNA3MBAO
UAzQOAQ2MxKBMiA8U0VATEVDVCBuIdBlkD0ibXkm0iI+K1TBMWBkdG1sLQuAH0DKeSkhUQpQcnky
xjFgAE9QVElPTiBWQEFMVUU9JzNEdqcKwSfwHZBkMTHgdR2g+zIwMrAnNHg2DDFQNwYy1v4vM1Uy
xTogMYQyxSu/GdXfF1MKgCNhIGADkUkgYAlw/mEZ4CphJ3ECICAQKHInIP8jsCAwPtAp4B8APmIR
gCZiHzaFKdAgMj+jIYF1cGT/PtEgECPTAHAZ0B8ABcApIv5xNDIfcACQKEEgMjZQCkH1HrBmNoZh
BCBE5AchAmD7JQAiOlMjsQWxIbUp0D6AGSojdHdAAUbSczogylADYGQXMHRHA2BCkP8EIB/yShUQ
sDvDShwRUAQg0UoXcElEKdBEB5AFAx8moUu7TOpN3UrjRktf+006IjpUQ6EBEAWwHuAGkJ8gI0SA
FdFA5U04ID024BcgMSMEPzVkA2BwLWR3I3AzsQnwdSngKAEesWx/HqBUrAQgQHFTsVGbVbAgbjFH
G1NAAHBrS6U7tE4vBbADgTu0FlEAXeAACwABgAggBgAAAAAAwAAAAAAAAEYAAAAAA4UAAAAAAAAD
AAOACCAGAAAAAADAAAAAAAAARgAAAAAQhQAAAAAAAAsAFIAIIAYAAAAAAMAAAAAAAABGAAAAAIKF
AAABAAAAAwAcgAggBgAAAAAAwAAAAAAAAEYAAAAAUoUAACdqAQAeAB2ACCAGAAAAAADAAAAAAAAA
RgAAAABUhQAAAQAAAAQAAAA5LjAACwAegAggBgAAAAAAwAAAAAAAAEYAAAAABoUAAAAAAAADAB+A
CCAGAAAAAADAAAAAAAAARgAAAAABhQAAAAAAAAsAKIAIIAYAAAAAAMAAAAAAAABGAAAAAA6FAAAA
AAAAAwApgAggBgAAAAAAwAAAAAAAAEYAAAAAEYUAAAAAAAADACuACCAGAAAAAADAAAAAAAAARgAA
AAAYhQAAAAAAAB4AOoAIIAYAAAAAAMAAAAAAAABGAAAAADaFAAABAAAAAQAAAAAAAAAeADuACCAG
AAAAAADAAAAAAAAARgAAAAA3hQAAAQAAAAEAAAAAAAAAHgA8gAggBgAAAAAAwAAAAAAAAEYAAAAA
OIUAAAEAAAABAAAAAAAAAAIB+A8BAAAAEAAAADSHBPUpPdQRmQwAABzWBCMCAfoPAQAAABAAAAA0
hwT1KT3UEZkMAAAc1gQjAgH7DwEAAAB3AAAAAAAAADihuxAF5RAaobsIACsqVsIAAFBTVFBSWC5E
TEwAAAAAAAAAAE5JVEH5v7gBAKoAN9luAAAAQzpcUHJvZ3JhbSBGaWxlc1xDb21tb24gRmlsZXNc
U3lzdGVtXE1hcGlcMTAzM1xOVFxvdXRsb29rLnBzdAAAAwD+DwUAAAADAA00/TcAAAIBfwABAAAA
OgAAADxORUJCSkpBTURFSUhCSUNEQ05CT09FRVBDSEFBLmtoaW5lQGJtcHVibGljYXRpb25zLmNv
LnVrPgAAAAMABhD5ofXnAwAHEI4CAAADABAQAQAAAAMAERAAAAAAHgAIEAEAAABlAAAASEVMTE8s
Q0FOQU5ZT05FSEVMUE1FVU5ERVJTVEFORFRIRUNPTkNFUFRCRUhJTkRUSElTRVhBTVBMRTpJTlRI
RUhPVy1UT0ZST01IVFRQOi8vV1dXWk9QRU9SRy9NRU1CRVJTLwAAAACawA==

------=_NextPart_000_0006_01C0B782.81AE5010--