Lookups

#1

Is it possible to have a lookup with multiple parameters?
If so, how do you pass them via an ActiveX script?

Example: Select * from employee where jobid between # and
#

Thanks in advance

#2

yes

simply create an SQL :
select * from employee where jobid between ? and ?

and call it:
result = DTSLookups("namehere").Execute(param1, param2)

If your result return more then 1 value, then result is a recordset object

"ScubaFrog" <scuba79 (AT) spammeanddie (DOT) bellsouth.net> a écrit dans le message de
news:3acc01c34030$a2224a70$a401280a (AT) phx (DOT) gbl...

Quote:

Is it possible to have a lookup with multiple parameters?
If so, how do you pass them via an ActiveX script?

Example: Select * from employee where jobid between # and
#

Thanks in advance

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.495 / Virus Database: 294 - Release Date: 2003-06-30

#3

Have a look at this article

How to Use Lookups in DTS
http://www.sqldts.com/default.aspx?6,107,277,7,1

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"ScubaFrog" <scuba79 (AT) spammeanddie (DOT) bellsouth.net> wrote

Quote:

Is it possible to have a lookup with multiple parameters?
If so, how do you pass them via an ActiveX script?

Example: Select * from employee where jobid between # and
#

Thanks in advance

#4

Thanks for the input

Quote:

-----Original Message-----
yes

simply create an SQL :
select * from employee where jobid between ? and ?

and call it:
result = DTSLookups("namehere").Execute(param1, param2)

If your result return more then 1 value, then result is a
recordset object

"ScubaFrog" <scuba79 (AT) spammeanddie (DOT) bellsouth.net> a écrit
dans le message de
news:3acc01c34030$a2224a70$a401280a (AT) phx (DOT) gbl...
Is it possible to have a lookup with multiple
parameters?
If so, how do you pass them via an ActiveX script?

Example: Select * from employee where jobid between #
and
#

Thanks in advance

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.495 / Virus Database: 294 - Release Date:
2003-06-30

.

#5

Thanks for the input

Quote:

-----Original Message-----
Have a look at this article

How to Use Lookups in DTS
http://www.sqldts.com/default.aspx?6,107,277,7,1

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"ScubaFrog" <scuba79 (AT) spammeanddie (DOT) bellsouth.net> wrote in
message
news:3acc01c34030$a2224a70$a401280a (AT) phx (DOT) gbl...
Is it possible to have a lookup with multiple
parameters?
If so, how do you pass them via an ActiveX script?

Example: Select * from employee where jobid between #
and
#

Thanks in advance

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Lookups

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Lookups - 07-01-2003 , 07:26 PM

Re: Lookups - 07-01-2003 , 09:07 PM

Re: Lookups - 07-02-2003 , 02:04 AM

Re: Lookups - 07-02-2003 , 06:01 PM

Re: Lookups - 07-02-2003 , 06:02 PM