|
Home > Archive > BizTalk Server General > June 2005 > Scripting Functoids and SQL LookUps
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Scripting Functoids and SQL LookUps
|
|
|
| So what I need is the WHERE clause capabilities within the Database LookUp
Functoids.
For example, SELECT Value FROM Table_StringMap WHERE
AttribteName=picklist_name AND AttributeValue=picklist_value_I_am_looki
ng_for
I dont think Database LookUp Funtoids do that. Let me know if they do.
So, in order to get around the limited capabilities, I would like to use a
scripting functoid.
Question:
Can I do the following in a scripting functoid (VBScript)
Set Connection = Server.CreateObject("ADODB.Connection")
Set Command = Server.CreateObject("ADODB.Command")
If I could do this then I believe I can retrieve the value I need.
Anyone, please help.
Thank you.
| |
| jeremy 2005-06-23, 5:55 pm |
| RAB,
Assuming you are referring to BTS2k4, Any specific reason you dont want to
use or cant use the business rules engine to do this lookup for you? For a
performance standpoing it may be more beneficial to do it there.
Jeremy
"RAB" wrote:
> So what I need is the WHERE clause capabilities within the Database LookUp
> Functoids.
>
> For example, SELECT Value FROM Table_StringMap WHERE
> AttribteName=picklist_name AND AttributeValue=picklist_value_I_am_looki
ng_for
>
> I dont think Database LookUp Funtoids do that. Let me know if they do.
>
> So, in order to get around the limited capabilities, I would like to use a
> scripting functoid.
>
> Question:
>
> Can I do the following in a scripting functoid (VBScript)
>
> Set Connection = Server.CreateObject("ADODB.Connection")
> Set Command = Server.CreateObject("ADODB.Command")
>
> If I could do this then I believe I can retrieve the value I need.
>
>
> Anyone, please help.
> Thank you.
>
| |
|
| Saddly, I am using BTS2002....... and since I'm pretty new to BTS, I've been
trying to find the easiest solution for my problem. So, do you know if I
could call the Server.CreateObject(.....) from within a vbs scripting
functoid. Thanks again.
-Robert
"jeremy" wrote:
[vbcol=seagreen]
> RAB,
>
> Assuming you are referring to BTS2k4, Any specific reason you dont want to
> use or cant use the business rules engine to do this lookup for you? For a
> performance standpoing it may be more beneficial to do it there.
>
> Jeremy
>
> "RAB" wrote:
>
|
|
|
|
|