Bugs item #619969, was opened at 2002-10-08 01:15 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=619969&group_id=22866
Category: JBossCMP Group: v3.0 Rabbit Hole >Status: Closed >Resolution: Fixed Priority: 5 Submitted By: Vinh Nguyen (softwaremasters) Assigned to: Nobody/Anonymous (nobody) Summary: SQL Server substring syntax is wrong Initial Comment: The function mapping for substring for SQL Server (both 7 and 2K) in standardjbosscmp-jdbc.xml is currently: substring(?1 FROM ?2 FOR ?3) This is incorrect. The correct syntax for the substring function is: substring(?1, ?2, ?3) ---------------------------------------------------------------------- Comment By: Stephen Coy (scoy) Date: 2002-11-01 01:43 Message: Logged In: YES user_id=463096 This is fixed in HEAD, Branch_3_2 and Branch_3_0. It can be closed. For prosperity, the previously mentioned URL is: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=619969&; group_id=22866 ---------------------------------------------------------------------- Comment By: Stephen Coy (scoy) Date: 2002-10-31 09:48 Message: Logged In: YES user_id=463096 Jeremy Boynes just sent us a URL confirming the bug. I'll fix it and check it in in the next day or so, ---------------------------------------------------------------------- Comment By: Stephen Coy (scoy) Date: 2002-10-31 09:02 Message: Logged In: YES user_id=463096 My reference "SQL in a Nutshell" (O'Reilly) says otherwise. Can you provide some other documentary evidence of this? ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=619969&group_id=22866 ------------------------------------------------------- This sf.net email is sponsored by: See the NEW Palm Tungsten T handheld. Power & Color in a compact size! http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0001en _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
