Re: temporary database?
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 34855
interpreted = N
texte = One approach to do this task: I think it is good that you have a field called RECORDID and make this a primary field (unique values);---on your displa page do this;
--- on your results page do this;[loop start=1&end=[loopnum]][replace db=some.db&eqrecordiddata=[interpret][recordid-[index]][/interpret]] materials=[showif [interpret][cb_materials-[index]][/interpret]=yes]yes[/showif][hideif [interpret][cb_materials-[index]][/interpret]=yes]no[/hideif] [/replace][/loop]========= Note: Use the same criteria in the replace as you use in your searchhope this helps... ========================================================== _O_/\NUP Setty / | \/ERTical Net / \ http://www.vertical.net _\ \_ 336-218-8562 Ext. 218 o o o o ========================================================== ----- Original Message ----- From: Sally
To: WebCatalog Talk Sent: Wednesday, July 19, 2000 12:16 PM Subject: temporary database? > This is my problem: > > I have a db file that consists of 2 fields: Name, Materials. The name > field is a person's name and the Materials field has the value YES or > NO. > > I display a list of all the names and a checkbox next to each name that is > checked if the value is YES or unchecked if the value is NO. > > I want to be able to have the user change the value of the checkbox for any > number of names IN THIS LIST and then submit the page, which will then go > and update all the records in the database file that have new values for > the Materials field. > > I don't even know if this is possible with webdna, as I don't want the user > to have to go into each record individually; I want to allow the user to > update all the records from a list and then replace the values in the db file. > > > > This is the only approach I can think of: > > Since the checkbox next to the names in the list is a form variable, I > could pass all the values, to the next page and retrieve them that way, but > how do I tie them back with the Names in the db file. I thought of writing > a temporary database that would record the names from the search in order > and then try to tie the materials field to the right name using [Index] > with formvariables. But I can't get this to work. > > Has anyone ever done anything life this or is it even possible? > > Thanks. > > Sally > > > ------------------------------------------------------------- > 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:
One approach to do this task: I think it is good that you have a field called RECORDID and make this a primary field (unique values);---on your displa page do this; --- on your results page do this;[loop start=1&end=[loopnum]][replace db=some.db&eqrecordiddata=[interpret][recordid-[index]][/interpret]] materials=[showif [interpret][cb_materials-[index]][/interpret]=yes]yes[/showif][hideif [interpret][cb_materials-[index]][/interpret]=yes]no[/hideif] [/replace][/loop]========= Note: Use the same criteria in the replace as you use in your searchhope this helps... ========================================================== _O_/\NUP Setty / | \/ERTical Net / \ http://www.vertical.net _\ \_ 336-218-8562 Ext. 218 o o o o ========================================================== ----- Original Message ----- From: Sally To: WebCatalog Talk Sent: Wednesday, July 19, 2000 12:16 PM Subject: temporary database? > This is my problem: > > I have a db file that consists of 2 fields: Name, Materials. The name > field is a person's name and the Materials field has the value YES or > NO. > > I display a list of all the names and a checkbox next to each name that is > checked if the value is YES or unchecked if the value is NO. > > I want to be able to have the user change the value of the checkbox for any > number of names IN THIS LIST and then submit the page, which will then go > and update all the records in the database file that have new values for > the Materials field. > > I don't even know if this is possible with webdna, as I don't want the user > to have to go into each record individually; I want to allow the user to > update all the records from a list and then replace the values in the db file. > > > > This is the only approach I can think of: > > Since the checkbox next to the names in the list is a form variable, I > could pass all the values, to the next page and retrieve them that way, but > how do I tie them back with the Names in the db file. I thought of writing > a temporary database that would record the names from the search in order > and then try to tie the materials field to the right name using [Index] > with formvariables. But I can't get this to work. > > Has anyone ever done anything life this or is it even possible? > > Thanks. > > Sally > > > ------------------------------------------------------------- > 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/
Anup Setty
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:
Opinion: [input] should be called [output] ... (1997)
emailer (1997)
Request Time Out (1997)
[WebDNA] WebDNA Server 8.6.2 snapshot available (2019)
Converting Aliases to Symbolic Links (2002)
many-to-one problem (1998)
Problems with emailer cutting off carriage returns (Crossplatform issue?) (1999)
RePost: NAT and the CART (1999)
Bug Report, maybe (1997)
using showpage and showcart commands (1996)
WC2.0 Memory Requirements (1997)
Login Page & [Protect] (2001)
Kaaaaahhhhhhhnnnnnnn! (1997)
unable to launch acgi in WebCat (1997)
New Webcatalog for Mac (1997)
TCP Connect (2000)
Math with Time (1997)
Creating comums (1998)
emailer (1997)
authorizenet and netscape (2002)