Re: multiple record replace

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 39959
interpreted = N
texte = If I do this I and I have 5 items having their approved field being changed, no data gets written back to the dbWhen I set up a page showing what formvariables are being passed to this page with [replace] what I see is the first field only.Am I using [formvariables] incorrectly here?? > >WebCat can see all the passed in uniqueID values, but only within >a [formvariables] context. To set the approved flag for all the checked records, >you could do this: >[formvariables name=uniqueID&exact=T] >[replace >db=../listings.db&equniqueIDdata=[value]]approved=[approved][/replace] >[/formvariables] > >- Brian > Here's my scenario: > > A search in a database is done. > the results page shows > > name phone createdate approved uniqueID > > I'm wanting to be able to Approve or Unapprove on this page, with the > results being written back into the database records > The approve/unapprove items change daily. > > I've tried this with checkboxes and with a yes/no select form element. > Both ways I get weird results, sometimes the approve part gets written > back as wanted, other times not, most times not. > > If I go to the individual item and change Approved all behaves as needed. > Its just in this mass change scenario it fails. > > I saw a post where I think this was sorta answered, but i got lost following > the code . . . > . > code from the search result page ========================== > > width=100%> > > > > > > > > > [FoundItems] > > > > > > > > > > > > > > > > [/FoundItems] >
NamePhoneCreatedApprovedUniqueID
> [Name] > > [Phone1] > > [createdate] > > > > [uniqueID] >
> > > > > > replace context code follows on the submit approved changes page > ========================== > > > > [replace > db=../listings.db&equniqueIDdata=[uniqueID]]&approved=[approved][/replace] > ------------------------------------------------------------- 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://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: multiple record replace (Brian Fries 2001)
  2. Re: multiple record replace (Lester Emo 2001)
  3. Re: multiple record replace (Brian Fries 2001)
  4. Re: multiple record replace (Donovan Brooke 2001)
  5. Re: multiple record replace (Donovan Brooke 2001)
  6. Re: multiple record replace (Donovan Brooke 2001)
  7. Re: multiple record replace (Donovan Brooke 2001)
  8. Re: multiple record replace (Stephen Russo 2001)
  9. Re: multiple record replace (Sally Reidy 2001)
  10. Re: multiple record replace (Christer Olsson 2001)
  11. Re: multiple record replace (Glenn Busbin 2001)
  12. Re: multiple record replace (Ron Parker 2001)
  13. Re: multiple record replace (Brian Boegershausen 2001)
  14. multiple record replace (Rich Kwasniewski 2001)
If I do this I and I have 5 items having their approved field being changed, no data gets written back to the dbWhen I set up a page showing what formvariables are being passed to this page with [replace] what I see is the first field only.Am I using [formvariables] incorrectly here?? > >WebCat can see all the passed in uniqueID values, but only within >a [formvariables] context. To set the approved flag for all the checked records, >you could do this: >[formvariables name=uniqueID&exact=T] >[replace >db=../listings.db&equniqueIDdata=[value]]approved=[approved][/replace] >[/formvariables] > >- Brian > Here's my scenario: > > A search in a database is done. > the results page shows > > name phone createdate approved uniqueID > > I'm wanting to be able to Approve or Unapprove on this page, with the > results being written back into the database records > The approve/unapprove items change daily. > > I've tried this with checkboxes and with a yes/no select form element. > Both ways I get weird results, sometimes the approve part gets written > back as wanted, other times not, most times not. > > If I go to the individual item and change Approved all behaves as needed. > Its just in this mass change scenario it fails. > > I saw a post where I think this was sorta answered, but i got lost following > the code . . . > . > code from the search result page ========================== > > width=100%> > > > > > > > > > [founditems] > > > > > > > > > > > > > > > > [/FoundItems] >
NamePhoneCreatedApprovedUniqueID
> [Name] > > [Phone1] > > [createdate] > > > > [uniqueID] >
> > > > > > replace context code follows on the submit approved changes page > ========================== > > > > [replace > db=../listings.db&equniqueIDdata=[uniqueID]]&approved=[approved][/replace] > ------------------------------------------------------------- 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://search.smithmicro.com/ Lester Emo

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:

RE: Answer: WebDelivery downloads alias, not original ? (1997) Re:Searching for ALL / empty form field (1997) Price and Formula.db (2002) [WebDNA] MD5 encryption (2011) [WebDNA] What Happened To Zero? (2017) DB Commit (2000) [WebDNA] [ipaddress] - [RealIP] - Not working properly (2016) real beginner stumped (2000) Bug or syntax error on my part? (1997) update on wn searching (1997) [WebDNA] Needing Open Source Support (2012) I've been thinking (2002) Execute Applescript (1997) latest version? (1998) Anyone using Editize (inline html editor) w/ WebDNA (2003) [LOOKUP] (1997) Draft Manual, Tutorial, and more (1997) Using Plug-In while running 1.6.1 (1997) [WebDNA] Triggers not working (2011) webcat- multiple selection in input field (1997)