Code: Select all
#set ($discountAmt = ${token.getcnnSG().queryValue("SELECT Price FROM ...")})Custom database query in nVelocity?
-
mwolf
- Lieutenant, Jr. Grade (LT JG)
- Posts: 50
- Joined: Mon Jul 02, 2007 9:37 pm
- Location: Chicago, IL
- Contact:
Custom database query in nVelocity?
I'm trying to write a custom database query in nVelocity to output a custom value on an email template and I am having trouble figuring out how to access the database. In Ablecommerce 5.5, I was able to do the following:
Is there an equivalent method in Ablecommerce 7.x?
Re: Custom database query in nVelocity?
I don't think so you can do that with NVelocity in 7.0. You should better create a conlib control, do what ever you want to do with database in the conlib control. Finally just include that control where you want to put nvelocity code. Have a look at following topic for custom queries. http://wiki.ablecommerce.com/index.php/Custom_Queries
.com-
mwolf
- Lieutenant, Jr. Grade (LT JG)
- Posts: 50
- Joined: Mon Jul 02, 2007 9:37 pm
- Location: Chicago, IL
- Contact:
Re: Custom database query in nVelocity?
Can I include ConLib's within email templates?mazhar wrote:I don't think so you can do that with NVelocity in 7.0. You should better create a conlib control, do what ever you want to do with database in the conlib control. Finally just include that control where you want to put nvelocity code. Have a look at following topic for custom queries. http://wiki.ablecommerce.com/index.php/Custom_Queries