VBscript get parameters from Sql Server 2008

Question

I need your help in the following situation:
I'm developing an app with a Sql Server 2008 db in back-end.
I want to store some URL's in the database and I put a button in my interface which should open these URL's.
I want to code the button in VBscript but I'm a newbie in this language.
I found this code CreateObject("WScript.Shell").Run "\\195.234.22\server\docs" which works fine but I want to take the links from the database, I suppose that I should set some parameters but I have no idea how to do that.
Thanks in advance!

What have you tried so far? There is a basic example of connecting to SQL Server here, although it's for an UPDATE instead of a SELECT. There are plenty of examples of connecting to SQL Server from VBScript on the web, so it might be good if you can be more precise about what your problem is. — Pondlife
– Pondlife, Commented Jan 16, 2013 at 18:02

Ian P · Accepted Answer · 2013-01-19 21:41:34Z

1

Well the way forward is to write a stored procedure to return the date you want from the database, then bind this to a grid template, you can then select the column control type as an html link. You'll get a lot of extra goodies thrown in.

answered Jan 19, 2013 at 21:41

Ian P

1,7241 gold badge10 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

VBscript get parameters from Sql Server 2008

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related