I assume that you meant something like
<![CDATA[
SELECT *
FROM my_table
WHERE my_column = #value# AND
my_date <= GETDATE()
]]>
and
SELECT *
FROM my_table
WHERE my_column = #value# AND
my_date <![CDATA[<=]]> GETDATE()
I would choose the first example for readability. I don't think that
there are any performance implications.
Nathan
On Dec 9, 2005, at 12:34 PM, ooper wrote:
Just wondering if it matters how much of the query you include
within the CDATA element?
Is one of these preferable over the other? Why?
SELECT *
FROM my_table
WHERE my_column = #value# AND
my_date <= GETDATE()
]]>
SELECT *
FROM my_table
WHERE my_column = #value# AND
my_date <= GETDATE()
]]>
TIA,
Brian Barnett
Broadband interface (RIA) + mail box saftey = http://
iBatis_for_Java_Users_List.roomity.com
*Your* clubs, no sign up to read, ad supported; try broadband
internet.
