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:
[WebDNA] Lookup vs. Search (2009)
Upgrading old WebCat Database Files (1997)
[WebDNA] [announce] WebDNA 6.2.1x (2012)
FM and Webcat together? (1998)
[WebDNA] preventing hackers from posting their own (2009)
Setting Cart value (2000)
FW: (1999)
[WebDNA] Searching Possible Bug (2009)
PCS Frames (1997)
Windows-user? (2000)
WebMerchant 1.6 and SHTML (1997)
[format 40s]text[/format] doesn't work (1997)
math problems (2000)
NetSplat and WebCat2 (1997)
pull downs (1997)
Help name our technology! (1997)
Conditional searching & displaying (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
Public Beta for WebCatalog 4.0 is Available (2000)
webmerchant/ Mac Auth. and CC refunds (1998)