ASP script for limited SQL table editing?

[gbaughma]

I'm looking for a simple script that will allow selected users to edit selected fields in a SQL database.

Here's the scenario:

I have an SQL server with an "Employees" table.

The table includes stuff like employee last name, first name, hire date, active (whether they're currently employed or not), keytag, etc.

I want to give my security supervisor limited ability (through a web page in ASP) to edit some fields.

For example, he should be able to change the active status (check or uncheck) and clear the keytag fields, but not add records, delete records, or view/edit any of the other fields.

Anyone know of a simple ASP script out there so I can give him this access? I could write one, I suppose, but it would be nice to find one canned (and free) ;-)



Just my 2¢
-Cole's Law: Shredded cabbage

--Greg

http://parallel.tzo.com

 

[Chopstik]

Greg,

Maybe I'm making this much simpler than it is, but just create a simple page that calls to your DB to get the data that can be edited, put that data into a couple of textboxes that can be edited, and a submit button that will submit the page/data to another page that will then run a query (or call a stored procedure) to update the data in your DB. Or am I missing something...?

------------------------------------------------------------------------------------------------------------------------
"Men occasionally stumble over the truth, but most of them pick themselves up and hurry off as if nothing ever happened."
- Winston Churchill

 

[gbaughma]

No... that's the general idea... I was just hoping for something a little prettier. ;-)



Just my 2¢
-Cole's Law: Shredded cabbage

--Greg

http://parallel.tzo.com

 

[Chopstik]

Sorry, but I'm not that pretty.

------------------------------------------------------------------------------------------------------------------------
"Men occasionally stumble over the truth, but most of them pick themselves up and hurry off as if nothing ever happened."
- Winston Churchill

 

[gmmastros]

I was gonna say the same thing....



-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[gbaughma]

Oi.



<Sigh> I guess I'll get to writing a script.



Just my 2¢
-Cole's Law: Shredded cabbage

--Greg

http://parallel.tzo.com

 

[Chopstik]

<Han Solo to Chewbacca on Hoth while Luke is recovering> Laugh it up, Fuzzball </Han Solo>



------------------------------------------------------------------------------------------------------------------------
"Men occasionally stumble over the truth, but most of them pick themselves up and hurry off as if nothing ever happened."
- Winston Churchill

 

[gbaughma]

<looks at my balding head>

Fuzzball? Pfft. I'd be HAPPY with being fuzzy!

I figured it out though....

For as long as I can remember, I've brushed my hair straight back.

I've pulled it off of my forehead, and dropped it onto my back.



Just my 2¢
-Cole's Law: Shredded cabbage

--Greg

http://parallel.tzo.com

 

[gbaughma]

Resolution:

I ended up using UTE (Universal asp Table Editor), linking the table with only the fields I needed, adding some login security to it, and voila! All done.



Just my 2¢
-Cole's Law: Shredded cabbage

--Greg

http://parallel.tzo.com

 

[Chopstik]

I'd never heard of it so went looking for it via Google. The first result was this:

http://www.codeproject.com/asp/ute.asp

It should show with an error message indicating that Buffering cannot be turned off once it is already turned on... Somehow, I'm sure that could be easily misinterpreted into something much worse...

------------------------------------------------------------------------------------------------------------------------
"Men occasionally stumble over the truth, but most of them pick themselves up and hurry off as if nothing ever happened."
- Winston Churchill

 

[gbaughma]

That's the program... but CodeProject has been down all day.

It's also available at:

http://sourceforge.net/projects/ute-asp/

Just my 2¢
-Cole's Law: Shredded cabbage

--Greg

http://parallel.tzo.com