Steve,
What you really want is two separate instances of the teams table,
one representing team 1, and one for team 2. Any time you do
something that tricky in SQL, you are more likely to get what you want
in R:Tango by resorting to the Direct DBMS action:
I would change the select action to a
Steve
-Original Message-
From: Bill Downall [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 09, 2002 5:49 PM
To: Multiple recipients of list witango-talk
Subject: Re: Witango-Talk: Database View
Steve,
What you really want is two separate instances of the teams table,
one representing
I have a similar application and I found it easier to create a user (or
application) scope variable that contains the team names. The search action
brings back the participants in a game and I use the following to display
their team name:
<@ASSIGN NAME="la_temphometeam" VALUE=<@FIL
On Mon, 9 Dec 2002 18:19:12 -0600, Fogelson, Steve wrote:
>Are the results of
>the Direct DBMS action stored in @@resultSet?
>
>As far as the alternate, do you mean create a view within R:Base or
create a
>view with a Direct DBMS action?
>
>Are R:Base views accessible from Witango?
Yes, the resu
es @ http://www.witango.ws
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Bill Downall
Sent: Monday, December 09, 2002 4:27 PM
To: Multiple recipients of list witango-talk
Subject: RE: Witango-Talk: Database View
On Mon, 9 Dec 2002 18:19:12 -0600, Fogelson, Steve wro
Hi,
> I just wanted to bring to your attention that the @@resultset from a
> DirectDBMS is different from a Search action with regards to column
> names
>
> The resultset from a search action returns the column names into the row
> zero of the array whereas the directdbms doesn't
I feel obliged
m: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Simon Boddy
Sent: Tuesday, December 10, 2002 2:11 AM
To: Multiple recipients of list witango-talk
Subject: Re: RE: Witango-Talk: Database View
Hi,
> I just wanted to bring to your attention that the @@resultset from a
> DirectDBMS is