Hi, My TL gave me this task. If any one can able to give suggestion. plz provide asap. * We have recordset. i have one filedname called t_id(int) and cval(data type as BIT) in my emp table. I entered more datas using Enterprise manager. Also i inserted more records from ASP file(test.asp). In test.asp file, if i check the checkbox then the value must be inserted as 1 for "cval" field in my recordset(emp table). ..I had done it. No probs * But i have another page called pending.asp. it contains a drop downlist.If we select any category , it shows the records corresponding to the database in pending.asp. Here i have 1 checkbox and some records. My task---> * I have to disable to all checkbox, if my emp table field contain value as "1". that all. * In my pending table. we use many tables. Also we used "emp" table.. the below coding wat i wrote in my file...... <% if Rss.Fields("cval").Value="1" then end if %> **** the problem is ...... Rss.Fields("cval").Value="1" ----> its presents at my "emp" table. we use emp table at my mail.asp file. * the below code presents at pending .asp file------> <input type="checkbox" name="TransNo" value="<%=transid%>" id="Chk<%=transid%>" disabled> if i give like this the error is coming like thisssssss "item cannot found"..The error is 100% correcttttttt Becoz if i give like this then it search the field name(cval) at Transaction table not in my emp table. 99% we use Transaction table in my pending.asp, also i have emp table.. ************** Conclusion is----> * How to disable the checkbox in our parent form corresponding to the value present in database . Disable the checkbox in pending page if we have value as "1" in my emp table......NOT IN transaction table......... HELP ME IF U CAN
Hi Kindly post the SQL also. More over your post is more into confusing than a clear picture. We need SQL and also a little bit of code so that we can checkout the code and say you. Use tag code to enclose the ASP , SQL codes this will save the format of the code else you will see errors. Thanks
Yes, it seems like it could be a simple fix, but your entire post is generally confusing and not clear enough. Do as bepenfriends said as a start please.