Why is there a space in uname?
where uname = ' " + uname + " ' ";
this will result to a "where uname = ' my_uname ';
depending on the settings of your database,
"where uname = ' my_uname ';
is different compared to:
"where uname = 'my_uname';
[without leading and trailing spaces]
:~)
Ricky Y. Artigas
Analyst/Programmer /
Database Administrator
Information Technology Division
Easycall Communications Phils., Inc.
> -------------------------------
> IMPORTANT NOTICE:
> This message (and any attachment hereto) may contain privileged and/or
> confidential information specific to EasyCall. If you are not the intended
> addressee indicated in this message, you may not copy or disseminate this
> message (or any attachment hereto) to anyone. Instead, please destroy this
> message (and any attachment hereto), and kindly notify the sender by reply
> email. Any information in this message (and any attachment thereto) that
> do not relate to the official business of EasyCall shall be understood as
> neither given nor endorsed by the company.
>
>
> -----Original Message-----
> From: Miao, Franco CAWS:EX [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, October 23, 2001 2:23 PM
> 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
