Results 1 to 4 of 4
  1. #1
    pats is offline Member
    Join Date
    May 2011
    Posts
    2
    Rep Power
    0

    Default not able to update the DBtable with attribute contains + symbol

    not able to update the DBtable with attribute contains + symbol

    UPDATE InfoTable SET GID = 'demo_1111' WHERE CycleID = 'name+'
    the above query works when directly used in the server but when it is called from jave script it is not working.

    can any one let me know how to handle this?

  2. #2
    RichersooN is offline Senior Member
    Join Date
    Jan 2011
    Location
    Rizal Province, Philippiines
    Posts
    167
    Rep Power
    0

    Default

    java script?

  3. #3
    pats is offline Member
    Join Date
    May 2011
    Posts
    2
    Rep Power
    0

    Default

    java code:

    String add_sql = "UPDATE CycleInfoTable SET GroupID = "+" '"+ jLabelGroupID.getText()+"' WHERE CycleID = '"+jTableCyclesInGroupList.getValueAt(row_num, 0)+ "'";

    int rows = stmt.executeUpdate(add_sql);

    jTableCyclesInGroupList contains 'name+' due to symbol + databae is not getting updated.

  4. #4
    DarrylBurke's Avatar
    DarrylBurke is offline Member
    Join Date
    Sep 2008
    Location
    Madgaon, Goa, India
    Posts
    11,237
    Rep Power
    19

Similar Threads

  1. Undefined attribute name
    By Dieter in forum JavaServer Pages (JSP) and JSTL
    Replies: 0
    Last Post: 05-03-2010, 10:44 AM
  2. how to read an attribute of an xml tag in jsp.
    By himacherla in forum JavaServer Pages (JSP) and JSTL
    Replies: 0
    Last Post: 07-21-2009, 06:27 AM
  3. Replies: 9
    Last Post: 10-18-2008, 08:26 PM
  4. Replies: 3
    Last Post: 05-01-2008, 08:30 AM
  5. how to add an attribute with sax?
    By cecily in forum New To Java
    Replies: 3
    Last Post: 07-19-2007, 04:09 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •