I think I will describe the problem in detail. I using Container-Managed Persistence (CMP) beans in J2EE RI 1.3. I will like to specify the SQL for one of the finder methods to be:
SELECT * FROM table1 WHERE ( ? ) This is to faciliate me manipulating the WHERE clause b4 sending it as a string into the finder method. I THINK the J2EE sever will insert the string (say table1.field1=0) into the SQL as SELECT * FROM table1 WHERE ( "table1.field1=0" ) and NOT SELECT * FROM table1 WHERE ( table1.field1=0 ) The latter is the correct syntax, note that there's NO SINGEL/DOUBLE QUOTES on the string and this is what I want to achieve. I'm wondering if there's a function that allows you to do something like this: SELECT * FROM table1 WHERE ( function("table1.field1=0") ) will give you SELECT * FROM table1 WHERE ( table1.field1=0 ) TIA Ho Keat __________________________________________________ Do You Yahoo!? Yahoo! Kickin' Party - Win a 5-star getaway to exotic Bali! http://kickin.yahoo.com.sg --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php