Re: using sql:query on a jx page

2007-01-26 Thread Jeroen Reijn
Sven, you can change the logkit.xconf and add the set the logger for your transformer to debug. Let's say for instance that you would have the transformer defined in your sitemap like this: map:components map:transformers default=xslt map:transformer name=sql

using sql:query on a jx page

2007-01-25 Thread sven goosen
Hi, Once again on my quest to using Cocoon, i have a question. Can I use the output of a flowscript, in a page that is using the SQL transformer? So, can i put a transformer like: map:transform type=sql map:parameter name=use-connection value=ledenSysDB/ /map:transform In a match like this:

Re: using sql:query on a jx page

2007-01-25 Thread Jeroen Reijn
Hi Sven, yes this can be done! You should be able to do this by just adding the SQL transformer behind the jx generator. Like this: map:match pattern=foo.jx map:generate src=scripts/foo.jx type=jx/ map:transform type=sql map:parameter name=use-connection value=ledenSysDB/

Re: using sql:query on a jx page

2007-01-25 Thread sven goosen
Hi Jeroen, Thanks for the hint. It seems to work when i got a select query. But when I do the exact same thing, on a insert query. it doesn't seem to insert the data into the database. I don't think I need to handle an insert query different, do I? Here is the relevant sitemap: map:match

Re: using sql:query on a jx page

2007-01-25 Thread Jeroen Reijn
Hi Sven, your code seems fine and the insert should work. Did you try to look in the cocoon logs? If not, you could try to set the debug level of the sql transformer to debug. Kind regards, Jeroen Reijn sven goosen wrote: Hi Jeroen, Thanks for the hint. It seems to work when i got a

Re: using sql:query on a jx page

2007-01-25 Thread sven goosen
Hi, I can't find anything in the logs. how can i set the debug level of the transformer? Sven Jeroen Reijn schreef: Hi Sven, your code seems fine and the insert should work. Did you try to look in the cocoon logs? If not, you could try to set the debug level of the sql transformer to