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:
SiteGaurd file Cache vs webcatalog cache (1997)
CC: (1998)
Keep away (1997)
For those of you not on the WebCatalog Beta... (1997)
form crasehes server (1997)
[searchString] (1997)
Merging databases (1997)
OT: Javascript Jump Menu [SOLVED] (2004)
Potential Conflicts? (1997)
Quit revisited (1997)
Summing fields (1997)
How to delete all files in a folder? (2001)
Running _every_ page through WebCat ? (1997)
Another form question (2000)
PCS Frames (1997)
To Err or Not Custom Error (1999)
FREE Web Server Monitor FREE (1997)
Error Log.db --however (1997)
Itools, WEBCAT OSX (2003)
WebCat2b13MacPlugIn - [include] (1997)