Re: Updating Prices in Online Database
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 23262
interpreted = N
texte = Try putting the new records in the same directory as the main database,paste this into a template (modified with your fields, of course) andjust hitting it with your browser:[search db=newrecords.db&neskudatarq=[blank]&max=8000][FoundItems][Append db=yourdatabase.db]sku=[sku]&title=[URL][title][/URL]&author=[author]&description=[URL][description][/URL]<ext=[ltext]&lprice=[lprice]&stext=[stext]&price=[price]&locator=[URL][locator][/URL]&mhseq=[mhseq]&mhgroup=[mhgroup]&liseq=[liseq]&ligroup=[ligroup]&faseq=[faseq]&fagroup=[fagroup]&flseq=[flseq]&flgroup=[flgroup]&hiseq=[hiseq]&higroup=[higroup]&bbseq=[bbseq]&bbgroup=[bbgroup]&new=[new]&bigsell=[bigsell]&video=[video]&forthcoming=[forthcoming]&reduced=[reduced][/Append][/FoundItems]
[numfound] records have been added per your request.[/search]It takes about 45 seconds to process this on my 6100/G3; typically I amupdating about 3,000 records to a 10,000 record database.Mike Eberly wrote:> > I would like to write a merge WebDNA that searches thru a temporary> (updated) database and does a [replace] on the main database. I had> posted this in the past and someone from Technical support had suggested> creating a separate db with just the sku number and price fields. This> would be an easy solution, however I would like to keep the database> together for other reasons (instead of pulling info from two different> db's). Does anyone have a code already developed which is similar to> what I am looking for?> > >Basically, I would like to be able to export everything from our> >off-line database, create a temporary online database with the> >exported info, be able to compare the part numbers in the temporary> >database with the part numbers in the Catalog.db and when it finds> >matching part numbers, replace the price field in the Catalog.db with> >the price in the temporary database.> > Thanks for your help.> > Mike-- Gil Poulsen, Webmaster*************************************************************** AltiM@c * Phone: (908) 222-9001 ** 111 Mali Drive * FAX: (908) 222-9002 ** North Plainfield, NJ * e-mail: help@altimac.com ** 07062-2355 * WWW: http://www.altimac.com ***************************************************************
Associated Messages, from the most recent to the oldest:
Try putting the new records in the same directory as the main database,paste this into a template (modified with your fields, of course) andjust hitting it with your browser:[search db=newrecords.db&neskudatarq=[blank]&max=8000]
[founditems][Append db=yourdatabase.db]sku=[sku]&title=
[url][title][/URL]&author=[author]&description=
[url][description][/URL]<ext=[ltext]&lprice=[lprice]&stext=[stext]&price=[price]&locator=
[url][locator][/URL]&mhseq=[mhseq]&mhgroup=[mhgroup]&liseq=[liseq]&ligroup=[ligroup]&faseq=[faseq]&fagroup=[fagroup]&flseq=[flseq]&flgroup=[flgroup]&hiseq=[hiseq]&higroup=[higroup]&bbseq=[bbseq]&bbgroup=[bbgroup]&new=[new]&bigsell=[bigsell]&video=[video]&forthcoming=[forthcoming]&reduced=[reduced][/Append][/FoundItems]
[numfound] records have been added per your request.[/search]It takes about 45 seconds to process this on my 6100/G3; typically I amupdating about 3,000 records to a 10,000 record database.Mike Eberly wrote:> > I would like to write a merge WebDNA that searches thru a temporary> (updated) database and does a
[replace] on the main database. I had> posted this in the past and someone from Technical support had suggested> creating a separate db with just the sku number and price fields. This> would be an easy solution, however I would like to keep the database> together for other reasons (instead of pulling info from two different> db's). Does anyone have a code already developed which is similar to> what I am looking for?> > >Basically, I would like to be able to export everything from our> >off-line database, create a temporary online database with the> >exported info, be able to compare the part numbers in the temporary> >database with the part numbers in the Catalog.db and when it finds> >matching part numbers, replace the price field in the Catalog.db with> >the price in the temporary database.> > Thanks for your help.> > Mike-- Gil Poulsen, Webmaster*************************************************************** AltiM@c * Phone: (908) 222-9001 ** 111 Mali Drive * FAX: (908) 222-9002 ** North Plainfield, NJ * e-mail: help@altimac.com ** 07062-2355 * WWW: http://www.altimac.com ***************************************************************
Gil Poulsen
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:
My first WebCat site (2000)
strange IE 4.0 (1998)
[format 40s]text[/format] doesn't work (1997)
Non-Cart Files in Shopping Cart Folder (1997)
WebCat2 Append problem (B14Macacgi) (1997)
include (1998)
Sendmail Excel attachment (2003)
Customer (1998)
sandboxes with 6.0 (2004)
Just Testing (1997)
WebCatalog 4 Install Problems - Not Answered ?? (2000)
form posts expiring instantly... why? (2000)
Filemaker Pro Template for Orders (1999)
bug in [SendMail] (1997)
WebCat2 Append problem (B14Macacgi) (1997)
Stopping bad HTML propagation ? (1997)
Keep away (1997)
New index for docs (1997)
Exists? (1997)
autosensing lanague selection (1997)