Teddy
On 7/20/06, Robert Reil <[EMAIL PROTECTED]> wrote:
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
-------------------------------------------------------------
--
<cf_payne />
-------------------------------------------------------------
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 FusionLink
-------------------------------------------------------------
