your answer came up same as what I tried, thaks for you so nice this time! ^+^
> 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. > Franco -----Original Message----- From: Bob V� [mailto:[EMAIL PROTECTED]] Sent: Monday, October 22, 2001 8:43 PM To: [EMAIL PROTECTED] Subject: Re: How to put getRemoteAddr() into SQL server table? Hey Miao, Now you're taking it personal! I normally don't do this, but just to annoy you, and prove that why reading the Java tutorial will help you, I will give you the answer: Try: String updateip ="Update tbluser set incomingip= '" + request.getRemoteAddr() + "' where uname = '" + uname + "'"; No need to thank me for it. ----- Original Message ----- From: "Miao, Franco CAWS:EX" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 22, 2001 8:34 PM 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
