Can Anyone Please Give Me Some Ideas

This is a discussion on "Can Anyone Please Give Me Some Ideas" within the Classic ASP section. This forum, and the thread "Can Anyone Please Give Me Some Ideas are both part of the Program Your Website category.



Go Back   Webforumz.com > Main Forums > Program Your Website > Classic ASP

Notices


Reply
 
LinkBack Thread Tools
  #1 (permalink)  
Old Jan 24th, 2006, 17:38
New Member
Join Date: Jan 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Red face Can Anyone Please Give Me Some Ideas

I have an asp page with a table filled with data from sql server table. I want to give to the user, the ability to update the records in this page itself. for example, if user click on a cell, it should allow the user to change the content and then be able to update the sql table with these new updated values. I know there is this editable content feature to use to make a cell editable, but iam kinda stuck on how to retrive the updated values and insert/update them to the sql table.

I hope someone can help me out on this. Your help will be highly appreciated
Reply With Quote

  #2 (permalink)  
Old Jan 25th, 2006, 05:13
Highly Reputable Member
Join Date: May 2005
Location: U.K
Age: 21
Posts: 739
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to benbramz
Re: Can Anyone Please Give Me Some Ideas

Hi there!

basicly, what you wouold need is a RsObj.update command for your updated info.

however, first step would be to figure out how exactly you need to edit the data.

now im assuming some knowledge of asp? if not just say and ill jump back a step..basicly what we want to do is loop through the records and add them in a <table>, and then provide an "edit" link, so we could do somthing like;
response.write "edit.asp?recordID=" & rsobj("id")
then have a page to grab that querysting, and display the data for that into form fields. then on submitting thre form, just update the info.

another way would be to loop through the recordset, putting all infomration from all records into form boxes, using a loop again, then upon submitting the entire form, loop through and edit the information. not reccomened though, as the server load would be much higher.

what would you like to happen (in detail)?
Reply With Quote
Reply

Tags
give, ideas

Thread Tools

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Please give your suggestions Jaya Saravanan Scripts and Online Services 2 Feb 20th, 2008 07:02
Give way to Cryxellis =P Mysanctuary23 Introduce Yourself 8 Dec 5th, 2007 08:18
I am about to give up PunkManager Starting Out 6 Sep 4th, 2007 09:58
hi, please give a review sambkk Free Web Site Critique 13 Mar 15th, 2007 12:56


All times are GMT. The time now is 21:05.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0 RC8
© 2003-2008 Webforumz.com : All Rights Reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43