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.
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:
this is the beginning of the code that i just put togther, needs some formatting.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:
Simple way to create unique SKU (1997)
NT vs Mac (1997)
WebCat2 - [format thousands] (1997)
[ShowNext] feature in 2.0 (1997)
PCS Frames-Default page is solution! (1997)
NT BETA BUG???? (1997)
WebCatalog for Postcards ? (1997)
Help! WebCat2 bug (1997)
[format xs] freeze (1997)
OT-JS why it does not run on Mac (2001)
carriage returns in data (1997)
Maximum characters in header? (1999)
[delete] problem (1997)
Frames and WebCat (1997)
[WebDNA] test (2016)
WebCatalog 3.0.4 alias crash bug? (2000)
$Replace with [founditems] (1997)
WebCatalog 4.0 has been released! (2000)
WebCatalog2 Feature Feedback (1996)
How do I get Google to crawl a WebCat site? (2003)