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:

Mac v. NT (1998) WebCat2 beta 11 - new prefs ... (1997) PDF writefile problem (2004) WebCat for mass emailings (1997) How to include weather (2000) Shopping cart problem (2003) How does WebCatalog search the database? (1997) server not running. (2003) categories and subcategories (2004) [WebDNA] for a rainy day.. if ever/when the hood is up again on the [function]/[return] code (2011) [WebDNA] Displaying age (2010) WebDNA CAPTCHA (2008) Pithy questions on webcommerce & siteedit (1997) WebCat2final1 crashes (1997) Next (1997) Sorting by date (1997) Windows 2003 Web Edition and WebCatalog 6.0a Guide (2006) [WebDNA] [text scope=global] (2014) Webcatalog quitting (1997) Help with nested search (1998)