Re: Data Entry ... Excel Style ... How To?
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 38552
interpreted = N
texte = well thinking about my response, i found a snag.was writing the replace rountine when i thought...i don't know which values have changed and which values have not.you need to know which values have stayed the same so as you can use these to compare to the fields in the database so that the replace will work.you would most likely need to add a hidden field or some kind of key in the html attached to each value of each row then put some javascript on the client to establish if the value had been changed then, once back on the server you can establish which fields you are able to use to do the comparison and which fields you are using as updated data.,Andrewon 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:
well thinking about my response, i found a snag.was writing the replace rountine when i thought...i don't know which values have changed and which values have not.you need to know which values have stayed the same so as you can use these to compare to the fields in the database so that the replace will work.you would most likely need to add a hidden field or some kind of key in the html attached to each value of each row then put some javascript on the client to establish if the value had been changed then, once back on the server you can establish which fields you are able to use to do the comparison and which fields you are using as updated data.,Andrewon 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:
WebCatalog Features (1997)
Regular expression to match email address (2003)
WC1.6 to WC2 date formatting -FIXED! (1997)
problem using ErrorMessages.db to redirect requests (2004)
Order file numbers different than the cart number. why? (2000)
Security Question (1997)
Null Characters (2005)
[append] and SSL (1997)
formula inside database to calculate weights (1997)
Special characters in field names (1998)
Admin Edit prob. (1997)
Webcat and logging (1998)
Sorting Various Sizes (2003)
My solution... (1996)
Emailer issue (2006)
Generating Report Totals (1997)
StoreBuilder ADD 2 CART redirects to default.tpl - PLEASESTOP THIS! (2002)
Live hits (2003)
[CART] (1997)
japanese characters (1997)