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 nothing to stop you. Or, you can assign a number to each item and assign the next 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 see what shows up.HTHJohn-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 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:

    
  1. Re: Product Name in AdminResults.inc (John Peacock 2001)
  2. Product Name in AdminResults.inc (Steve Buehler 2001)
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 nothing to stop you. Or, you can assign a number to each item and assign the next 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 see what shows up.HTHJohn-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 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)