Re: Product Name in AdminResults.inc
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 38603
interpreted = N
texte = Steve Buehler wrote:> > In WebCatalog most of our customers do NOT go off of SKU numbers. They go> by Product names. SKU == whatever you want it to be, as long as it is unique to the item.If you want to store the product name in the SKU field, there is nothingto stop you. Or, you can assign a number to each item and assign thenext available number for each new item.> Anyway, in the Admin for the store, when they view orders> it does not show the name of the product, just the SKU. We have tried to> change the Global/AdminResults.inc to show this but we can not get the> product to show. Of course, the way we are calling it, it can not find the> products.db. Can you please help with this. Below is how we changed the code:>
...HTML noise deleted... we don't care about how you layout your page.[lookup> db=admin/products.db&lookinfield=SKU&value=[url][sku][/url]&returnfield=TITLE]> There is nothing wrong with this code; I do something similar myself. All of our items are books, so the SKU is the ISBN and I retrieve the Title for display purposes. I suspect that the location of this database is not where you think it is. Take this code and put it in a file in the same directory, with a hard-coded value for SKU and seewhat shows up.HTHJohn-- John PeacockDirector of Information Research and TechnologyRowman & Littlefield Publishing Group4720 Boston WayLanham, MD 20706301-459-3366 x.5010fax 301-429-5747-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Steve Buehler wrote:> > In WebCatalog most of our customers do NOT go off of SKU numbers. They go> by Product names. SKU == whatever you want it to be, as long as it is unique to the item.If you want to store the product name in the SKU field, there is nothingto stop you. Or, you can assign a number to each item and assign thenext available number for each new item.> Anyway, in the Admin for the store, when they view orders> it does not show the name of the product, just the SKU. We have tried to> change the Global/AdminResults.inc to show this but we can not get the> product to show. Of course, the way we are calling it, it can not find the> products.db. Can you please help with this. Below is how we changed the code:> ...HTML noise deleted... we don't care about how you layout your page.[lookup> db=admin/products.db&lookinfield=SKU&value=[url][sku][/url]&returnfield=TITLE]> There is nothing wrong with this code; I do something similar myself. All of our items are books, so the SKU is the ISBN and I retrieve the Title for display purposes. I suspect that the location of this database is not where you think it is. Take this code and put it in a file in the same directory, with a hard-coded value for SKU and seewhat shows up.HTHJohn-- John PeacockDirector of Information Research and TechnologyRowman & Littlefield Publishing Group4720 Boston WayLanham, MD 20706301-459-3366 x.5010fax 301-429-5747-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
John Peacock
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
PHP Live (2005)
Quantity (1998)
WebCatalog 3.0.4 alias crash bug? (2000)
WebCatalog NT beta 18 problem (1997)
WebCatalog Beta Documentation (1997)
Linux ODBC and the ODBC Bridge (2000)
Database causes out of memory error (2000)
ShowNext (1997)
[WebDNA] File Include HTM (2008)
HELP WITH DATES (1997)
WCS Newbie question (1997)
WebCat2 - storing unformatted date data? (1997)
[subtotal] and others (1997)
Is this possible, WebCat2.0 and checkboxes (1997)
Webcatalog, Webstar and Crasharama (1999)
Search in 2 or more catalogs (1997)
WEBCAT HIERARCHY (1999)
[Semi-OT] Eaaaaaasy OSX FTP (2003)
Question about replacing words (1998)
Lock out multiple users with same password? (1999)