You might want to check out Anthony Baxter's data miner product at http://www.interlink.com.au/anthony/. Yeah, okay, it may be a 0.1 release, but there's plenty of good stuff in there to give you some ideas. Ciao-ness, John
-----Original Message----- From: HCSCCS@prudential.com.my [SMTP:HCSCCS@prudential.com.my] Sent: Thursday, July 29, 1999 3:47 AM To: zope@zope.org Subject: [Zope] Dynamic SQL statement construct
As usual, I'm beeen using Zope-1.10.3-src, Zap-1.10, RedHat 5.2 and lately ZPyGresql Database Adaptor. I wonder whether we can dymanicaly construct an SQL statement. Below is the following situation:
DTML Method 1 :- ============ Contain 3 same combo box as the first, second and third sort key. Each
combo box contains 3 sort keys, Aeg. A, B, C. User will choose the combination of keys they want and submit the page..
DTML Method 2 : ============ Display the information as the sorted manner defined in the earlier page.
So how do you guys think? Can Z SQL Method do that? The followings are the possible key combinations: ABC ACB BAC BCA CAB CBA AB AC BA BC CA CB A B C
Do we need to BUILD 15 Z SQL Method?? If not, what is the proper way?
Please reply to hcsccs@prudential.com.my as well.
Thanks a lot, Paul Chung Paul Chung Executive IT Department Prudential Assurance Malaysia Berhad
_______________________________________________ Zope maillist - Zope@zope.org http://www.zope.org/mailman/listinfo/zope
(To receive general Zope announcements, see: http://www.zope.org/mailman/listinfo/zope-announce
For developer-specific issues, zope-dev@zope.org - http://www.zope.org/mailman/listinfo/zope-dev )