Hi Steve,
What you want to do can't be done in the builder, but you can use the
builder to start your taf, then take the actions out of the builder.
What you need to do is go to the search action where you want to change the
search criteria. Go to the "Criteria" tab of the search action. Right
Witango's search action is pretty good at interpreting your intentions.
You can do AND sub groups within OR by
Table.column1 = blah
And Table.column2 = blah
Or Table.column1 = hoo
And Table.column2 = hum
Notice that I have drag column1 and column 2 in twice. The search action
will create the fo
Steve,
You might consider using a direct dbms action instead of a search action.
That way you have complete control over the where clause.
Or, if you have 2 price columns, say retail and wholesale, you could put
both in the criteria:
Products.retail >= <@if expr='@@user$U_Price_Display=retail
Hi Steve,
You have a copy of my Tango Debugging Tools don't you? If so, connect to
your datasource, copy your select statement from the debug code and
paste it in the SQL Command window. Then tweak it manually until you get
the syntax just right. Maybe the column UDisabled is not a text
datatype,
Interesting…
What version of the Dev Studio?
Steps…
I opened a search action
Selecte “Summary of
Groups” under Select Type
dragged in State column in to “Group
By Columns and left the function as NONE
dragged in City column in to “Group
By Columns and left the f
Yes that works fine, but it screws up when I close the Search action then open it up again, then move the COUNT column around.
Like when it reads the node for the search action something is getting messed up.
And each time I close, open, and rearrange the column I get another DISTINCT.
-B
On T
Hi,
I think I found the answer. I replaced the Search
Action with a Direct DBMS action and the data now appears on the page. The
code's the same in the Result html.
Is there a bug in the Search action? Or a limitation?
But I can't get it to fail on another server.
Ted
From: Ted Wolfl
I have a search action that is bringing back items in a database. The items
are only a I.D., NewsTitle, Date (in 00/00/ for), and news story.
I only want to bring back the wants that match the current month that we are
in. I think that I could bring back like March for example, but for the
cur
well, you can do this to get the current month in 00 format:
<@substring str="<@currenttimestamp>" start=1 numchars=2>
- Original Message -
From: "Steve Campbell" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 04, 2003 12:46
To: [EMAIL PROTECTED]
Subject: Re: Witango-Talk: Search Action-only month
I have a search action that is bringing back items in a database. The items
are only a I.D., NewsTitle, Date (in 00/00/ for), and news story.
I only want to bring back the wants that match the current month that we are
i
d translate (in this months case) to:
and Date >= '04/01/2003'
- Original Message -
From: "Atrix Wolfe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 04, 2003 1:00 PM
Subject: Re: Witango-Talk: Search Action-only month
> well, you can
on to compare the returning number to the
> month you're looking for?
>
>
>
> -Original Message-
> From: Steve Campbell [mailto:[EMAIL PROTECTED]
> Sent: Friday, April 04, 2003 3:46 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Witango-Talk: Search Action-only
gt;
> <@substring str="<@currenttimestamp>" start=1 numchars=2>
>
>
>
> - Original Message -
> From: "Steve Campbell" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, April 04, 2003 12:46 PM
> Subject: Re: Witango-Ta
Community
-
XML-Extranet - http://xml-extra.net
403-281-6090 - [EMAIL PROTECTED]
--
Well-formed Development (for hire)
-
- Original Message -
From: "Steve Campbell" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 04, 2003 2:14 PM
Subjec
c,
> Witango.org - http://witango.org
> 403-281-6090 - [EMAIL PROTECTED]
> --
> Information for the Witango Developer Community
> ---------
>
> XML-Extranet - http://xml-extra.net
> 403-281-6090 - [EMAIL PROTECTED]
> --
> Well-formed Development (for hire)
're in business. :)
> -Original Message-
> From: Steve Campbell [mailto:[EMAIL PROTECTED]
> Sent: Friday, April 04, 2003 3:13 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Witango-Talk: Search Action-only month
>
>
> I sure could
>
> But this is for a cust
mpbell [mailto:[EMAIL PROTECTED]
>> Sent: Friday, April 04, 2003 3:13 PM
>> To: [EMAIL PROTECTED]
>> Subject: Re: Witango-Talk: Search Action-only month
>>
>>
>> I sure could
>>
>> But this is for a customer..small project..and I used
>> Access.
tp://www.pcforge.com/AltN.htm
-Original Message-
From: Wilcox, Jamileh [mailto:[EMAIL PROTECTED]
Sent: Friday, April 04, 2003 1:44 PM
To: [EMAIL PROTECTED]
Subject: RE: Witango-Talk: Search Action-only month
Actually, Access allows for datepart as well, but I don't know how to
set up
tp://www.pcforge.com/AltN.htm
-Original Message-
From: Steve Campbell [mailto:[EMAIL PROTECTED]
Sent: Friday, April 04, 2003 1:49 PM
To: [EMAIL PROTECTED]
Subject: Re: Witango-Talk: Search Action-only month
Jami
That¹s what I was looking for. Doing it in a search criteria.
Thanks
Steve
Hey Steve,
If you can see that witango is generating the correct sql, you might have
better luck asking about this on the r:list (might also help if you provide
some more details!).
- Original Message -
From: "Fogelson, Steve" <[EMAIL PROTECTED]>
To: "Witango User Group (E-mail)" <[EMAIL
I guess the best way to explain it is this.
The R:Tango server limit is not going to act like limit in RBase
R>prompt.
The limit is for the output not the data collected based on the
criteria.
So if the criteria returns 155 rows, then 155 rows are going to be
collected into a cache and then the li
There was a change in the sql handler in 5.5 that is causing your problem.
I ran into it too. Contact With about it. They seem to have a tentative fix
for the problem.
Stefan
At 01:37 AM 1/28/2005, you wrote:
I would appreciate another set of eyes looking at this.
I have a search action
Connecting
22 matches
Mail list logo