Copied to clipboard

Flag this post as spam?

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


  • TomK 7 posts 37 karma points
    Aug 10, 2009 @ 16:41
    TomK
    0

    xslt search in an sql query result

    is it possible to use "xslt search" for searching in an sql query resultset?

    For example in a Database-Telephonelist

  • Dirk De Grave 4541 posts 6021 karma points MVP 3x admin c-trib
    Aug 10, 2009 @ 17:08
    Dirk De Grave
    0

    It's probably doable if you'd convert the sql query resultset to a XPathNodeIterator (for use in xslt) and tweak xslt search a bit to work with this resultset.

    Altho, I'd also look into full-text search capabilities of sql server and query data directly from db and present the results using some user control.

     

    Just my 2 cents.

     

    Cheers,

    /Dirk

  • Douglas Robar 3570 posts 4711 karma points MVP ∞ admin c-trib
    Aug 10, 2009 @ 22:38
    Douglas Robar
    1

    XSLTsearch is geared for searching umbraco content nodes. You can certainly modify it for other uses (make an xslt extension to query the database and then integrate that into XSLTsearch's code) but in the scenario you describe I'd recommend you look at other tools, probably a Lucene-based search solution. There are a couple of them in the 'projects' area.

    cheers,
    doug.

  • TomK 7 posts 37 karma points
    Aug 12, 2009 @ 10:32
    TomK
    0

    thanks for supporting me. i think the best way is the Lucene-based solution

    cheers,

    thomas

Please Sign in or register to post replies

Write your reply to:

Draft