I have installed this package and it is working fine for fetching rows from DB with the jesper.sql:SQLXML(query) command but what is the correct syntax for updating/inserting records from xslt? I saw on http://forum.umbraco.org/yaf_postst5790_Saving-Data-To-Database-From-XSLT.aspxthat the library extension method jesper.sql:SQLExecuteScalarInt(query) is used - is this correct? My attempts at using this have been unsuccessful. Is there a list of libraryb methods contained within this package?
Saving to database with XSLT
I have installed this package and it is working fine for fetching rows from DB with the jesper.sql:SQLXML(query) command but what is the correct syntax for updating/inserting records from xslt? I saw on http://forum.umbraco.org/yaf_postst5790_Saving-Data-To-Database-From-XSLT.aspx that the library extension method jesper.sql:SQLExecuteScalarInt(query) is used - is this correct? My attempts at using this have been unsuccessful. Is there a list of libraryb methods contained within this package?
Hi Giles,
Yes it's possible. Any sql statement is passed on and executed "as is". Nothing fancy going on other than returning results as xml.
Check this posting -
http://forum.umbraco.org/yaf_postst5790_Saving-Data-To-Database-From-XSLT.aspx
To see all methods - just use the build in browser that you find in the toolbar (Insert xsl:value-of), get extensions, select the sql library.
/best
Jesper
is working on a reply...