Re: multiple record replace

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 39964
interpreted = N
texte = I hadn't seen your form source before my last reply. There are several problems there.First, your
tag is inside of the [founditems] loop. This will create multiple embedded forms, one for each found items, without matching
tags, as this must be outside of the [founditems] and therefore occurring only once.Do a Show Source in the browser to see what I mean...Second, I don't see end tags for your [/search] - brian At 4:24 PM -0600 11/7/2001, Lester Emo wrote: >If I do this I and I have 5 items having their approved field >being changed, no data gets written back to the db > >When 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] >> -- <= Brian C. Fries, BrainScan Software http://www.brainscansoftware.com =>------------------------------------------------------------- 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)
I hadn't seen your form source before my last reply. There are several problems there.First, your tag is inside of the [founditems] loop. This will create multiple embedded forms, one for each found items, without matching tags, as this must be outside of the [founditems] and therefore occurring only once.Do a Show Source in the browser to see what I mean...Second, I don't see end tags for your Approved ... [/founditems] [/search] - brian At 4:24 PM -0600 11/7/2001, Lester Emo wrote: >If I do this I and I have 5 items having their approved field >being changed, no data gets written back to the db > >When 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] >> -- <= Brian C. Fries, BrainScan Software http://www.brainscansoftware.com =>------------------------------------------------------------- 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/ Brian Fries

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:

New public beta available (1997) splitting numbers in webDNA? (1997) Re(7): Small Bug: ErrorLog.txt/[FORMVARIABLES]/[ORDERFILE] (1998) Mac Vs WindowsNT (1997) problems with 2 tags shakur (1997) hiding hyperlink info in URL field (1999) UNSUBSCRIBE (2000) WebCatalog 2.1 License for Sale (1998) WebCatalog vs. Cold Fusion (1998) WC2b15 File Corruption (1997) flushdatabases (1997) problems with 2 tags shakur (1997) Location of Browser Info.txt file (1997) WebCat on 10.0.4 - iTools 6.0 (2001) PhotoMill -> PhotoMaster (1997) Multi shift click (1999) WebCat2 - Getting to the browser's username/password data (1997) RE: [WebDNA] REPLACE INCLUDE FILE (2019) Credit card processing - UK (1997) I'm new be kind (1997)