In addition to these features, I'm more hoping that Version 6 will
release Oracle thread counts upon datasource expiration on Windows
2003 platform.
Any pricing information yet on upgrade from 5.5?
Thanks!
MC
At 06:25 PM 5/31/2007, you wrote:
SOME of the new features are:
New Witango Studi
I believe even though the search builder shows that syntax, the
witango server uses correct ansi syntax. At least I see it do that
with mysql.
--
Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
13653 West Park Dr
Magalia, Ca 95954
ph: 530.645.4040 x222
I have two feature requests:
1. We have always been able to dynamically specify a sort field using
an argument or variable. However, we have never been able to dynamically
specify the sort direction (ie. ascending or descending). I request that
the sort direction can be set up in a similar way as
Ben
When you get/resolve/build a solution for these, PLEASE let us know.
Stephen
OnlyTOYS.com
The above was in reply to your inquiry, quoted as follows:
>Ok,
>
>been looking all over for any thing on fedex/ups web service calls.
>Anyone have any examples or can point me in right direction
>
>B
Be careful of using "=*" and "*=", some of our SQL servers will take that
and others require the "... OUTER JOIN" syntax.
--
Beverly Voth Tier3 Data & Web Services Group, LLC
606-864-0041 http://www.tier3web.com/xml.htm
Web Design & Hosting
Cold
You can do this in the search action builder
by selecting the
=* (left outer join)
*= (right outer join)
in the join section
Ben
On Jun 5, 2007, at 9:34 AM, Wolf, Gene wrote:
Yep. This was the kind of thing I was looking for. Didn't know you
could do "ON shipping.toloc = ." Thanks for
Yep. This was the kind of thing I was looking for. Didn't know you
could do "ON shipping.toloc = ." Thanks for your help all.
Appreciate the feedback!
-Original Message-
From: William Conlon [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 05, 2007 12:12 PM
To: witango-talk@witango.c
Gene, You're after something like this?
SELECT shipping.id, shipping.FromLoc, shipping.ToLoc,
To_location.name, From_location.name
FROM shipping
LEFT JOIN locations To_location ON shipping.ToLoc = To_location.id
LEFT JOIN locations From_location ON shipping.FromLoc = From_location.id
WHERE ...
Hope this helps. Paste it into a results action. Let me know if the code
has been corrupted in transit.
<@ASSIGN request$reportArray <@ARRAY
VALUE="1,10,12;2,14,10;3,11,9;4,12,11;5,100,0">>
<@ASSIGN request$toArray <@ARRAY VALUE="12,Boston;10,Dallas;9,New
Orleans;11,Los Angeles;">>
<@ASSIGN
Gene, if these are in an array, then you have to look them up, eh? :D
If they are in a SQL table, you have to query them, right?
You have a "join table". If you are creating these "on-the-fly" and putting
the values into an array, why not put the "text" locations into columns,
too, as you make
I knew this wasn't going to be clear the first time. *laughs*
Assume a record with the following fields and data:
Field names:RecIDFromLocToLoc
11012
21410
Question of joinsI'm not sure I'm following you. I think you have a file
that contains an "array" of values, and you want to do a join-like operation
with your DB for reporting purposes.
If this is the case, you can probably use <@FILTER> to get only the relevant
records from each array. If you
This is probably simplistic and perhaps more of a SQL question than a
Witango question but I'm going to ask anyway. *laughs* I have an
application set up where a user selects a from location and a to
location, from a dropdown list, of something they are shipping. The
dropdown list is populated f
13 matches
Mail list logo
