Can I get some elaboration on the following thread I saw that relates explicitly to what I need done?
Im not asking for someone to do it for me. But I am asking for a format that needs to be followed to make this work. More questions at the bottom of this mail Bottom line: I looked for TOKEN in my Forta books and see no reference to it. So I don't understand this. -------------- <Start of email thread> The question was asked: ----------- Okay...In the Ablecommerce Shopping cart admin, I am in the Email section, and underneath that, I'm editing "Our Notification". Right now...our table has some variables that need to be filled out. The thing is, these variables were custom created. We added two new columns to the Products table, Vend_Name, and Vend_Number. How can we call these variables through coldfusion Methods such as $orderItem.getVendName() $orderItem.getVendNumber() so they will display on the Our Notification E-mail??? Does anyone know where these values are recognized by AbleCommerce / Coldfusion? Also, if we can figure this out, is it possible to make a coldfusion app that tests these values to see if they actually work correctly, rather than us having to wait on a customer ordering one of our products??? Any help would be appreciated. ----------------- Replied: ----------------- If these are fields that you have added to the database manually you won't be able to do something simple, like $orderItme.getVendorName() without modifying the underlying Java code. And unless you've purchased the Source Code you can't do that anyway. You can, however, use the AcbDatabase object to query the database directly. Then you could use something like this: $token.queryValue("SELECT VendorName FROM OrderItems WHERE OrderItem_ID = " & $orderItem.getID() ) I'm not sure if the syntax is correct here without trying it though. You'd have to test it out and play with it. ----------------- <End copied email thread> ----------------- What all this means is that we need to use CF code to input a variable in an HTML driven email. As stated copying the JAVA Object won't work. So we need to do it some other way. Can I get some direction where and how to implement what is being said? Im so new at this I don't understand how to set up the variable in the code. The code would be inserted into this snipit of the email format as shown on the lines with "*": ------------------------------ <tr> <td class="Products"> </td> <td class="Products"> </td> <td class="Products"> </td> * <td class="Products"> INSERT "Vend_Name" HERE!!! </td> * <td class="Products"> INSERT "Vend_Number" HERE!!! </td> <td class="Products"> $orderItem.getSKU()</td> <td class="Products"> $orderItem.getName()<br><font size=2><strong>$orderItem.getLineMessage()</strong></font></td> <td class="Products"> $orderItem.getOptionNames()</td> <td class="Products" align=right> $LocaleUtils.formatCurrency($store,$orderItem.getUnitPrice(),"<br>",tr ue)</td> <td class="Products" align=center> <div align="center">$orderItem.getQuantity()</div></td> #set ($extPrice = $VelocityUtils.multiply($orderItem.getExtPrice(),$orderItem.getQuantit y())) <td class="Products" align=right> $LocaleUtils.formatCurrency($store,$extPrice,"<br>",true)</td> </tr> -------------------------------- Robert P. Reil Managing Director, Motorcyclecarbs.com, Inc. 4292 Country Garden Walk NW Kennesaw, Ga. 30152 Office 770-974-8851 Fax 770-974-8852 www.motorcyclecarbs.com ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------