Re: [JBoss-user] Finder generating wrong SQL statement in Jboss-3.2.1

2003-07-01 Thread Janardhan Burugupalli
Hi All, I have a finder defined in the jwas.xml like this below finder namefindAllOrdered/name query/ orderCREATINGTIME DESC/order /finder i dont have any query because i want all results only in the Creating time desc format but jboss is generating the following

RE: [JBoss-user] Finder generating wrong SQL statement in Jboss-3.2.1

2003-07-01 Thread Danny . Yates
10:04 To: [EMAIL PROTECTED] Subject: Re: [JBoss-user] Finder generating wrong SQL statement in Jboss-3.2.1 Hi All, I have a finder defined in the jwas.xml like this below finder namefindAllOrdered/name query/ orderCREATINGTIME DESC/order /finder i dont have

Re: [JBoss-user] Finder generating wrong SQL statement in Jboss-3.2.1

2003-07-01 Thread Janardhan Burugupalli
[EMAIL PROTECTED] wrote: I'm guessing here, but: 1) Can you remove the query/ element? Does this stop JBoss from generating the where clause? 2) Can you set the query to something like 1=1? Dan. Hi Dan, I made it so that i was equating a filed with thee same like finder