Hi Charlene, Have you read the section of the Zope book regarding Dynamic SQL Queries? In particular, look for info on the "sqlgroup" tag. ( http://www.zope.org/Members/michel/ZB/RelationalDatabases.dtml ) and about 2/3 down the page you will see a heading that reads "Creating Complex Queries with the Sqlgroup Tag" If you need more detailed help, it would be helpful for us to see the SQL you are using now. Eric.

-----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of CHOY,CHARLENE (HP-Boise,ex1) Sent: Tuesday, August 07, 2001 1:54 PM To: Zope List (E-mail) Subject: [Zope] Sql questions.

Hi, The following is my problem. I have created a search form to look up some data from a database. The result of the search needs to be able to return the searched data in certain order. How do I set condition in the sql method so that it will return the object that I want and also specific sorting_method that the user had chosen in the form. I have attempted to solve this problem. I have created two sql methods but both of them perform two differenct tasks. One of them is able to return the searched data that I want, but the data are not in order. The second sql will return correct order, but it includes some other serch data that I don't want. Does anyone know to combine both of them so that the users can get the data that they are looking for in the sorting method that they have chosen? I would also like to know is there anyway that i can set some if/elif/else condition in the dtml-sql? If so how can I do it.

-Charlene

_______________________________________________ Zope maillist - Zope@zope.org 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 )