Re: auto adding SKUs w/DB helper

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 19295
interpreted = N
texte = 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? >> 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)
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? >> Sue Ann Sanders

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:

Introduction/Tutorial/QuickStart (1997) Replacing entry (1998) No luck with taxes (1997) Protect & InstantSSL (Fixed) (2003) Need relative path explanation (1997) Confessions of a new user - please be kind it's Friday (2000) Help formatting search results w/ table (1997) Web Catalog 2 demo (1997) Weird cart problem (webcat 2.x) (2000) Forwarding Orders Via Email (1998) [foundItems] context problem (2000) Access Denied! But why? (1997) [WebDNA] Serial numbers and pricing for WebDNA 7.0 (2011) WebCatalog2 Feature Feedback (1996) Pull Down Search (2000) WebCatalog stalls (1998) OT (SORT OF): Forcing Webstar Cache Flush (2005) WebCat2 several catalogs? (1997) I try hard to think positively (1998) Download URL & access on the fly ? (1997)