Create a Direct DBMS action
Your basic query is:
select
u.[ID], u.[Name], u.[Type], u.BossID, b.[Name] as BossName
from
[User] u
join [User] b on u.BossID = b.ID
This should result in a 2D array of every user (including bosses) with their
immediate bosses name output as "BossName".
@URL can do soap, but only some of the time. Witango needs a good soap
client. Also, soap usually requires namespaces and other features that
witango xml implementation has a very hard time with.
--
Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
13653
Yeah I also have a few examples here.
Let me know if you need an example :)
Kaustav Acharya
Technical Customer Service Manager
U. Inc.
12250 El Camino Real, Suite #100
San Diego, CA. 92130
Office: (858) 847-3350 x1004
Fa
I had made a similar request some time ago (about 2 years) and so far
nothing concrete as far as doing a web service connection only using
WiTango.
I do have a few tafs I was working on that connect successfully to a web
service and bring back data. The problem is parsing the data the is posted
ba
your going to have to create a separate search action which get the
distinct manager id and name
then your going to have to change the output to make the pulldown get
its data from this new search action you did prior
this is custom, and can't be done in search builder
On Sep 16, 2008, at 3:
if it was in two separate table I could do that, but it's in the same
table...
> -Original Message-
> From: Ben Johansen [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, September 16, 2008 05:18
> To: witango-talk@witango.com
> Subject: Re: Witango-Talk: Should be simple...
>
> you are going
you should be able to join on same table.
select b.id,b.name,b.type,b2.name as bossname from users b
left join users b2 on b.bossid = b2.id
--
Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
13653 West Park Dr
Magalia, Ca 95954
ph: 530.645.4040 x222 fax
you are going to have to make a JOIN between the 2 tables in the
Search builder
On Sep 16, 2008, at 3:12 PM, Tom Ferguson wrote:
But maybe my brain is just frozen...
I have a User Table with different types of users. Some of the
users are
bosses and some of the users are workers.
User T
But maybe my brain is just frozen...
I have a User Table with different types of users. Some of the users are
bosses and some of the users are workers.
User Table
ID
Name
Type (boss or user)
BossID
The BossID contains the ID of the boss' record.
I have a typical taf built from the search buil
Are you posting using @URL?
Kaustav Acharya
Technical Customer Service Manager
U. Inc.
12250 El Camino Real, Suite #100
San Diego, CA. 92130
Office: (858) 847-3350 x1004
Fax: (858) 847-3340
email: [EMAIL PROTECTED]
h
Hi Kaustav,
Nope. It's running on a ColdFusion backend.
Thanks for the reply.
Brian Humes
Director, Interactive
JohnsonRauhoff
269-428-9257 (direct)
269-428-3377 (main)
269-428-3312 (fax)
www.johnson-rauhoff.com
[EMAIL PROTECTED]
On Sep 16, 2008, at 4:28 PM, Kaustav Acharya wrote:
Is the
Is the web service running on a .NET backend? We had problems
formatting our headers from our Tango Server to a .NET server and
ended up having to post the XML to a .NET and box and have IT
transmit the data...
Kaustav Acharya
Technical
Hi all,
I'm attempting to tap into a web service (for the first time) and I'm
having some trouble. I think I have everything in the right place,
but I keep getting bad header errors and what not. Does anyone have
a .taf file that they wouldn't mind sharing with me that successfully
hits a
13 matches
Mail list logo