[Zope] Dynamic SQL statement construct

[Miller, John M.]

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 )