ASP Programming
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsProgramming Languages - MoreASP Programming

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
1200+ fellow developers rate and compare features of the top IDEs, like Visual Studio, Eclipse, RAD, Delphi and others, across 13 categories. Enjoy this FREE Download of the IDE User Satisfaction Study by Evans Data Corporation. Download Now!
  #1  
Old July 29th, 2003, 04:50 PM
Aimskee Aimskee is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jul 2003
Location: New York City
Posts: 2 Aimskee User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Saving data on Form

I want to display multiple records on a form. The user has the choice of editing 1 or more records and then saving the changes. What would be the basic code I need to save the changed records? How would I capture the individual changes? Right now the only thing that I can get to save is one record per page, not multiple records on a page, because the request.form variables come in in an array format when I put more than one record on a page.
Thanks.
New/Rusty ASP user

Reply With Quote
  #2  
Old July 29th, 2003, 07:07 PM
unatratnag unatratnag is offline
Average Intelligence
Dev Shed Novice (500 - 999 posts)
 
Join Date: Apr 2003
Location: Ohio/Chicago
Posts: 678 unatratnag User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 10 m 22 sec
Reputation Power: 6
Send a message via AIM to unatratnag
not sure how you're doing it, but generally i've seen edit one record at a time with

<a href="popup_page.asp?id=<%=RS("primarykey")%>">Edit</a>


as the edit me button.

So you want one submit button and a bunch of checkboxes for update these.... you can check to see if the checkbox is checked then (you have that checkbox be the primary key) update rows where = to that primary key.

if you have on final submit button and want it to smart detect the rows with no indications besides if it's been touched......
Do you have all your data entered into text boxes and those are all displayed accross the screen and they can update it directly that way? You could set up each row, so that onblur you add the primary key of that row to an array. and then when they submit one button you can then update the DB with the primary keys that you wrote to the array....never tried this, but it sounds like i dont' want to and would prefer to have the checkbox method....

Reply With Quote
  #3  
Old July 29th, 2003, 07:32 PM
Aimskee Aimskee is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jul 2003
Location: New York City
Posts: 2 Aimskee User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Saving more than one record on Form

I guess the checkbox idea is feasible. That means the user has to check this to show she/he edited it?
Thanks.

Reply With Quote
  #4  
Old July 29th, 2003, 07:44 PM
unatratnag unatratnag is offline
Average Intelligence
Dev Shed Novice (500 - 999 posts)
 
Join Date: Apr 2003
Location: Ohio/Chicago
Posts: 678 unatratnag User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 10 m 22 sec
Reputation Power: 6
Send a message via AIM to unatratnag
booo, now you're not being creative

fine, go the easy way, psssh

well, i assume you know client side scripting. So just add an onblur for the row and when a user updates a record pop the onblur calls your javascript to set the checkbox to checked =)

Reply With Quote
  #5  
Old July 29th, 2003, 08:13 PM
karsh44's Avatar
karsh44 karsh44 is offline
Just another guy
Dev Shed Frequenter (2500 - 2999 posts)
 
Join Date: Jun 2003
Location: Wisconsin
Posts: 2,915 karsh44 User rank is Second Lieutenant (5000 - 10000 Reputation Level)karsh44 User rank is Second Lieutenant (5000 - 10000 Reputation Level)karsh44 User rank is Second Lieutenant (5000 - 10000 Reputation Level)karsh44 User rank is Second Lieutenant (5000 - 10000 Reputation Level)karsh44 User rank is Second Lieutenant (5000 - 10000 Reputation Level)karsh44 User rank is Second Lieutenant (5000 - 10000 Reputation Level)karsh44 User rank is Second Lieutenant (5000 - 10000 Reputation Level) 
Time spent in forums: 1 Week 6 Days 13 h 6 m 22 sec
Reputation Power: 76
You can also do this with ActiveX controls in vb, but doing it w/ scripting is probably easier.

Reply With Quote
Reply

Viewing: Dev Shed ForumsProgramming Languages - MoreASP Programming > Saving data on Form


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 

IBM developerWorks




© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway