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:

No messages for a week? (2000) Error reading data -1 (1997) Webmerchant quitting (1998) test (2004) Creating comums (1998) Setting the Date (2000) [WebDNA] Brian Harrington (2019) Email notification to one of multiple vendors ? (1997) weening me off overwriting form variables. John Peacock? (2000) WebCatalog2 for NT Beta Request (1997) New Weird Behavior (bug report) (2000) Out of the woodwork (2007) CommandSecurity? (1997) read and write you own cookies with webcat (1997) Emailer help....! (1997) Checkboxes (1998) Search Help Please (1998) Sorting by highest number of matches unique to a field (2003) Search in 2 or more catalogs (1997) Nested vs conditional (1997)