When you say it's not working but not giving an error, what's happening? Is the data just not being updated? If that's the case, do a response.write of your sql variable before it's executed and copy / paste that into a new query in MS Access. Run it and it'll tell you how many records are being updated. If it says zero, then there are no records which match your where clause, so check that the values you're passing in are correct, and the values in the database are correct. Dan
________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jegatha Sent: 28 July 2005 06:03 To: Asp Subject: [AspClassicAnyQuestionIsOk] database updation hi all i am using Ms-access db,just i need to update the data .it not working as well it didn't show any error in coding also,wht to do with that my query is sql="update 3dmax set Bids= '"&bidno1&"' where ProjectNumber='"&project&"' " cn.execute sql thank u Regards, Jegatha --------------------------------- Free antispam, antivirus and 1GB to save all your messages Only in Yahoo! Mail: 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/
