Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Development, Plugins and Globals :

Re: [afinlr] Tricky global with two tables

Apr 5, 2004, 3:08 PM
Coyu
User (100 posts)
Apr 5, 2004, 3:08 PM
Views: 3057
Shortcut
Quote Reply
Re: [afinlr] Tricky global with two tables In reply to
Hey,
i think the best thing would be a global, which works so:
<%globalname(Date_No, Attribute_No)%>
So that means:
- Find the value of column Date_No in tableX
- Search in this value for the column Attribute_No in tableY and print it out

So when "testy" would be logged in and the global would have this parameters:
<%globalname(Date2, Attr2)%>
the output would be "F" with this two tables:

tableX:
Username (PRI) Date1 Date2
------------------------
demo 2004-03-02 2004-03-01
testy 2004-03-20 2004-03-04

tableY:
Date(PRI) Attr1 Attr2
-----------------------
2004-03-02 A B
2004-03-03 C D
2004-03-04 E F

So how the global should be?

Thanks in advance,

Coyu
Subject Author Views Date
Thread Tricky global with two tables Coyu 3223 Apr 3, 2004, 7:43 AM
Thread Re: [Coyu] Tricky global with two tables 		afinlr 3127 Apr 3, 2004, 8:04 AM
Thread Re: [afinlr] Tricky global with two tables 		Coyu 3129 Apr 3, 2004, 9:54 AM
Thread Re: [Coyu] Tricky global with two tables 		afinlr 3113 Apr 3, 2004, 10:02 AM
Thread Re: [afinlr] Tricky global with two tables 		Coyu 3112 Apr 3, 2004, 10:48 AM
Thread Re: [Coyu] Tricky global with two tables 		afinlr 3088 Apr 4, 2004, 4:44 PM
Post Re: [afinlr] Tricky global with two tables 		Coyu 3074 Apr 5, 2004, 12:34 AM
Post Re: [afinlr] Tricky global with two tables 		Coyu 3057 Apr 5, 2004, 3:08 PM