| Author |
Passing external parameters into the orchestration
|
|
| anonymous 2006-03-06, 8:47 pm |
| How do i pass external values into a orchestration.I tried
promoting/distinguishing a input message schema element to do the same but
all my schema elements are multioccurs so i cannot promote or distinguish
them.aAlso i have no hold over the schema of my input message.anybody out
there who had a similiar situation.
| |
| Eric Stott 2006-03-07, 5:51 pm |
| What kind of variables are you trying to pass into the orchestration, if you
have no control over the schema?
Eric
http://stottcreations.com/blog
"anonymous" <anonymous@discussions.microsoft.com> wrote in message
news:19604BB4-8F33-41F5-A566-367AB43485F7@microsoft.com...
> How do i pass external values into a orchestration.I tried
> promoting/distinguishing a input message schema element to do the same but
> all my schema elements are multioccurs so i cannot promote or distinguish
> them.aAlso i have no hold over the schema of my input message.anybody out
> there who had a similiar situation.
| |
| anonymous 2006-03-07, 8:47 pm |
| The schema is given to me by the customer and i need to pass in a value to
decide how many records to query from the database is that possible?
"Eric Stott" wrote:
> What kind of variables are you trying to pass into the orchestration, if you
> have no control over the schema?
> Eric
> http://stottcreations.com/blog
>
> "anonymous" <anonymous@discussions.microsoft.com> wrote in message
> news:19604BB4-8F33-41F5-A566-367AB43485F7@microsoft.com...
>
>
>
| |
| Eric Stott 2006-03-07, 8:47 pm |
| What determines how many records to query?
"anonymous" <anonymous@discussions.microsoft.com> wrote in message
news:1C84BF0B-F3D4-4A31-BDC4-8A9619E5E9D7@microsoft.com...[vbcol=seagreen]
> The schema is given to me by the customer and i need to pass in a value to
> decide how many records to query from the database is that possible?
>
> "Eric Stott" wrote:
>
| |
| anonymous 2006-03-07, 8:47 pm |
| A condition value Example If we take northwind db orders table i need to get
the all the orders less than a particular orderid so i expect this to be
provided as in input to the orchestration which then pass this value to a
..net dll which internally executes this query and returns the values of all
the orders
"Eric Stott" wrote:
> What determines how many records to query?
> "anonymous" <anonymous@discussions.microsoft.com> wrote in message
> news:1C84BF0B-F3D4-4A31-BDC4-8A9619E5E9D7@microsoft.com...
>
>
>
| |
| Eric Stott 2006-03-07, 8:47 pm |
| how are you going to be getting the particular orderid, is the customer
going to be sending it to you along with the message, or is the orderid
going to be in the message somewhere?
"anonymous" <anonymous@discussions.microsoft.com> wrote in message
news:CA466F9E-1F80-499B-BE42-B93F7363DACD@microsoft.com...[vbcol=seagreen]
>A condition value Example If we take northwind db orders table i need to
>get
> the all the orders less than a particular orderid so i expect this to be
> provided as in input to the orchestration which then pass this value to a
> .net dll which internally executes this query and returns the values of
> all
> the orders
>
> "Eric Stott" wrote:
>
| |
| anonymous 2006-03-07, 8:47 pm |
| Well that's what i am asking for,based on the solution we need to propose one.
"Eric Stott" wrote:
> how are you going to be getting the particular orderid, is the customer
> going to be sending it to you along with the message, or is the orderid
> going to be in the message somewhere?
> "anonymous" <anonymous@discussions.microsoft.com> wrote in message
> news:CA466F9E-1F80-499B-BE42-B93F7363DACD@microsoft.com...
>
>
>
| |
| Eric Stott 2006-03-07, 8:47 pm |
| Well, there are a few options then,
1. You could have them send you all of the orders, and then you can use
xpath (http://www.w3schools.com/xpath/xpat...ons.asp#context) to grab
the last orderid from the message, and then create a call to the stored
procedure based on that value.
2. You could have them place the orderid in the data somewhere that you can
always go to and pull it out, but I think that is not an option, as your
earlier posts say that you don't have that kind of control over what is
coming in.
3. You could have a parallel action and get the "order" message and then a
subsequent message with some correllating id, and in the second message,
have variables that you need to use in your call to the stored proc.
(Correllate on the filename for example: Order01.File.xml and
Order01.Paramaters.xml)
I might be able to help you more if I knew more about your situation, send
me an email if you would like and I could get you a demo if needed.
Eric
http://stottcreations.com/blog
"anonymous" <anonymous@discussions.microsoft.com> wrote in message
news:F0186862-8990-4D81-AB87-6F6692E45CF4@microsoft.com...[vbcol=seagreen]
> Well that's what i am asking for,based on the solution we need to propose
> one.
>
> "Eric Stott" wrote:
>
| |
| anonymous 2006-03-07, 8:47 pm |
| Thanks Eric i think i can use the first option .I will try it out and tell you
"Eric Stott" wrote:
> Well, there are a few options then,
> 1. You could have them send you all of the orders, and then you can use
> xpath (http://www.w3schools.com/xpath/xpat...ons.asp#context) to grab
> the last orderid from the message, and then create a call to the stored
> procedure based on that value.
> 2. You could have them place the orderid in the data somewhere that you can
> always go to and pull it out, but I think that is not an option, as your
> earlier posts say that you don't have that kind of control over what is
> coming in.
> 3. You could have a parallel action and get the "order" message and then a
> subsequent message with some correllating id, and in the second message,
> have variables that you need to use in your call to the stored proc.
> (Correllate on the filename for example: Order01.File.xml and
> Order01.Paramaters.xml)
>
> I might be able to help you more if I knew more about your situation, send
> me an email if you would like and I could get you a demo if needed.
>
> Eric
> http://stottcreations.com/blog
>
>
> "anonymous" <anonymous@discussions.microsoft.com> wrote in message
> news:F0186862-8990-4D81-AB87-6F6692E45CF4@microsoft.com...
>
>
>
|
|
|
|