dbTalk Databases Forums  

Generate URL based on query, then access URL

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


Discuss Generate URL based on query, then access URL in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Leighton.d
 
Posts: n/a

Default Generate URL based on query, then access URL - 04-20-2005 , 01:29 PM






We have a software application that if you access a URL that inlcudes a
filename and a list of phone numbers, it will call each of the phone numbers
and play the pre-recorded message contained in the filename.

I think I can generate the URL string fairly easy, but how do I essentially
open a web browser and pass it the URL?

Thanks,

Doug

Reply With Quote
  #2  
Old   
Dave
 
Posts: n/a

Default RE: Generate URL based on query, then access URL - 04-20-2005 , 03:56 PM






Try this:

'************************************************* ***********************
' Visual Basic ActiveX Script
'************************************************* ***********************
Option Explicit

Function Main()

Dim mInternet, WebAddress

WebAddress = "http://myaddress.com?variables"

mInternet.open "GET" , WebAddress, false
mInternet.send
mFiletxt= mInternet.Responsetext
set mInternet = nothing

Main = DTSTaskExecResult_Success
End Function

"Leighton.d" wrote:

Quote:
We have a software application that if you access a URL that inlcudes a
filename and a list of phone numbers, it will call each of the phone numbers
and play the pre-recorded message contained in the filename.

I think I can generate the URL string fairly easy, but how do I essentially
open a web browser and pass it the URL?

Thanks,

Doug

Reply With Quote
  #3  
Old   
Leighton.d
 
Posts: n/a

Default RE: Generate URL based on query, then access URL - 05-02-2005 , 08:06 AM



Hi Dave,

I tried your solution below, but the procedure fails with an "undefined
function" error message. I'm guessing it might be because of the
"minternet.open" statement. "minternet" doesn't appear to be a valid object.

Any ideas? Thanks again, Doug

"Dave" wrote:

Quote:
Try this:

'************************************************* ***********************
' Visual Basic ActiveX Script
'************************************************* ***********************
Option Explicit

Function Main()

Dim mInternet, WebAddress

WebAddress = "http://myaddress.com?variables"

mInternet.open "GET" , WebAddress, false
mInternet.send
mFiletxt= mInternet.Responsetext
set mInternet = nothing

Main = DTSTaskExecResult_Success
End Function

"Leighton.d" wrote:

We have a software application that if you access a URL that inlcudes a
filename and a list of phone numbers, it will call each of the phone numbers
and play the pre-recorded message contained in the filename.

I think I can generate the URL string fairly easy, but how do I essentially
open a web browser and pass it the URL?

Thanks,

Doug

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.