Re: [JBoss-dev] SQL function mapping

2001-08-22 Thread Dain Sundstrom
Thanks, will commit change as soon as sourcefouge cvs is back on line. -dain - Original Message - From: "Marco Ladermann" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 21, 2001 3:33 AM Subject: Re: [JBoss-dev] SQL function mapping > On Mond

Re: [JBoss-dev] SQL function mapping

2001-08-21 Thread Dave Smith
Nope your right. When I first wrote the function I did not have the + ?3 at the end so it worked fine ... Marco Ladermann wrote: > On Monday, 20. August 2001 19:20, Dain Sundstrom wrote: > >>Thanks, checked it in. >> >>-dain >> >> > > > >>>It is simply two functions >>> >>>position(?2 in sub

Re: [JBoss-dev] SQL function mapping

2001-08-21 Thread Marco Ladermann
On Monday, 20. August 2001 19:20, Dain Sundstrom wrote: > Thanks, checked it in. > > -dain > > > It is simply two functions > > > > position(?2 in substring(?1 from ?3))+?3 > > Sorry for complaining so late, but it is not as simple as this. position( 'findme' , 'wheretolookfor', 3) should be

Re: [JBoss-dev] SQL function mapping

2001-08-20 Thread Dain Sundstrom
Thanks, checked it in. -dain - Original Message - From: "Dave Smith" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, August 20, 2001 6:49 AM Subject: Re: [JBoss-dev] SQL function mapping > > > Dain > > I added the function mapping code to

Re: [JBoss-dev] SQL function mapping

2001-08-20 Thread Dain Sundstrom
AIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, August 20, 2001 9:12 AM Subject: RE: [JBoss-dev] SQL function mapping > Dain, > > Can we expand this to CMP 1.x and for "select-for-update"? > > Thanks, > > Bill > > > -Original Message

RE: [JBoss-dev] SQL function mapping

2001-08-20 Thread Bill Burke
Dain, Can we expand this to CMP 1.x and for "select-for-update"? Thanks, Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Dave > Smith > Sent: Monday, August 20, 2001 7:49 AM > To: [EMAIL PROTECTED] > Subjec

Re: [JBoss-dev] SQL function mapping

2001-08-20 Thread Dave Smith
Dain > I added the function mapping code to the EJB-QL to SQL translation engine. I > added mappings for MS SQLServer, Oracle, MySQL and PostgreSQL to the > standard jboss cmp xmp file. > > Notes: > - These mappings are completely based on info from the 'SQL in a Nutshell' > book, so they may n