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:

NetCloak as Emailer substitute? (1999) [Sum] function? (1997) WebCommerce: Folder organization ? (1997) [WriteFile] problems (1997) E-mail Attachments (1997) b12 cannot limit records returned and more. (1997) show all problem (1997) Banners and sort of random display (1997) encryption in browser? (1998) More questions about serial number dishing (1997) Webstar 1.3.1 PPC (1997) Can [writefile] files be served thru webcat? (2000) RE: OK, here goes... (1997) Help! WebCat2 bug (1997) ShowIf & HideIf Question? (1998) FYI: virus alert (1996) Does webcatalog recognise NULL values? (1998) [Summary] re: Emailer setup (1997) Date in IF ELSE Comparison (2004) Re:Change WebDNA-Talk Mail due to no digest for 1wk (1997)