RE: SQL-Statement in

[Skidmore, Walt]

Title: RE: SQL-Statement in <jdbc-where-clause>

Actually, enclose the whole thing in CDATA...  Like this:

<jdbc-where-clause>
  <![CDATA[where beginDisplayDate <= ? and endDisplayDate >= ?]]>
</jdbc-where-clause>

That works for me...  The &lt;, &gt; stuff didn't work for me, but that does...

-----Original Message-----
From: Stephan Bauer [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 05, 2001 10:59 AM
To: [EMAIL PROTECTED]
Subject: SQL-Statement in <jdbc-where-clause>

Hi,

short question:

Is it necessary to replace >< in SQL-Statement
with &lt; and &gt; like the following:

<finder-method-jdbc-mapping>
 <jonas-method>
  <method-name>findByDate</method-name>
 </jonas-method>
 <jdbc-where-clause>
  where beginDisplayDate &lt;= ? and endDisplayDate &gt;= ?
 </jdbc-where-clause>
</finder-method-jdbc-mapping>

or how else should I formulate an sql-statement
with >= or > ?

Thanks,

Stephan
--
_________________________________________________________________________

   Stephan Bauer, Dipl. Inform. (FH)            IT-Freelancer
   Siemensstr. 46                               Bauer Internetprojects.de
   D-94315 Straubing                            Tel.:  +49 9421 9749549
   E-Mail: [EMAIL PROTECTED]    Fax:   +49 9421 9749550
   http://www.internetprojects.de               Mobil: +49 172  9795002
      
                Software-Design, Implementation & Webhosting
_________________________________________________________________________
----
To unsubscribe, send email to [EMAIL PROTECTED] and
include in the body of the message "unsubscribe jonas-users".
For general help, send email to [EMAIL PROTECTED] and
include in the body of the message "help".