Re: Updating Prices in Online Database
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 23266
interpreted = N
texte = Would you not just : [search db=newrecords.db&neskudatarq=[blank]&max=8000] [FoundItems] [Replace db=yourdatabase.db]price=[price]] [/Replace] [/FoundItems] Mooseman>Thank you for your response. However, wouldn't this simply append new >records? I just want to replace the one field (price) but want to leave >the other fields untouched (the database from which we export the updated >prices does not contain the same fields as the online database). It looks >like you are replacing the entire record, not just some of the fields in >the record, right? > >Gil Poulsen wrote: > >> Try putting the new records in the same directory as the main database, >> paste this into a template (modified with your fields, of course) and >> just 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]&descriptio >>n=[URL][description][/URL]<ext=[ltext]&lprice=[lprice]&stext=[stext]&price=[pr >>ice]&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]&bigs >>ell=[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 am >> updating 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
Associated Messages, from the most recent to the oldest:
Would you not just : [search db=newrecords.db&neskudatarq=[blank]&max=8000]
[founditems] [Replace db=yourdatabase.db]price=[price]] [/Replace] [/FoundItems] Mooseman>Thank you for your response. However, wouldn't this simply append new >records? I just want to replace the one field (price) but want to leave >the other fields untouched (the database from which we export the updated >prices does not contain the same fields as the online database). It looks >like you are replacing the entire record, not just some of the fields in >the record, right? > >Gil Poulsen wrote: > >> Try putting the new records in the same directory as the main database, >> paste this into a template (modified with your fields, of course) and >> just 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]&descriptio >>n=
[url][description][/URL]<ext=[ltext]&lprice=[lprice]&stext=[stext]&price=[pr >>ice]&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]&bigs >>ell=[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 am >> updating 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
The Mooseman
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:
[ShowNext] feature in 2.0 (1997)
Requiring that certain fields be completed (1997)
WC2.0 Memory Requirements (1997)
Multiple Users.db Possible? (1997)
Sku numbers (1997)
Erotic Sites (1997)
WebDNA 4.5 OSX/OS9 in exchange of WebDNA 4.5 Win (2004)
Status? (2000)
Integration with SQL (1997)
Price override - solved (2004)
showif/hideif 4.0 (2000)
flushdatabases (1997)
2.0 Info (1997)
A little syntax help (1997)
Virtual hosting and webcatNT (1997)
Searching multiple fields (1997)
Emailer Set Up (1997)
Moment of Thanks (1997)
.html with IIS4 (1999)
Document Contains No Data! (1997)