numero = 25656
interpreted = N
texte = Typhoon Pro v3.04 plugin / MacOS / WS 4.0Hello,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).I think I am trying to make this harder than it is.My thoughts are doing a count of the records in the to be 'changed' database I upload, the do a loop to cycle through the records, do a search for the record ID, write out (append) to a report file if the record doesn't exist (unlikely but possible), append a record if the record being updated contains information in the targeted field, then make the change, do a replace and do the next record.Does the above make sense? I can't post code yet as I haven't written any - maybe tonight :)Mit freundlichen Grüßen / Best RegardsDale TherioDresdner Kleinwort Benson Research Jürgen-Ponto-Platz, 1 Frankfurt, Germany +49 (0) 69 263 19977 - phone +49 (0) 69 263 11379 - fax------------------------------------------------------------- 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:
updating a series of records via a text file? (Therio, Dale 1999)
Typhoon Pro v3.04 plugin / MacOS / WS 4.0Hello,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).I think I am trying to make this harder than it is.My thoughts are doing a count of the records in the to be 'changed' database I upload, the do a loop to cycle through the records, do a search for the record ID, write out (append) to a report file if the record doesn't exist (unlikely but possible), append a record if the record being updated contains information in the targeted field, then make the change, do a replace and do the next record.Does the above make sense? I can't post code yet as I haven't written any - maybe tonight :)Mit freundlichen Grüßen / Best RegardsDale TherioDresdner Kleinwort Benson Research Jürgen-Ponto-Platz, 1 Frankfurt, Germany +49 (0) 69 263 19977 - phone +49 (0) 69 263 11379 - fax------------------------------------------------------------- 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 Therio, Dale
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...