Hi! ---------------------------- I use the following expression in a header file which is included in every document/method to get the content of the actual folder and show the title as menue item. <dtml-in expr="PARENTS[0].objectValues(['DTML Document'])" sort=title> <tr> <td><a href="<dtml-var "absolute_url()">"><dtml-var title></a></td> </tr> </dtml-in> But I don't want to show the current "DTML Document" as part of the menue. ---------------------------- example: Communication (Folder) | | |- <default_html_header> (DTML Method) | |- Contact (Folder) | | | |- <index_html> (DTML Document)> | |- <contact_addForm> (DTML Document)> | |- .... | |- News (Folder) . | . |- <index_html> (DTML Document)> |- .... ok, <default_html_header> uses the dtml expression above and is included in every other document/method/whatever ... <contact_addForm> includes <default_html_header> and I don't want to show <contact_addForm> in the menue!!!! How can I exclude the current document? TIA Wolfgang
this is probably a hack but you could use the id of the document you want to exclude with an unless statement. this is what i did when i wanted to exclude the index_html doc <dtml-in "PARENTS[0].objectValues(['DTML Document'])" reverse sort=bobobase_modification_time> <dtml-unless "_.string.find(_['id'],'index_html')==0"> <p><a href="<dtml-var URL1>/<dtml-var id>"><dtml-var title></a><br> <dtml-if jdate><dtml-var jdate><br></dtml-if> <dtml-if summary> <dtml-var summary><br></dtml-if> last modified: <dtml-var bobobase_modification_time fmt=pCommon><p> </dtml-unless> </dtml-in> hth Regards, GEORGE DONNELLY george@cyklotron.com http://cyklotron.com/ Part of becoming a writer is the desire to have everything mean something. --Louise Erdrich
But I don't want to show the current "DTML Document" as part of the menue.
Wolfgang Klinger wrote:
Hi!
---------------------------- I use the following expression in a header file which is included in every document/method to get the content of the actual folder and show the title as menue item.
<dtml-in expr="PARENTS[0].objectValues(['DTML Document'])" sort=title>
<tr> <td><a href="<dtml-var "absolute_url()">"><dtml-var title></a></td> </tr>
</dtml-in>
But I don't want to show the current "DTML Document" as part of the menue.
IIRC, I do something like this .... <dtml-in expr="PARENTS[0].objectValues(['DTML Document'])" sort=title> <dtml-unless "this() == _['sequence-item']"> <tr> <td><a href="<dtml-var "absolute_url()">"><dtml-var title></a></td> </tr> </dtml-unless this is the document> </dtml-in> But I could be wrong, I don't have it handy, ATM. -- Do not meddle in the affairs of sysadmins, for they are easy to annoy, and have the root password.
I'm retrieving data from an Access database, on windows 98, via an ODBC connection, and my problem is that it is very very slow: retrieving 1 record is fast enough, but retrieving 20 records takes 20 seconds, occupies my CPU completely and has my harddisk running hard. I've done a little bit of testing, and the time it takes to retrieve the data seems not be related to the complexity of the query or the number of records, but to the amount of information retrieved (i.e. retrieving long strings takes much longer than small numbers). Any suggestions? Jelle __________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com
On Wed, 26 Jul 2000, Jelle Gerbrandy wrote:
I'm retrieving data from an Access database, on windows 98, via an ODBC connection, and my problem is that it is very very slow: retrieving 1 record is fast enough, but retrieving 20 records takes 20 seconds, occupies my CPU completely and has my harddisk running hard.
I've done a little bit of testing, and the time it takes to retrieve the data seems not be related to the complexity of the query or the number of records, but to the amount of information retrieved (i.e. retrieving long strings takes much longer than small numbers).
Any suggestions?
Using Win98 for database and WWW? No. Upgrade! win98 => Linux of FreeBSD Access => PostgreSQL or MySQL or Interbase ODBC DA => corresponding DA FreeBSD is pretty stable, but is a bit harder to install and maintain for novice. Linux is simpler, if you use user-oriented distribution (SuSe, Caldera, Corel). MySQL is superfast, but supports only a limited subset of SQL. PostgreSQL supports a good deal of complex SQL, but is a bit slow. Interbase is relatively fast mid-range SQL server. All these DBs have Zope Database Adapters. Oleg. (All opinions are mine and not of my employer) ---- Oleg Broytmann Foundation for Effective Policies phd@phd.russ.ru Programmers don't die, they just GOSUB without RETURN.
participants (5)
-
Bill Anderson -
George Donnelly -
Jelle Gerbrandy -
Oleg Broytmann -
Wolfgang Klinger