Passing Parameters to asp page

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Passing Parameters to asp page

Author

Topic

KTL_DK
Starting Member

15 Posts

Posted - 2003-09-09 : 08:29:39

Hello ,

I need a dts that reads the data from a table , and with
this data navigate to a Url .
Example:

Execute sql task: ActiveX Script Task:
select Id,name ----> Navigate to :
from users http://net/a.asp?id=1&name=pete
http://net/a.asp?id=2&name=bill
...
could someone tell me how to do this, or another way with Dts's that could work?
thanks,
Paul

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-09-09 : 12:13:40

Why do you want to use DTS for this? Why don't you just code everything in your ASP? DTS should be used sparingly. It seems that you just want to read a table, so why not do that in your ASP?

Tara

X002548
Not Just a Number

15586 Posts

Posted - 2003-09-09 : 13:07:15

quote:
Originally posted by KTL_DK

Execute sql task: ActiveX Script Task:
select Id,name ----> Navigate to :
from users http://net/a.asp?id=1&name=pete
http://net/a.asp?id=2&name=bill
...

What does that mean?

Also why not use strored procedures and use a recordset?

Brett

8-)

SELECT @@POST=NewId()

That's correct! It's an AlphaNumeric!

Stoad
Freaky Yak Linguist

1983 Posts

Posted - 2003-09-09 : 14:00:39

Brett,

you can fill up a web form by hand, typing into textboxes in browser's
window needful words, then press Submit button.

and you can do the same by executing a simple script (e.g. similar to
that I posted in the mirror of this topic).

How do you like to fill up a form for 100 times?
Don't ask me why you have to do this typing fuss. The life is versatile
enough that very often we can not predict someone's needs.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-09-09 : 14:13:47

But why use DTS for this?

Tara

X002548
Not Just a Number

15586 Posts

Posted - 2003-09-09 : 14:49:06

quote:
Originally posted by Stoad

Brett,

you can fill up a web form by hand, typing into textboxes in browser's
window needful words, then press Submit button.

and you can do the same by executing a simple script (e.g. similar to
that I posted in the mirror of this topic).

How do you like to fill up a form for 100 times?
Don't ask me why you have to do this typing fuss. The life is versatile
enough that very often we can not predict someone's needs.

I'll be damned if I undestand...

What do you mean?

Mirror?

typing fuss?

Life is versatile enough?

Huh?

HELP!

Brett

8-)

SELECT @@POST=NewId()

That's correct! It's an AlphaNumeric!

Stoad
Freaky Yak Linguist

1983 Posts

Posted - 2003-09-09 : 14:50:44

People like DTS packages for their home-like
cosyness and dummy-friendly appearence. Opa.

We, dummies, like DTS packages (and cursors)!!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-09-09 : 14:54:08

quote:
Originally posted by Stoad

People like DTS packages for their home-like
cosyness and dummy-friendly appearence. Opa.

We, dummies, like DTS packages (and cursors)!!

I understand why people like it. But you still shouldn't use it for what Paul is trying to use it for, at
least as far as I can tell.

Tara

Stoad
Freaky Yak Linguist

1983 Posts

Posted - 2003-09-09 : 15:04:30

We, dummies, are incorrigible.

X002548
Not Just a Number

15586 Posts

Posted - 2003-09-09 : 15:44:31

OK...but........

What were you talking about?

Brett

8-)

SELECT @@POST=NewId()

That's correct! It's an AlphaNumeric!

Stoad
Freaky Yak Linguist

1983 Posts

Posted - 2003-09-09 : 16:28:00

I meant KTL_DK created two tw... oh, I'm summoned for...

KTL_DK
Starting Member

15 Posts

Posted - 2003-09-10 : 06:21:48

Hello,
the dts objective in this case is to run in a sql job once a wheek, however i've already done the v b script task and it's working .
There is only one problem, when i run the script inside the dts , it works, but when i run the dts for example in a job it doesn't work.
The run dts interface(the weels moving) stay's working in a endless way. Also when i run the job it starts running but without finishing. So i think the problem is in the security.
Paul

Amethystium
Aged Yak Warrior

701 Posts

Posted - 2003-09-10 : 08:03:14

quote:
Originally posted by X002548
I'll be damned if I undestand...

What do you mean?

Mirror?

typing fuss?

Life is versatile enough?

Huh?

HELP!

Stoad is cool, and his writing style makes him sound even cooler. (you only have to understand the gist of what he's saying anyway)

Make love not war!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources