RE: Scripting Functoids and SQL LookUps
- From: jeremy <jeremy@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 23 Jun 2005 04:17:03 -0700
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_looking_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.
>
.
- Follow-Ups:
- RE: Scripting Functoids and SQL LookUps
- From: RAB
- RE: Scripting Functoids and SQL LookUps
- References:
- Scripting Functoids and SQL LookUps
- From: RAB
- Scripting Functoids and SQL LookUps
- Prev by Date: Effect of input EDI and the generation of XML using HIPAA
- Next by Date: Re: BT MQSeries adapter 2.0
- Previous by thread: Scripting Functoids and SQL LookUps
- Next by thread: RE: Scripting Functoids and SQL LookUps
- Index(es):
Relevant Pages
|
