Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Giles Dermody 14 posts 35 karma points
    Jun 16, 2010 @ 22:22
    Giles Dermody
    0

    Saving to database with XSLT

    SQL for XSLT Support

    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?  

    Copy Link
  • Jesper Ordrup 1019 posts 1528 karma points MVP
    Jun 21, 2010 @ 14:14
    Jesper Ordrup
    0

    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

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft