Re: Data Entry ... Excel Style ... How To?
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 38571
interpreted = N
texte = i had another thought about this.i would be even easier if you did the following.created the replace strings on the client in javascript.monitor the onchange event of any of the text boxes and each time it happens, create the replace string from the row of input boxes.then all you need to do is dynamically store this string in some delimitered field.then you shouldn't run into the problem i had of lots of nested loops searching through form variables trying to find out what has changed and what hasn'nt. would have been un useable in any table over 100 rows.all you would need to do is listwords on the hidden input holding the replace string and execute an update for each loop.i should hhave thought about it before...DUH!on 13/9/01 3:46 AM, Sally Reidy at sallyr@dvinci.com wrote:> 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/ ------------------------------------------------------------- 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 had another thought about this.i would be even easier if you did the following.created the replace strings on the client in javascript.monitor the onchange event of any of the text boxes and each time it happens, create the replace string from the row of input boxes.then all you need to do is dynamically store this string in some delimitered field.then you shouldn't run into the problem i had of lots of nested loops searching through form variables trying to find out what has changed and what hasn'nt. would have been un useable in any table over 100 rows.all you would need to do is listwords on the hidden input holding the replace string and execute an update for each loop.i should hhave thought about it before...DUH!on 13/9/01 3:46 AM, Sally Reidy at sallyr@dvinci.com wrote:> 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/ ------------------------------------------------------------- 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:
Problems getting parameters passed into email. (1997)
More on the email templates (1997)
Help! (2000)
JavaScript form question (2001)
mimeheaders to allow back button to work on a posted page? (2004)
looping table rows (1999)
[WebDNA] divisible by 1 (2011)
[sendmail] questions... (1997)
Occasional crashes with $remove (1997)
[include ...] behavior (1997)
another problem (1997)
Not really WebCat (1997)
For those of you not on the WebCatalog Beta... (1997)
Frames and WebCat (1997)
Re1000001: Setting up shop (1997)
Where is f2? (1997)
Include (1998)
[WebDNA] Limits? (2009)
Are you an WC expert? (1997)
WC2/Mac -- Forms not submitting correctly with Mac browsers (1997)