At 11:46 2003-02-21 +0100, Joakim Nicander said:
*This message was transferred with a trial version of CommuniGate(tm) Pro*
We have several customer sites with dynamic pages created with data from
MySql.

Many search engines doesn't index an URL with a query string like:

Http://www.somesite.com/category_page?category=2

will be indexed as:

Http://www.somesite.com/category_page

Is there a method with in Zope or a Zope product that can help me create a
site map with links like:

Http://www.somesite.com/category_page/category/2

I know there is a tool for asp http://xde.net/xq/tool.xqasp/qx/index.htm.
Something similar for Zope?

I guess apache with mod_rewrite can help me but I rather do it within Zope.



You can make the SQL Methods traversable like: SQLmethod/category/2


"""In order to traverse to result objects with URLs, you must be able to ensure that the SQL Method
will return only one result object given one argument. For example, create a new Z SQL Method
named 'category_page' that accepts one argument, category, and has the following SQL Template: """

        select * from
category_table where
          <dtml-sqltest
category op=eq type=int>

The you need a presentation (DTML Method for instace) on the top of it all to produce a presentation:

DTML Method: /viewC
ategoryPage
and access the record with: SQLmethod/cattegory/2/
viewC
ategoryPage
You can also use traversal in combination with Plugable Brains defined in the Extensions directory.

Pluggable Brains are classes that define objects with extended functionality for the list of brains
returned by the SQL Method.

Brest Regards,
Johan Carlsson

--
Torped Strategi och Kommunikation AB
Johan Carlsson
johanc@easypublisher.com

Mail:
Birkagatan 9
SE-113 36  Stockholm
Sweden

Visit:
Västmannagatan 67, Stockholm, Sweden

Phone +46-(0)8-32 31 23
Fax +46-(0)8-32 31 83
Mobil +46-(0)70-558 25 24
http://www.easypublisher.com
http://www.torped.se