Dbsource

What is Dbsource?

dbsource is a connection between CMS and database. In a simple words no matter what kind of database you use (SQL, MySQl, Oracle, access,…) you can call similar results from database on CMS. To reach this, You just need to create Store-procedures with execute permission in your demanded database.


Name

Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.

Type

Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.

source

Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.

more..
Syntax
< basis core="dbsource" name=["name"] source= ["source name"] mid= [" "] usedforid= "[##cms.query.id##]" lid= ["your language number"] >
< member type=["your command name"] name=["name"] Typeid=[""] name=["name"] propertyid=[""] catid=[""] parentid=[""] > < /member>
</basis >
Example
< basis core="dbsource" name="product" source= "basiscore" name="store" mid="2" usedforid="[##cms.query.id##]" >
< member type="view" name="product3" preview="true" > < /member >
< /basis >