- 1 Manipulating Azure Storage Accounts Using Storage PowerShell cmdlets
- 2 Vapor IO Brings OpenDCRE to General Availability
- 3 VMware Takes the Wraps Off vRealize Automation and vRealize Business
- 4 Microsoft Previews Hyper-V Containers for Windows Server 2016
- 5 Mirantis Led FUEL Project Gets Installed Under OpenStack Big Tent
Querying a Database
I think this has been covered about a godzillion times but I want to show ASP newbies a clear and easy method to pull data from a database and place it in a webpage.
I think this has been covered about a godzillion times
but I want to show ASP newbies a clear and easy method to
pull data from a database and place it in a webpage.
There are a few objects you can use to get the data from a database, but I prefer the connection object because it takes about 3 lines of code to use a SQL statement.
(Before writing the script, make sure you have a DSN to the DB setup correctly.)
First thing we do is open an active connection to the DB using the connection object like so:
Set oConn = Server.CreateObject("ADODB.Connection")
We can then build the SQL statement using:
sql = "SELECT UserName FROM Accounts Where UserName='madcow'"
We then set the RS object using this line of code:
Set RS = oConn.Execute(sql)
All done! Now that we have the data, we can place it
in our HTML like this:
Keep in mind that this is a very simple example and can be expanded on greatly. If you have any comments or questions feel free to drop me a line.