Bugs item #619969, was opened at 2002-10-08 08: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: Open Resolution: None 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-10-31 18: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 18: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: Influence the future of Java(TM) technology. Join the Java Community Process(SM) (JCP(SM)) program now. http://ads.sourceforge.net/cgi-bin/redirect.pl?sunm0004en _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
