Are you getting an error when you try to update? If so, post it. If not, post all of your code that's related. Like Dan said below, response.write your SQL to make sure it's correct. Also run it within your database to ensure that you can actually update your record. The syntax may be correct but it may not be affecting your desired record. Mark
Jegatha <[EMAIL PROTECTED]> wrote: my update query is not working ,i don't knw what is the problem.without update its working fine. without update query it return all the values correct can any one help with that? thanks regards, Jegatha Dan Powderhill <[EMAIL PROTECTED]> wrote: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] SPONSORED LINKS Programming languages C programming language Computer programming languages Java programming language C programming language History of computer programming language --------------------------------- YAHOO! GROUPS LINKS Visit your group "AspClassicAnyQuestionIsOk" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- --------------------------------- 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] SPONSORED LINKS Programming languages C programming language Computer programming languages Java programming language C programming language History of computer programming language --------------------------------- YAHOO! GROUPS LINKS Visit your group "AspClassicAnyQuestionIsOk" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hvplk97/M=362329.6886308.7839368.1510227/D=groups/S=1705006764:TM/Y=YAHOO/EXP=1122646118/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992 ">Fair play? Video games influencing politics. Click and talk back!</a>.</font> --------------------------------------------------------------------~-> 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/
