Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Opticus
Starting Member
1 Post |
 Posted - 2002-07-24 : 19:28:12
|
| Hi,I was wondering if anyone had any ideas on how I might accomplish this problem. I have an intranet asp web app that manages bi-weekly work schedules for hundreds of employees. Daily work information is stored within the SQL server. Each day of the 14 day bi-weekly schedule is an individual record within the database. My problem is this:Currently when users want to make changes to an employee's schedule they are required to select the individual name, make their changes and submit. Users are then returned to a screen where their changes are made visible within an asp generated html table. This works really well if you don't have a lot of names to schedule. You can imagine the time needed to schedule 100 - 200 people. I would like to be able to eliminate the process of clicking on a name, making the changes, and submitting every time. It would be nice if I could have these changes updated within my html table and then updated to the SQL server automatically. I have figured out a way to attach my schedule changes to the innertext property of the table, but I don't know if it is possible to have the data automatically update the database when a change is made.Does anyone know if this is possible? If so how?Thanks in advanceDoug |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-07-24 : 21:30:47
|
Oh yeah, that's definitely possible, I've done it a buncha times. Here's a variation:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=12538On this earlier article:http://www.sqlteam.com/item.asp?ItemID=2652You can use either a CSV or fixed-length string to pass to SQL Server, but you can take advantage of the JavaScript join() method to build a CSV from an array very easily. Basically you read the table contents into an array (I use client-side JavaScript, but you can also use VBScript in IE) and then build delimited or fixed length strings out of the array. Once the string(s) is built, you pass it to the ASP page as a regular form control.There's some more discussion on the benefits here:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=13935Drop me an email if you need more info, it's a pretty convoluted concept at first (what? ME come up with something convoluted????)  but once you do it a few times you'll love it. |
 |
|
|
|
|
|
Can I update my SQL server db live?