Help ! Frustrating Problem

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 23247
interpreted = N
texte = Hello everyone,I thought that this was going to be an easy (no brainer) and it is turning out to be really frustrating. I have a form that I will use to update a database. I fill in the form automatically with the current data by doing a search. Then, The user can change the data shown in the fields if it needs to be and then submit the form. This should then update the database using a replace. I thought I understood the process really well...but I an not get it to work. I am using version 3.0.4b5 I have tried many different ways of coding this from hard coding to doing the search. It works ok if I hard code the replace and only do it for one field like this:

If I add another field like this it breaks it:


So what I really want to do is this, but it does not work either:
[Math show=F]Total=0[/Math] [Search db=Holdings.db&neCompNamedata=[blank]&rank=off] [FoundItems] [Math show=F]Total=([Total]+[PrcntHolding])[/Math] [ShowIf [Math][index]%2[/Math]=1] [/ShowIf] [ShowIf [Math][index]%2[/Math]=0] [/ShowIf] [/FoundItems] [/Search]
%
%
[Commitdatabase Holdings.db]
Some one please help =) I will send .db files if it helps.ThanksCharles-- _______________________________________________________________ Charles Kline ckline@macsultants.com WebMaster - eCommerce SpecialistMacSultants Professional Solutions for Computer SystemsPhone# 609-273-3255 Fax# 609-273-3721 Associated Messages, from the most recent to the oldest:

    
  1. Re: Help ! Frustrating Problem (John Hill 1999)
  2. Help ! Frustrating Problem (charles kline 1999)
Hello everyone,I thought that this was going to be an easy (no brainer) and it is turning out to be really frustrating. I have a form that I will use to update a database. I fill in the form automatically with the current data by doing a search. Then, The user can change the data shown in the fields if it needs to be and then submit the form. This should then update the database using a replace. I thought I understood the process really well...but I an not get it to work. I am using version 3.0.4b5 I have tried many different ways of coding this from hard coding to doing the search. It works ok if I hard code the replace and only do it for one field like this:

If I add another field like this it breaks it:


So what I really want to do is this, but it does not work either:
[Math show=F]Total=0[/Math] [Search db=Holdings.db&neCompNamedata=[blank]&rank=off] [founditems] [Math show=F]Total=([Total]+[PrcntHolding])[/Math] [ShowIf [math][index]%2[/Math]=1] [/ShowIf] [ShowIf [math][index]%2[/Math]=0] [/ShowIf] [/FoundItems] [/Search]
%
%
[Commitdatabase Holdings.db]
Some one please help =) I will send .db files if it helps.ThanksCharles-- _______________________________________________________________ Charles Kline ckline@macsultants.com WebMaster - eCommerce SpecialistMacSultants Professional Solutions for Computer SystemsPhone# 609-273-3255 Fax# 609-273-3721 charles kline

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:

Web Catalog 2 demo (1997) WebCatalog Upgrade Pricing? (1997) Search/sort in URL Was: GuestBook example (1997) Still having install problems (2000) Help!!!! (1999) Plugin or CGI or both (1997) Recursion & WebDNA (1999) Hiding Email Addresses (2003) Email notification to one of multiple vendors ? (1997) Running _every_ page through WebCat ? (1997) Quit revisited (1997) emails sent via WebDNA 6.0a disappearing into thin air (2005) Help formatting search results w/ table (1997) Text limits in NT version? (1997) Problems appending to database (1997) Great product and great job ! (1997) Emailer (WebCat2) (1997) WebCatalog can't find database (1997) service stop and restart (1997) method of payment (1997)