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:
Separate SSL Server (1997)
Trouble with formula.db (1997)
WebCat Performance Issue (2000)
Virtual hosting and webcatNT (1997)
Gremlins, huh? (2000)
Permissions Ignored - PLEASE HELP (2003)
Questions To Answer (1997)
WebCat hosting providers? - one more option (1997)
Javascript/WebCatalog form population (2001)
Snake Bites (1997)
How to best sort in a pre-defined item-by-item order ... (2003)
multiple product databases (1997)
Spawn not working (1999)
Most Efficiant Way to do restricted Areas (1997)
HELP WITH DATES (1997)
Storebuilder Seems to have just died (2003)
What am I doing wrong? (2000)
Introduction/Tutorial/QuickStart (1997)
Running _every_ page through WebCat ? (1997)
Problems with [Search] param - Mac Plugin b15 (1997)