Does the code enter the if statement? Put a response.write in there to make sure. If it does, then do what I suggested in my previous reply. If it doesn't, response.write out rs(0) and the project variable and see what values they hold - they probably don't match (remember that string comparisons in VBScript are case-sensitive). Dan
________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jegatha Sent: 28 July 2005 09:25 To: Asp Subject: [AspClassicAnyQuestionIsOk] update the following code doesn't work and no error messages,y is it so? while not rs.eof if(rs(0)=project) then sql="update 3dmax set Bids= "&bidno1&" where ProjectName='"&projectname&"' " cn.execute sql end if response.write hai rs.movenext wend can anyone help in this thankx in adv Jegatha --------------------------------- Too much spam in your inbox? Yahoo! Mail gives you the best spam protection for FREE! http://in.mail.yahoo.com [Non-text portions of this message have been removed] ________________________________ YAHOO! GROUPS LINKS * Visit your group "AspClassicAnyQuestionIsOk <http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk> " on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED] subscribe> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . ________________________________ [Non-text portions of this message have been removed] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
