Re: auto adding SKUs w/DB helper
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 19304
interpreted = N
texte = I there isn't an existing SKU field it should ALWAYS add the SKU value. If there is a SKU field (even if the values are empty or the same) it won't do anything. If this isn't happening let me know privately (send a database and procedure to reproduce it if possible). Thanks.John.>Yes, I've discovered this and it's exactly what I need. >Now I need to know the procedure to get the SKU's automatically into the >database. Sometimes it seems to work, but most times not. And yesterday >when it worked it put an extra tab into my db records.>>Should my DB have a SKU field and then for the records just have a tab? >Or what?>>Sue Ann>>>The new version of DBHelper will automatically add a sku field if there >>isn't one. This is only used as a record ID field so deletes and edits act >>on the correct record. When it adds the field, however, it doesn't create >>a search field for the sku.>>>>John.>>>>>Recently, while playing around with the Database helper, I got it to >>>automatically add SKU numbers to a database. But I can't seem to >>>reproduce the steps needed to do this again.>>>>>>I'm starting with an Excel spreadsheet and adding a SKU column. Then >>>going to the Database Helper and clicking on the Existing DB with Field >>>Names option. The field names show up fine, I click Create and it creates >>>my templates and separates my db header file from the db itselt. But it's >>>NOT putting in the SKU's like it did before.>>>>>>Can anyone refresh my memory on how to get the db helper to automatically >>>generate the SKU's?>>> John A. Hill, V.P. Marketing Pacific Coast SoftwareeCommerce / Web Developer Tools http://www.smithmicro.com
Associated Messages, from the most recent to the oldest:
I there isn't an existing SKU field it should ALWAYS add the SKU value. If there is a SKU field (even if the values are empty or the same) it won't do anything. If this isn't happening let me know privately (send a database and procedure to reproduce it if possible). Thanks.John.>Yes, I've discovered this and it's exactly what I need. >Now I need to know the procedure to get the SKU's automatically into the >database. Sometimes it seems to work, but most times not. And yesterday >when it worked it put an extra tab into my db records.>>Should my DB have a SKU field and then for the records just have a tab? >Or what?>>Sue Ann>>>The new version of DBHelper will automatically add a sku field if there >>isn't one. This is only used as a record ID field so deletes and edits act >>on the correct record. When it adds the field, however, it doesn't create >>a search field for the sku.>>>>John.>>>>>Recently, while playing around with the Database helper, I got it to >>>automatically add SKU numbers to a database. But I can't seem to >>>reproduce the steps needed to do this again.>>>>>>I'm starting with an Excel spreadsheet and adding a SKU column. Then >>>going to the Database Helper and clicking on the Existing DB with Field >>>Names option. The field names show up fine, I click Create and it creates >>>my templates and separates my db header file from the db itselt. But it's >>>NOT putting in the SKU's like it did before.>>>>>>Can anyone refresh my memory on how to get the db helper to automatically >>>generate the SKU's?>>> John A. Hill, V.P. Marketing Pacific Coast SoftwareeCommerce / Web Developer Tools http://www.smithmicro.com
John Hill
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:
problem with [Format Days_To_Date] (2000)
I'll Know If You Don't Read This (2006)
formula??? (2000)
emailer (1997)
sort problems....bug or brain fart? (1997)
WebCatalog Technical Reference (1997)
Problems appending to database (1997)
WebCatalog for guestbook ? (1997)
using showpage and showcart commands (1996)
Date search - yes or no (1997)
text size limitation (1997)
Poll Please (2002)
Encrypt question. (2000)
Pithy questions on webcommerce & siteedit (1997)
WebCat2 several catalogs? (1997)
Template transformed itself into a database? (1998)
Three new problems, maybe a fourth (1997)
RE: problems with dos and tracert + webDNA (1998)
WebCatalog.acgi quitting with error Type 2 (1998)
OBDC Support (1997)