Re: Data Entry ... Excel Style ... How To?

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 38548
interpreted = N
texte = this is the beginning of the code that i just put togther, needs some formatting.
[listfiles path=/stats/] [text]counter=[index][/text] [showif [filename]^db] [listfields db=/stats/[filename]] [showif [index]=1] [search db=/stats/[filename]&ne[fieldname]datarq=FINDALLRECORDS] [founditems] [listfields db=/stats/[filename]] [/listfields] [/founditems] [/search]
[/showif] [/listfields] [/showif] [/listfiles]
i was going to do the appending to the database bit but its home time.made a start = [showif [action]=update] [formvariables name=++&exact=false] [listwords word=[name]&delimiters=*] [showif [index]=2] [text]dbname=[word][/text] [/showif] [/listwords] [formvariables name=] [/formvariables] [/formvariables] [/showif]on 11/9/01 4:35 PM, Terry Nair at taipan@singnet.com.sg wrote:> Good day to all ... > > Objective : > > To extract data from a WCAT database, list it row by row in a table format > where each record has one or more fields (input boxes) with the extracted > data for change. The user, simply changes one or more records and when done, > click on one submit button to update all the changes made for records that > are affected (i.e. Records with no change remains as is). > > Question : > > Has any one done this or can any one propose or submit an example code > snippet for us to review .... That can achieve this Excel style of data > entry. > > As an example of how this code is to function ... Reference can be made to a > product catalog case. Say a product catalog has numerous fields per record > and one of those fields is PRICE. The end user wants to make a change to one > or many records on the PRICE field. > > This can be easily done by listing all records ... Then calling up each > record in turn ... To enter the PRICE change. However, what the end-user > wants is to call up all or list all records .... Then make the changes to > price across one or more of the displayed records and when done, clicking on > one submit button to change all the affected records. Basically ... It saves > time on having to call up each record independently to make the change. > > Found and Replace tag used in WCAT allows looping to change a field but with > one entry value .... Across many records. What is needed is something like > Found and Replace tag .... But able to replace different related values > across many records. > > Hope the explanation is sufficient to give you all an understanding of what > is desired. Any help on this would be much appreciated. I am certain there > is a work around or possible solution to this .... But me poor brain is > going soggy trying to figure out something .... Help if you can. > > Thanks again ... TDn > > > ------------------------------------------------------------- > 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/ ------------------------------------------------------------- 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: Data Entry ... Excel Style ... How To? (Andrew Simpson 2001)
  2. Re: Data Entry ... Excel Style ... How To? (Anup Setty 2001)
  3. Re: Data Entry ... Excel Style ... How To? (Sally Reidy 2001)
  4. Re: Data Entry ... Excel Style ... How To? (Andrew Simpson 2001)
  5. Re: Data Entry ... Excel Style ... How To? (Andrew Simpson 2001)
  6. Re: Data Entry ... Excel Style ... How To? (Aaron Lynch 2001)
  7. Data Entry ... Excel Style ... How To? (Terry Nair 2001)
this is the beginning of the code that i just put togther, needs some formatting.
[listfiles path=/stats/] [text]counter=[index][/text] [showif [filename]^db] [listfields db=/stats/[filename]] [showif [index]=1] [search db=/stats/[filename]&ne[fieldname]datarq=FINDALLRECORDS] [founditems] [listfields db=/stats/[filename]] [interpret][[fieldname]][/interpret] name::[counter]*[fieldname]> [/listfields] [/founditems] [/search]
[/showif] [/listfields] [/showif] [/listfiles]
i was going to do the appending to the database bit but its home time.made a start = [showif [action]=update] [formvariables name=++&exact=false] [listwords word=[name]&delimiters=*] [showif [index]=2] [text]dbname=[word][/text] [/showif] [/listwords] [formvariables name=] [/formvariables] [/formvariables] [/showif]on 11/9/01 4:35 PM, Terry Nair at taipan@singnet.com.sg wrote:> Good day to all ... > > Objective : > > To extract data from a WCAT database, list it row by row in a table format > where each record has one or more fields (input boxes) with the extracted > data for change. The user, simply changes one or more records and when done, > click on one submit button to update all the changes made for records that > are affected (i.e. Records with no change remains as is). > > Question : > > Has any one done this or can any one propose or submit an example code > snippet for us to review .... That can achieve this Excel style of data > entry. > > As an example of how this code is to function ... Reference can be made to a > product catalog case. Say a product catalog has numerous fields per record > and one of those fields is PRICE. The end user wants to make a change to one > or many records on the PRICE field. > > This can be easily done by listing all records ... Then calling up each > record in turn ... To enter the PRICE change. However, what the end-user > wants is to call up all or list all records .... Then make the changes to > price across one or more of the displayed records and when done, clicking on > one submit button to change all the affected records. Basically ... It saves > time on having to call up each record independently to make the change. > > Found and Replace tag used in WCAT allows looping to change a field but with > one entry value .... Across many records. What is needed is something like > Found and Replace tag .... But able to replace different related values > across many records. > > Hope the explanation is sufficient to give you all an understanding of what > is desired. Any help on this would be much appreciated. I am certain there > is a work around or possible solution to this .... But me poor brain is > going soggy trying to figure out something .... Help if you can. > > Thanks again ... TDn > > > ------------------------------------------------------------- > 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/ ------------------------------------------------------------- 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/ Andrew Simpson

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:

Extended [ConvertChars] (1997) [WebDNA] How to get a screen size (2009) [include file=filename.inc&strip=t] (2002) Yet another db manager (2004) shipcost (1997) stats (2001) How to include weather (2000) Some Questions (1997) Choices (2000) mySQL numfound (2006) Guest Book (2002) [OT] BBedit Blank Line removal (2003) [TaxableTotal] - not working with AOL and IE (1997) Tag Corruption (2000) Multiple Stores and WebCatalog Prefs (1997) Nested search (1997) Sku numbers (1997) RE: Can't get appendfile to work (1997) all records returned. (1997) [WebDNA] Sorry WebDNA server not running (2014)