Re: Changing names of .hdr field names

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 52452
interpreted = N
texte = Gary, Thanks for putting me on the right path; this is what I did: [WRITEFILE /poll/admin/polls/[poll_sku]/pollconvert.db]fromto [SEARCH DB=/poll/data/ pollq.db&eqpollq_polldata=[poll_sku]][FOUNDITEMS][pollq_sku] [UNURL][pollq_name][/UNURL] [/FOUNDITEMS][/SEARCH][/WRITEFILE] [WRITEFILE /poll/admin/polls/[poll_sku]/archive/poll[stamp].xls][CONVERTWORDS DB=/poll/admin/polls/[poll_sku]/pollconvert.db][INCLUDE FILE=/poll/admin/polls/[poll_sku]/pollresponse.hdr][/CONVERTWORDS] [INCLUDE FILE=/poll/admin/polls/[poll_sku]/pollresponse.db][/WRITEFILE] Because this is can take time to convert large .hdr files (a current ballot has 226 questions), I'm going to hard code this into the admin pages so the human readable .hdr is written only when a new poll is created or revised. Thanks again! andy On Friday, Aug 22, 2003, at 15:54 US/Eastern, Gary Krockover wrote: > Can you wrap the [INCLUDE FILE=pollresponse.hdr] part in a > [convertwords]? > The writefile doesn't need the hdr information to do its writing. > > GK > > > > -----Original Message----- > From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of > andy mowrey > Sent: Friday, August 22, 2003 2:36 PM > To: WebDNA Talk > Subject: Changing names of .hdr field names > > > TgIF! > > WebDNA 4.5.1 > Mac 10.2.6 > RAM 1.5GB > > I have a ballot/poll/survey system that automatically generates field > names in pollresponse.hdr file: > q_a1a_b1b_c1c_q_a1a_b1b_c2c_q_a1a_b1b_c3c_q_a1a_b1b_c4c_ > ... > q_a5a_b2b_c22c_q_a5a_b2b_c23c_q_a5a_b2b_c24c_q_a5a_b2b_c25c_ > > In pollq.hdr/pollq.db I have the following: > pollq_skupollq_name > q_a1a_b1b_c1c_African/Caribbean > q_a1a_b1b_c2c_Cajun/Creol > q_a1a_b1b_c3c_Chinese > q_a1a_b2b_c1c_Bagels > > I send data to the poll administrator via email by doing the following: > [WRITEFILE poll[timestamp].xls][INCLUDE FILE=pollresponse.hdr] > [INCLUDE FILE=pollresponse.db][/WRITEFILE] > > This works as expected, except it's not very user friendly: > q_a1a_b1b_c1c_q_a1a_b1b_c2c_q_a1a_b1b_c3c_q_a1a_b1b_c4c > KayaMr. MowLee's ExpressBruggers > Drumm'sRib TicklerLee's ExpressNaked Bagel > etc... > > Is there a way that I can change the dynamically generated field names > to there corresponding human readable ones? > African/CaribbeanCajun/CreolChineseBagels > KayaMr. MowLee's ExpressBruggers > Drumm'sRib TicklerLee's ExpressNaked Bagel > > Tia, > > andy ------------------------------------------------------------- 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: Changing names of .hdr field names ( andy mowrey 2003)
  2. Re: Changing names of .hdr field names ( andy mowrey 2003)
  3. Re: Changing names of .hdr field names ( "Gary Krockover" 2003)
  4. Changing names of .hdr field names ( andy mowrey 2003)
Gary, Thanks for putting me on the right path; this is what I did: [WRITEFILE /poll/admin/polls/[poll_sku]/pollconvert.db]fromto [SEARCH DB=/poll/data/ pollq.db&eqpollq_polldata=[poll_sku]][founditems][pollq_sku] [unurl][pollq_name][/UNURL] [/FOUNDITEMS][/SEARCH][/WRITEFILE] [WRITEFILE /poll/admin/polls/[poll_sku]/archive/poll[stamp].xls][CONVERTWORDS DB=/poll/admin/polls/[poll_sku]/pollconvert.db][INCLUDE FILE=/poll/admin/polls/[poll_sku]/pollresponse.hdr][/CONVERTWORDS] [INCLUDE FILE=/poll/admin/polls/[poll_sku]/pollresponse.db][/WRITEFILE] Because this is can take time to convert large .hdr files (a current ballot has 226 questions), I'm going to hard code this into the admin pages so the human readable .hdr is written only when a new poll is created or revised. Thanks again! andy On Friday, Aug 22, 2003, at 15:54 US/Eastern, Gary Krockover wrote: > Can you wrap the [INCLUDE FILE=pollresponse.hdr] part in a > [convertwords]? > The writefile doesn't need the hdr information to do its writing. > > GK > > > > -----Original Message----- > From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of > andy mowrey > Sent: Friday, August 22, 2003 2:36 PM > To: WebDNA Talk > Subject: Changing names of .hdr field names > > > TgIF! > > WebDNA 4.5.1 > Mac 10.2.6 > RAM 1.5GB > > I have a ballot/poll/survey system that automatically generates field > names in pollresponse.hdr file: > q_a1a_b1b_c1c_q_a1a_b1b_c2c_q_a1a_b1b_c3c_q_a1a_b1b_c4c_ > ... > q_a5a_b2b_c22c_q_a5a_b2b_c23c_q_a5a_b2b_c24c_q_a5a_b2b_c25c_ > > In pollq.hdr/pollq.db I have the following: > pollq_skupollq_name > q_a1a_b1b_c1c_African/Caribbean > q_a1a_b1b_c2c_Cajun/Creol > q_a1a_b1b_c3c_Chinese > q_a1a_b2b_c1c_Bagels > > I send data to the poll administrator via email by doing the following: > [WRITEFILE poll[timestamp].xls][INCLUDE FILE=pollresponse.hdr] > [INCLUDE FILE=pollresponse.db][/WRITEFILE] > > This works as expected, except it's not very user friendly: > q_a1a_b1b_c1c_q_a1a_b1b_c2c_q_a1a_b1b_c3c_q_a1a_b1b_c4c > KayaMr. MowLee's ExpressBruggers > Drumm'sRib TicklerLee's ExpressNaked Bagel > etc... > > Is there a way that I can change the dynamically generated field names > to there corresponding human readable ones? > African/CaribbeanCajun/CreolChineseBagels > KayaMr. MowLee's ExpressBruggers > Drumm'sRib TicklerLee's ExpressNaked Bagel > > Tia, > > andy ------------------------------------------------------------- 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/ andy mowrey

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:

Some Advise needed (1997) RequiredFields template (1997) Processing all html files through WebCat or Typhoon (1998) Re:Navigator 4.01 (1997) Problems appending to database (1997) There's a bug in the math context ... (1997) Using Plug-In while running 1.6.1 (1997) Stopping bad HTML propagation ? (1997) [isfolder] and [filename] (1997) (1997) newbie question about zip code search (2003) Re[2]: Re[2]: OT: Amazon Patents (2000) Comments in db? (1997) Maybe minor bug report (1997) Trouble with formula.db (1997) Country & Ship-to address & other fields ? (1997) Huge databases and RAM (1998) Forms Search Questions (1997) PIXO support (1997) WebCat2 - Getting to the browser's username/password data (1997)