Christopher Rivard wrote:
http://groups.yahoo.com/group/zope/message/150345


I'm working offline, so can't see what you're refering to.

The solution that I have come to is to simply set a cookie and serve up the correct fields based on the cookie:

<dtml-if "17 in list_map_dir_id and 21 not in list_map_dir_id">
<dtml-call "RESPONSE.setCookie(list_type,'lodge')">
<dtml-elif "21 in list_map_dir_id and 17 not in list_map_dir_id">
<dtml-call "RESPONSE.setCookie(list_type,'resto')">
<dtml-elif "21 in list_map_dir_id and 17 in list_map_dir_id">
<dtml-call "RESPONSE.setCookie(list_type,'restolodge')">
<dtml-else>
<dtml-call "RESPONSE.setCookie(list_type,'other')">
</dtml-if>

<dtml-in insert_listing1_sql>
id: <dtml-var newid>
<dtml-call "REQUEST.set('list_map_list_id', newid)">
</dtml-in>
<dtml-call insert_listing_map_sql>
<dtml-call "RESPONSE.redirect('add_listing2?list_id=%s'%(REQUEST['list_map_list_id']))">

Oh my god! What the hell are you doing? Want some plyers to pull your fingernails out while you're at it?!

I am sure there are more elegant ways to do this - the client wanted the data in a RDBMS for portability....yah yah yah....

...and it looks like you don't have a clue about relational databases.

Sounds like you want to have an establishments table, a "features" table, and then learn to do a join on both to get the features for a given establishment.

sheesh, I'm on the verge of tears having read the above...

cheers,

Chris

--
Simplistix - Content Management, Zope & Python Consulting
           - http://www.simplistix.co.uk

_______________________________________________
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - http://mail.zope.org/mailman/listinfo/zope-announce
http://mail.zope.org/mailman/listinfo/zope-dev )

Reply via email to