-
blater committed patchset 46 of module AJAXToaster to the AjaxToaster CVS repository, changing 1 files.
2008-06-17 16:10:49 UTC in AjaxToaster
-
blater committed patchset 44 of module AJAXToaster to the AjaxToaster CVS repository, changing 1 files.
2008-06-17 15:52:55 UTC in AjaxToaster
-
blater committed patchset 43 of module AJAXToaster to the AjaxToaster CVS repository, changing 1 files.
2008-06-17 14:06:14 UTC in AjaxToaster
-
The fix works fine.
But... have just tried a select using the SQL-Server "cast" statement:
select 'rtsk/'+cast(r.empid as varchar) as taskCode
into xml:{result.tasklist.taskCode}
Unfortunately it bombs with SEVERE: Exception parsing the xmlselect
java.lang.NullPointerException
at com.inverse2.parser.SQLSelect.makeSQL(XMLSelect.java:3254)
2008-01-22 15:51:40 UTC in XMLToaster
-
Will be fixed in 1.0.7 release on 2008-01-23.
...saved the world *again* !
2008-01-22 15:18:08 UTC in XMLToaster
-
When I said "This is valid mysql syntax", hopefully you did not take it literally.
Of course I meant it as a metaphore for sql-server.
Also number 2) may be because of the bug where the LEFT function is not recognised because the parser is getting confused with the LEFT keyword from "LEFT JOIN"...
2008-01-21 14:43:20 UTC in XMLToaster
-
1) "select top n" syntax not supported. I get a syntax error when using "select top 100 x from y". This is valid mysql syntax but the xmltoaster sql parser does not recognise it.
2) Expressions not recognised in "LIKE" clause of a select query.
Eg "select x from y where y.col LIKE LEFT(${param},1)"
You should be able to use "LIKE ".
2008-01-13 19:04:29 UTC in XMLToaster
-
Calling a column name "current" results in a parser error com.inverse2.ParseException, Encountered "current" at line x, column y
The SQL was....
Select id into xml:{menu.recipe.id},
current into xml:{menu.recipe.current}
from recipe
order by recipe_id newValue throwNew xml:{menu.recipe}.
2007-10-23 17:22:37 UTC in XMLToaster
-
Escaping column names in Mysql with "`" (grave accent, ascii 96) does not work with the toaster.
The parser gives an exception "Lexical error at lin 8, column 5. Encountered "`" (96)after : ""
com.inverse2.parser.XMLSelectTokenManager.getNextToken(XMLSelectTokenManager.java 2320)
See SQLPrimaryExpression in XMLSelect.java 1310.
2007-10-23 17:18:48 UTC in XMLToaster
-
Investigating. May add to feature list for 2.0.
2007-10-23 17:09:39 UTC in XMLToaster
