Re: migrations and escaping single quotes

From: Chuck Hill (chil..lobal-village.net)
Date: Mon Jun 29 2009 - 22:15:18 EDT

  • Next message: Kieran Kelleher: "Re: Eclipse 3.5 slow?"

    Try doubling them: Men''s

    On Jun 29, 2009, at 6:57 PM, Theodore Petrosky wrote:

    >
    > I am using migrations to create my database structure. I am also
    > populating some of the tables.
    >
    > ERXJDBCUtilities.executeUpdate(database.adaptorChannel(), "INSERT
    > INTO t_sub_category " + "(c_sub_cat_title, c_contact_category_id)
    > VALUES ('Watches (Men’s & Women’s)', 19)");
    >
    >
    > Using the above to insert data, how do I escape the single quotes?
    >
    > Ted
    >
    >
    >
    > 

    -- 
Chuck Hill             Senior Consultant / VP Development

    Practical WebObjects - for developers who want to increase their  
overall knowledge of WebObjects or who are trying to solve specific  
problems.
http://www.global-village.net/products/practical_webobjects

    This archive was generated by hypermail 2.0.0 : Mon Jun 29 2009 - 22:16:38 EDT