Re: FEA REQ: One .hdr, multiple .db's

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 52382
interpreted = N
texte = > > For that matter, how many people actually have multiple db's with the >> same exact fields in them? In the dozen or so sites on my existing >> hosting service, no two of my db's are alike! > >We have about 30 customers and updating those 30 customers with the same >header information is painful. Yes, i have written a Unix script that does >some of this. Here's some webdna to make it easier for you. All you need is three things: 1- a new db that lists the paths from a new admin template to all the ..hdr files you want to update. 2- a file that has the new field names in it (basically a template of the new .hdr file) 3- a new admin template to put your webdna code in And here they are: 1- identicalHeaderPaths.db: skuhdrPath 1site1folder/user.hdr 2site2folder/user.hdr 3site3folder/user.hdr 2- newDBfields: skunameaddresscitystatezipuserpass 3- newAdminTemplate.tpl: [search db=identicalHeaderPaths.db&nehdrPathdatarq=[blank]] [founditems] [writefile file=[hdrPath]][include file=newDBfields][/writefile] [/founditems] [/search] [flushdatabases] Unless I'm mistaken, this will take care of all the issues you guys have been talking about. Please tell me what I've missed that will prevent this 10 minute solution from doing exactly what you want to do with any number of db's that need the same new fields added to them from time to time ... ??? -- Sincerely, Kenneth Grome ------------------------------------------------------------- Outsource your WebDNA programming for $18 an hour or less! ------------------------------------------------------------- ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: FEA REQ: One .hdr, multiple .db's ( "WebDna @" 2003)
  2. Re: FEA REQ: One .hdr, multiple .db's ( Terry Wilson 2003)
  3. Re: FEA REQ: One .hdr, multiple .db's ( Kenneth Grome 2003)
  4. Re: FEA REQ: One .hdr, multiple .db's ( Matthew Bohne 2003)
  5. Re: FEA REQ: One .hdr, multiple .db's ( "Gary Krockover" 2003)
  6. Re: FEA REQ: One .hdr, multiple .db's ( Kenneth Grome 2003)
  7. Re: FEA REQ: One .hdr, multiple .db's ( "Nitai @ ComputerOil" 2003)
  8. Re: FEA REQ: One .hdr, multiple .db's ( Kenneth Grome 2003)
  9. Re: FEA REQ: One .hdr, multiple .db's ( "Nitai @ ComputerOil" 2003)
  10. Re: FEA REQ: One .hdr, multiple .db's ( Matthew Bohne 2003)
  11. Re: FEA REQ: One .hdr, multiple .db's ( Terry Wilson 2003)
  12. Re: FEA REQ: One .hdr, multiple .db's ( "Nitai @ ComputerOil" 2003)
  13. Re: FEA REQ: One .hdr, multiple .db's ( Kenneth Grome 2003)
  14. Re: FEA REQ: One .hdr, multiple .db's ( "Scott Anderson" 2003)
  15. Re: FEA REQ: One .hdr, multiple .db's ( "Scott Anderson" 2003)
  16. Re: FEA REQ: One .hdr, multiple .db's ( Stuart Tremain 2003)
  17. Re: FEA REQ: One .hdr, multiple .db's ( Donovan 2003)
  18. Re: FEA REQ: One .hdr, multiple .db's ( Scott Anderson 2003)
  19. Re: FEA REQ: One .hdr, multiple .db's ( Matthew Bohne 2003)
  20. Re: FEA REQ: One .hdr, multiple .db's ( Brian Fries 2003)
  21. Re: FEA REQ: One .hdr, multiple .db's ( John Hill 2003)
  22. Re: FEA REQ: One .hdr, multiple .db's ( John Peacock 2003)
  23. Re: FEA REQ: One .hdr, multiple .db's ( "Scott Anderson" 2003)
  24. Re: FEA REQ: One .hdr, multiple .db's ( "Nitai @ ComputerOil" 2003)
  25. Re: FEA REQ: One .hdr, multiple .db's ( Donovan 2003)
  26. Re: FEA REQ: One .hdr, multiple .db's ( "Nitai @ ComputerOil" 2003)
  27. Re: FEA REQ: One .hdr, multiple .db's ( "WebDna @" 2003)
  28. Re: FEA REQ: One .hdr, multiple .db's ( "Nitai @ ComputerOil" 2003)
  29. FEA REQ: One .hdr, multiple .db's ( Matthew Bohne 2003)
> > For that matter, how many people actually have multiple db's with the >> same exact fields in them? In the dozen or so sites on my existing >> hosting service, no two of my db's are alike! > >We have about 30 customers and updating those 30 customers with the same >header information is painful. Yes, i have written a Unix script that does >some of this. Here's some webdna to make it easier for you. All you need is three things: 1- a new db that lists the paths from a new admin template to all the ..hdr files you want to update. 2- a file that has the new field names in it (basically a template of the new .hdr file) 3- a new admin template to put your webdna code in And here they are: 1- identicalHeaderPaths.db: skuhdrPath 1site1folder/user.hdr 2site2folder/user.hdr 3site3folder/user.hdr 2- newDBfields: skunameaddresscitystatezipuserpass 3- newAdminTemplate.tpl: [search db=identicalHeaderPaths.db&nehdrPathdatarq=[blank]] [founditems] [writefile file=[hdrPath]][include file=newDBfields][/writefile] [/founditems] [/search] [flushdatabases] Unless I'm mistaken, this will take care of all the issues you guys have been talking about. Please tell me what I've missed that will prevent this 10 minute solution from doing exactly what you want to do with any number of db's that need the same new fields added to them from time to time ... ??? -- Sincerely, Kenneth Grome ------------------------------------------------------------- Outsource your WebDNA programming for $18 an hour or less! ------------------------------------------------------------- ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/ Kenneth Grome

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:

Date field search needs ... (1998) carriage returns in data (1997) Emailer help....! (1997) verification (2004) Using [random] (1999) [WebDNA] Calendar Edit (2010) [thisurl] or another way (2000) need help sifting through a few thousand files (2002) ODBC to WebCat (2000) Nesting format tags (1997) Robert Minor duplicate mail (1997) Sorting by SKU Not Working (1998) How nuch ram??? (1997) slow site (2003) Order not created error (1997) Multiple Image Upload --> ImageMagick (2005) [WebDNA] WebDNA and MAMP/Apache (Mac) (2018) Thanks ! (1997) Caching [include] files ... (1997) Multiple prices per product (2004)