Oops. sorry. there should be no double quote before where.
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: Artigas, Ricardo Y. [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, October 23, 2001 2:28 PM
> To: [EMAIL PROTECTED]
> Subject: Re: How to put getRemoteAddr() into SQL server table?
>
> 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
===========================================================================
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
