Re: updating a series of records via a text file?

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 25662
interpreted = N
texte = I think typhoon pro can do more than one db at a time, but I am not too sure about contexts. This may or may not work.[search db=replace.txt&nerecord_iddata=[blank]] [founditems] [replace db=yourdatabase.db&eqrecord_iddatarq=[record_id]]picname=[picname][/re place] [/founditems] [/search]>Typhoon Pro v3.04 plugin / MacOS / WS 4.0 > >Hello, > >I recently had to change how I update a database on one of my sites. What I >would like to do is upload a text (database?) file containing a record_id >and the contents of the field that must be updated. > >e.g. >record_id, picname >3848483948939483, fld1_3848483948939483.jpg > >I would like to create a template that reads this file, does a search on the >first field, then uses the value in the second field to replace the contents >of the same named field in the main database (also writing out to a db or >text file the record ID the contents of the field if it was not blank).-- _______________________________________________________________ Charles Kline ckline@macsultants.com WebMaster - eCommerce SpecialistMacSultants Professional Solutions for Computer SystemsPhone# 856-273-3255 Fax# 856-273-3721 ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 Associated Messages, from the most recent to the oldest:

    
  1. Re: updating a series of records via a text file? (Charles Kline 1999)
  2. updating a series of records via a text file? (Therio, Dale 1999)
I think typhoon pro can do more than one db at a time, but I am not too sure about contexts. This may or may not work.[search db=replace.txt&nerecord_iddata=[blank]] [founditems] [replace db=yourdatabase.db&eqrecord_iddatarq=[record_id]]picname=[picname][/re place] [/founditems] [/search]>Typhoon Pro v3.04 plugin / MacOS / WS 4.0 > >Hello, > >I recently had to change how I update a database on one of my sites. What I >would like to do is upload a text (database?) file containing a record_id >and the contents of the field that must be updated. > >e.g. >record_id, picname >3848483948939483, fld1_3848483948939483.jpg > >I would like to create a template that reads this file, does a search on the >first field, then uses the value in the second field to replace the contents >of the same named field in the main database (also writing out to a db or >text file the record ID the contents of the field if it was not blank).-- _______________________________________________________________ Charles Kline ckline@macsultants.com WebMaster - eCommerce SpecialistMacSultants Professional Solutions for Computer SystemsPhone# 856-273-3255 Fax# 856-273-3721 ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 Charles Kline

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:

Running 2 two WebCatalog.acgi's (1996) webdelivery.html and webna (1997) [OT] Xserve (2002) Sort Order on a page search (1997) RE: Force a number with JavaScript (1998) WebCat, The Trend, & Consolidating... (1997) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) Multiple Pulldowns (1997) WebCat2b12 CGI Mac -- Problems propagating the cart through (1997) WebCatalog 4.0.2b5 available (2000) WebCatalog.acgi quitting with error Type 2 (1998) Need help!! on searching in two databases. (1998) Converting native excel files (2001) Newbie - Search question (1998) Nested search (1997) [shell]? (2000) [searchString] (1997) template not found error (1998) Bug? (1997) Multiple catalog databases and showcart (1997)