integrate content xml and databasetable

hi,

Can any one give a sample integration of database and content xml in Livesite. the object we use is com.interwoven.livesite.external.SQL and the method we use is GetJDBCXML. But haow to integrate each column with the appearance xsl is still a mystery.

Regards
sui

Find more posts tagged with

Comments

chicka

Hi Guys,

Could you please help me on this query.. I have the same question in my mind.... I couldn't find DB integration in Livesite3.X doc.

Migrateduser

Personally I have used executeSqlQuery method from com.interwoven.livesite.external.SQL, where the resultset of the query is returned in a 'row' element, and you can write an XSL with <xsl:template match="row"> and process it.

chicka

Hi,

Thanks for your reply...
Is there any document which talks about pushing of content contributor's content to the database. I am having such kind of requirement..
your help is much appreciated.