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 Software eCommerce / Web Developer Tools http://www.smithmicro.com Associated Messages, from the most recent to the oldest:

    
  1. Re: auto adding SKUs w/DB helper (Sue Ann Sanders 1998)
  2. Re: auto adding SKUs w/DB helper (John Hill 1998)
  3. Re: auto adding SKUs w/DB helper (Sue Ann Sanders 1998)
  4. Re: auto adding SKUs w/DB helper (John Hill 1998)
  5. auto adding SKUs w/DB helper (Sue Ann Sanders 1998)
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 Software eCommerce / 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)