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.

[ Post a follow-up to this message ]

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.

[ Post a follow-up to this message ]

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 y
ou
> 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... 
>
>
>

[ Post a follow-up to this message ]

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:
> 

[ Post a follow-up to this message ]

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... 
>
>
>

[ Post a follow-up to this message ]

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:
> 

[ Post a follow-up to this message ]

Well that's what i am asking for,based on the solution we need to propose on
e.

"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... 
>
>
>

[ Post a follow-up to this message ]

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:
> 

[ Post a follow-up to this message ]

Thanks Eric i think i can use the first option .I will try it out and tell y
ou

"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 ca
n
> 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... 
>
>
>

[ Post a follow-up to this message ]