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
