Sounds very insecure to me. I could see a use for backend xml type stuff,
but one would have to be super lazy. I think this would be more for the
dba's who are not familiar with CF or it's like.
jon
----- Original Message -----
From: "David Shadovitz" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, November 12, 2000 2:48 AM
Subject: OT: SQL Server 2k - query from URL
> 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]
------------------------------------------------------------------------------------------------
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]
