I just read an article in the December 2000 issue of WebTechniques, "Plug
in to SQL Server 2k," that says you can make a database query from a URL.
"One of the cool features of SQL Server 2000 is that you can query the
database through a web connection. That is, you can create an
association within your web server that allows you to interact with SQL
Servers. Start by making a new virtual directory within your web server
and associate that directory with the physical database. You can do this
by using the IIS Virtual Directory Manager for SQL, or programatically
using the SQL Server Object Model. Once you've created the associations,
you can pass a SQL query directly in a URL and retrieve data through a
web connection. For example, I can use the following URL to retrieve all
records from the invoice table:
www.beyondhtml.com/db?sql=SELECT+*+FROM+invoice
You can enter this URL in the location bar, but you're more likely to
enter the query in a form and have the form's action page construct the
URL and redirect to it.
The article goes on to discuss how you can retrieve the results as XML
data. You can also execute stored procedures this way.
I don't use SQL Server, but this sounds interesting.
-David
________________________________________________________________
YOU'RE PAYING TOO MUCH FOR THE INTERNET!
Juno now offers FREE Internet Access!
Try it today - there's no risk! For your FREE software, visit:
http://dl.www.juno.com/get/tagj.
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
