Try in below fashion: String updateip ="Update tbluser set incomingip= ? where uname = '" + uname + "' ";
PreparedStatement pstmt = conn.prepareStatement(updateip); pstmt.setString(column_index_of_incomingip, "10.10.10.10"); pstmt.executeUpdate(); -Seshubaba -----Original Message----- From: Miao, Franco CAWS:EX [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 23, 2001 11:53 AM To: [EMAIL PROTECTED] Subject: Re: How to put getRemoteAddr() into SQL server table? I tried your way already, no error came up, but no update action too, still remain to the old value, but I can use this way to update record in SQL server Query Analyzer without any problem at all. Thanks! Franco -----Original Message----- From: Seshubaba [mailto:[EMAIL PROTECTED]] Sent: Monday, October 22, 2001 11:24 PM To: [EMAIL PROTECTED] Subject: Re: How to put getRemoteAddr() into SQL server table? Importance: High Try in this fashion: String updateip ="Update tbluser set incomingip='10.10.10.10' where uname = ' " + uname + " ' "; -Seshubaba -----Original Message----- From: Miao, Franco CAWS:EX [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 23, 2001 11:45 AM To: [EMAIL PROTECTED] Subject: Re: How to put getRemoteAddr() into SQL server table? This time I even hardcode a IP adress in the source code see if the SQL statement can update to 10.10.10.10, but get this error. -------------------------------------------------------------- Invalid character in number. String updateip ="Update tbluser set incomingip='" +10.10.10.10+ "' where uname = ' " + uname + " ' "; Franco -----Original Message----- From: I Wayan Saryada [mailto:[EMAIL PROTECTED]] Sent: Monday, October 22, 2001 8:46 PM To: [EMAIL PROTECTED] Subject: Re: How to put getRemoteAddr() into SQL server table? Hi... The your sql statements should be like this, String updateip ="Update tbluser set incomingip= '" + request.getRemoteAddr() + "' where uname ='" + uname + "'"; regards, Wayan -----Original Message----- From: Miao, Franco CAWS:EX [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 23, 2001 11:34 AM To: [EMAIL PROTECTED] Subject: Re: How to put getRemoteAddr() into SQL server table? Source code: --------------------------------------------- String updateip ="Update tbluser set incomingip= 'request.getRemoteAddr()' where uname ='" + uname + "'"; ----------------------------------------------- No erro come up, but it didn't put remote Ip address into SQL server's table, value is "null", if I change to " '+request.getRemoteAddr()+' ", you will see '+request.getRemoteAddr()+' as the value in table. Don't know why, looks like request.getRemoteAddr() doesn't function in SQL statement. Pls advise, thanks! ***Bob Vu no need to answer, I knew you don't have the answer! You answer is ask people read the book. Franco =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
