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
