Re: Update DB

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 40358
interpreted = N
texte = Basically, you need to read through your uploaded flat file as a database, and search your existing database for each SKU. If not found, add it. If found, ignore it.If your uploaded file does not already contain a header line, you either need to add one or create a .hdr file with the same name as your uploaded file.The code for adding new entries would look something like this:[search db=uploaded.db&neCustomer_skudatarq=_bogus_&rank=off][founditems] [search db=existing.db&eqCustomer_skudatarq=[url][Customer_sku][/url]] [showif [numfound]>0] [append db=existing.db][!] [/!]Customer_sku=[url][Customer_sku][/url]&[!] [/!]Account_code=[url][Account_code][/url]&[!] [/!]Customer_Product_code=[url][Customer_Product_code][/url][!] [/!][/append] [/showif] [/search] [/founditems][/search]- BrianAt 8:25 AM +0000 11/27/2001, Jan Pettersen wrote: >All, >I have an application where I can convert and upload flat files from an >SQL db to my webserver. In the process of doing so I would like to be able >to compare the two so that only new entries are allowed into the exsisting >file on the web. >The files do only have three columns each: >Customer_sku, Account_code and Customer_Product_code >How can I go about doing so? > >Suggestions will be much appreciated! > >Jan------------------------------------------------------------- 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: Update DB (Brian Fries 2001)
  2. Update DB (Jan Pettersen 2001)
Basically, you need to read through your uploaded flat file as a database, and search your existing database for each SKU. If not found, add it. If found, ignore it.If your uploaded file does not already contain a header line, you either need to add one or create a .hdr file with the same name as your uploaded file.The code for adding new entries would look something like this:[search db=uploaded.db&neCustomer_skudatarq=_bogus_&rank=off][founditems] [search db=existing.db&eqCustomer_skudatarq=[url][Customer_sku][/url]] [showif [numfound]>0] [append db=existing.db][!] [/!]Customer_sku=[url][Customer_sku][/url]&[!] [/!]Account_code=[url][Account_code][/url]&[!] [/!]Customer_Product_code=[url][Customer_Product_code][/url][!] [/!][/append] [/showif] [/search] [/founditems][/search]- BrianAt 8:25 AM +0000 11/27/2001, Jan Pettersen wrote: >All, >I have an application where I can convert and upload flat files from an >SQL db to my webserver. In the process of doing so I would like to be able >to compare the two so that only new entries are allowed into the exsisting >file on the web. >The files do only have three columns each: >Customer_sku, Account_code and Customer_Product_code >How can I go about doing so? > >Suggestions will be much appreciated! > >Jan------------------------------------------------------------- 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/ Brian Fries

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:

Max Record length restated as maybe bug (1997) MATH PROBLEM (1997) Emailer port change (1997) 2.0Beta Command Ref (can't find this instruction) (1997) Function defined inside Scope context (2005) WebDNA deletes major DB data big time (2004) GuestBook example (1997) problems with WebCat-Plugin (1997) problem with dates, NT version (1997) Multiple Newcarts (1996) Password and Allow commands (1998) Problems with [Search] param - Mac Plugin b15 (1997) [WebDNA] WebDNA 7 on 8GB RAM server (2013) acrobat -> wc (1998) can WC render sites out? (1997) Sort Order on a page search (1997) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) WebCatalog 2.1 for NT (1998) locking variables? (2000) Problems passing [SKU] with $Replace in 2.0 (1997)