Re: Data Entry ... Excel Style ... How To?
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 38547
interpreted = N
texte = Yes, this is possible. However you do run into some limits of HTML rather fast. There are some hard size limits to how much data you can actually pass in a single form (I don't personally know what they are)But basically, when you present the page to the user, you need to name each field somehow. (depends on your database structure)So if for example you have numeric sku's and you have a single field: fname.You could do something like
On the 'receiving' page,[Formvariables name=fname__&exact=f] [replace db=your.db&eqskudata=[getchars start=8][name][/getchars]]fname=[url][value][/url][/replace] [/formvariables]So it'll loop through the variables, derive SKU out of the name and fill in the value.There are lots of variations on the idea, you could use midd/e or some other tag, you can even mix in listfields to make it truly dynamic, but hopefully this gives you the general idea. HTH-A On 9/10/01 9:35 PM, The Defendant Terry Nair
Confessed:> 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/-- Aaron Lynch System Administrator NineWire Digital Solutions || http://ninewire.comA common mistake that people make when trying to design something completely foolproof is to underestimate the ingenuity of complete fools. -Douglas Adams ------------------------------------------------------------- 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:
Yes, this is possible. However you do run into some limits of HTML rather fast. There are some hard size limits to how much data you can actually pass in a single form (I don't personally know what they are)But basically, when you present the page to the user, you need to name each field somehow. (depends on your database structure)So if for example you have numeric sku's and you have a single field: fname.You could do something like On the 'receiving' page,[Formvariables name=fname__&exact=f] [replace db=your.db&eqskudata=[getchars start=8][name][/getchars]]fname=[url][value][/url][/replace] [/formvariables]So it'll loop through the variables, derive SKU out of the name and fill in the value.There are lots of variations on the idea, you could use midd/e or some other tag, you can even mix in listfields to make it truly dynamic, but hopefully this gives you the general idea. HTH-A On 9/10/01 9:35 PM, The Defendant Terry Nair Confessed:> 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/-- Aaron Lynch System Administrator NineWire Digital Solutions || http://ninewire.comA common mistake that people make when trying to design something completely foolproof is to underestimate the ingenuity of complete fools. -Douglas Adams ------------------------------------------------------------- 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/
Aaron Lynch
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:
Introduction/Tutorial/QuickStart (1997)
shipcost (1997)
Generating Options for a Form. (1997)
using showpage and showcart commands (1996)
.html processing? (1998)
CR's (2003)
WebDNA vs PHP (2003)
Problems with cybercash (2000)
WebCat & WebTen (1997)
email code (1998)
[ShowNext] (1997)
Running 2 two WebCatalog.acgi's (1996)
RAW=T..Strange behaviour (2000)
[Reload mydata.db] (1998)
Questions about searching (1999)
upgrade? (1997)
problems with 2 tags shakur (1997)
[AppendFile] problem (WebCat2b13 Mac .acgi) (1997)
re:check boxes (1997)
Claris HomePage messes up the code (1997)