This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
Hi, I need to create a query string based on these conditions. I'd like my query string to be as follows in SQL++: SELECT * FROM TABLENAME WHERE TABLECOLUMN LIKE '%abc%'; I'd like to compare the user-entered column value and match it in the table rows. If I try to use this in a PreparedStatement in a similar way, like : SELECT * FROM TABLENAME WHERE TABLECOLUMN LIKE '%?%' I get SQL errors saying that the string has not been terminated correctly, or it does not give me rows in the table, which do match and exist. I can achieve this by using Statements and using '%' + column_value, but is there a way to do this with PreparedStatements ? Any response will be very helpful. Thanks.