Robert, You have to take this slow, take one issue
at a time. But yes you would modify the CF code that
is sending the notification by adding a cfquery that would pull the needed part
number from the necessary tables. No I am not implying that you need to edit
any JAVA source. This message clears up more what you are
trying to do and I think it will work as described above. But you do need
to read those customization docs so that you are familiar with the repercussions
of your actions in the code and it should explain why some things don’t
work as expected. Cody From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Robert
Reil Why am I getting the data out?
This document is called “OUR NOTIFICATION” and is an email sent to
us
from the cart to alert us of a customers order.
I am trying to set up a rudimentary purchasing system.
As it is now I have to use the Name and with knowledge know who sells it to
look up the vendor part number.
I recently used Access to resolve the SKU which is printed on this notification
to find the Part Number.
But it makes so much more sence to just have Able Commerce give it to me.
OK, so <cfquery> is the tag to get
things started.
Able Commerce Customization Docs...
It would seem that you are implying what would require editing the JAVA source
code which would need a $1000 investment.
Well you know the answer to that one! Lol.
This is also a temporary fix as the completion of the many:one:many
relationship
that I am working on will be the permanent fix for this need as a
separate
purchasing module would be developed to manage this.
But for now, these 2 simple lines of code would save me 90 seconds per item
sold. Robert P. Reil Managing Director, Motorcyclecarbs.com,
Inc. 4292 Office 770-974-8851 Fax 770-974-8852 From: Cody Wehunt
[mailto: Robert, You would write a select query using
<cfquery> to get the data from that table. But why are you getting
the data out? To display or to use in another manner? When you say “enter this data into
there”, if you are wanting to insert data into this table then you would
write and insert query using <cfquery>. Also, you will need to check the AbleCommerce
Customization Documentation, because if memory serves me correctly some changes
directly to the database will not be immediately visible on product pages, you
have to run a routine first. Cody From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Well AbleCommerce come to find out is a
JAVA engine with a GUI wrapped around it. In this case CF. But what would I use to go get data from a
table The table is PRODUCTS.VEND_NUMBER etc. Sorry for this basic question but I guess
I have to start somewhere. This is officially my first problem to
solve. Can I have some guidance to how to enter
this data into there? Robert P. Reil Managing Director, Motorcyclecarbs.com,
Inc. 4292 Office 770-974-8851 Fax 770-974-8852 From: Teddy Payne
[mailto:[EMAIL PROTECTED] Well, the reason being is
that the code that is being executed is not coldfusion. =)
ColdFusion uses the "#" symbol and not the "$"
symbol. From your example it looks like a perl script to me. PHP
uses the "$" symbol, but it is usually surrounded by <%
%>. The typical extension to a perl file is .pl. On 7/20/06, Can I get some
elaboration on the following thread I saw that relates
------------------------------------------------------------- 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 ------------------------------------------------------------- ------------------------------------------------------------- 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 ------------------------------------------------------------- |
- [ACFUG Discuss] $token.queryVaule? Robert Reil
- Re: [ACFUG Discuss] $token.queryVaule? Teddy Payne
- RE: [ACFUG Discuss] $token.queryVaule? Robert Reil
- RE: [ACFUG Discuss] $token.queryVaule? Cody Wehunt
- RE: [ACFUG Discuss] $token.queryVaule? Robert Reil
- RE: [ACFUG Discuss] $token.queryVaule? Cody Wehunt