Re: Data Entry ... Excel Style ... How To?
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 38563
interpreted = N
texte = I have done something similar.... Maybe this will help. Not sure about the limit on sending form data.1st page: return all the records in a form, save the value of [numfound] in a hidden field to pass to next page; save a unique record id (recNum) with the index info from the founditems in a hidden field. This is the page on which the user can edit any of the fields.
2nd page: After submit is a page that replaces all the records with whatever info is in the form fields. This is obviously not that efficient since I am actually replacing all the fields that are on the form as I can't tell which ones are changed. But it does work rather well.[loop start=1&end=[loopnum]] [replace db=some.db&eqrecNumdata=[interpret][recNum[index]][/interpret]]field1=[_fiel d1]& field2=[field2]&field3=[field3][/replace] [/loop]regards,Sally At 12:35 PM 9/11/01, you 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:
I have done something similar.... Maybe this will help. Not sure about the limit on sending form data.1st page: return all the records in a form, save the value of [numfound] in a hidden field to pass to next page; save a unique record id (recNum) with the index info from the founditems in a hidden field. This is the page on which the user can edit any of the fields. 2nd page: After submit is a page that replaces all the records with whatever info is in the form fields. This is obviously not that efficient since I am actually replacing all the fields that are on the form as I can't tell which ones are changed. But it does work rather well.[loop start=1&end=[loopnum]] [replace db=some.db&eqrecNumdata=[interpret][recNum[index]][/interpret]]field1=[_fiel d1]& field2=[field2]&field3=[field3][/replace] [/loop]regards,Sally At 12:35 PM 9/11/01, you 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/
Sally Reidy
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:
range searching (1998)
Calendar using WebCatalog? (1997)
Catalogs and W* (1996)
Include a big block of text (1997)
Nested tags count question (1997)
[WebDNA] CICADA (2009)
[WebDNA] WebDNA 7 running on new 32-bit Debian 6 server (2011)
Bug? (1997)
Comments in db? (1997)
too many nested ... problem (1997)
AAgghh!! Help, please. SSL strikes again. (1997)
test (2004)
emailer (1997)
CVS Files for databases (2000)
webcat 3.06f on Linux keeps dying (1999)
RE: protect tag on NT (1997)
[Announce]: Web server security and password protection (1997)
Late on Friday.... brain fried (2002)
Separate SSL Server (1997)
Format Thousands Looks Busted (2000)