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:

Multiple Newcarts (1996) Help! WebCat2 bug (1997) WebCatalog for Postcards ? (1997) generating a space delimited file (2001) Calendar using WebCatalog? (1997) Can't use old cart file (was One more try) (1997) QuitFeedback & DBNotOpened errors (1997) Re:no [search] with NT (1997) WebCat 5 Intranet Question (2003) [referrer] tag (1997) two unique banners on one page (1997) Targeted Redirect (1999) Renaming textA (1998) WebCatalog can't find database (1997) Bug? (1997) ShowIf, If, XML Syntax.... (2004) WebCommerce: Folder organization ? (1997) Emailer (WebCat2) (1997) has any written a WebDNA calendar that also writes (2004) Web Catalog Instability (2000)