Go4Expert

Go4Expert (http://www.go4expert.com/)
-   ASP (http://www.go4expert.com/forums/asp/)
-   -   update mutliple record by selecting checkbox in asp with sql (http://www.go4expert.com/forums/update-mutliple-record-selecting-t7743/)

aspnew 7Dec2007 16:52

update mutliple record by selecting checkbox in asp with sql
 
Hi, i m new to asp and i want to update records by selecting checkbox. I have retrieved records in asp form from database and each record has a checkbox along with it. I have a field in database as docrecieved. I want to update this field as yes when checkboxes is selected and update button is submitted in asp , can any one help me how to do it

pradeep 7Dec2007 17:47

Re: update mutliple record by selecting checkbox in asp with sql
 
set some unique id as the values to the checkboxes, if a checkbox is checked on then the value is posted, so ,perform the action on the values!

aspnew 3Jan2008 14:40

Re: update mutliple record by selecting checkbox in asp with sql
 
Hi pradeep,

thanks for ur guidence , i was able to make it work.
I have a another query..... I have fields in my sql table like docrecieved and doc_date..
In my asp form i have given 2 radio button for docrecieved as yes and no, now what i want is when i select yes as docrecieved in the asp form then doc_date field in sql should show today's date by default and when no radio button is selected for docrecieved then doc_date should show null in the table(it should not display any date). But i m not able to do it, can u plz guide me how to do it


All times are GMT +5.5. The time now is 14:40.