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.comWebMaster - eCommerce SpecialistMacSultantsProfessional Solutions for Computer SystemsPhone# 856-273-3255Fax# 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:
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.comWebMaster - eCommerce SpecialistMacSultantsProfessional Solutions for Computer SystemsPhone# 856-273-3255Fax# 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:
triggers on Linux? (2000)
WebCatalog for guestbook ? (1997)
Links to show shopping cart. (1998)
Mac Vs WindowsNT (1997)
[searchString] (1997)
E-Mailer (WebCatb15acgiMac) (1997)
HELP WITH DATES (1997)
WebCat2: multiple currency support (1997)
WebCat2 - [include] tags (1997)
Problems appending to database (1997)
Attaching a plain text file via [sendmail] (2001)
WebCatalog vs. Cold Fusion (1998)
random sorting broken (was Re[2]: php vs WebCatalog) (2000)
[AppendFile] problem (WebCat2b13 Mac .acgi) (1997)
Webcatalog server support (1997)
Protect (1997)
Two submit buttons ? (1997)
re: date search problem (1999)
Document Contains No Data! (1997)
search with funny characters (2003)