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] ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12h2n61iv/M=362131.6882499.7825260.1510227/D=groups/S=1705006764:TM/Y=YAHOO/EXP=1122644655/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org ">Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life - brought to you by One Economy</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/
