Re: Editing two databases in one form using [replace]?

This WebDNA talk-list message is from

1998

It keeps the original formatting. numero = 21628
interpreted = N
texte = >I use the ProductEditor template from the GeneralStore and would like to>change two databases at the same time, the standard productdatabase>catalog.txt and a second database beschreibung.db which contains the same>sku fields and a field des.>>snip->>

>>> - ???>>>>>>>>>>>>

SKU	[sku] (this is the unique product code>for this item)
Date	size=15> (optional)
Category	value=[input][category][/input] size=15>
Title	value=[input][title][/input] size=70>
Description	rows=2 cols=70>wrap=virtual>[input][description][/input]
Beschreibung	cols=70 wrap=virtual>[input][lookup>db=beschreibung.db&lookinfield=sku&value=[sku]&returnfield=des][/input]</te>xtarea></td></tr>></table>><input type=submit value=Update Product Information>></form>>[/foundItems]>>The lookup of the field des works fine, but I am not able to change the>field des this second database beschreibung.>I hope there will be a simple way!It's easy, just put a [replace] context on the next page with the same search parameters as in the above example, but make it replace values in the beschreibung.db database. You should also get rid of the following line in your above example:<input type=hidden name=db value=beschreibung.db> - ???Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net Associated Messages, from the most recent to the oldest:<br /><br /> <table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td> </td><td> <ol type="1"> <li><a href="page.dna?numero=21652">Re: Editing two databases in one form using [replace]?</a> (Michael Muthmann <mimu@dimu.de> 1998)</li> <li>Re: Editing two databases in one form using [replace]? (Kenneth Grome <ken@webdna.net> 1998)</li> <li><a href="page.dna?numero=21626">Editing two databases in one form using [replace]?</a> (Michael Muthmann <mimu@dimu.de> 1998)</li> </ol> </td></tr></table> >I use the ProductEditor template from the GeneralStore and would like to>change two databases at the same time, the standard productdatabase>catalog.txt and a second database beschreibung.db which contains the same>sku fields and a field des.>>snip->><form method=POST action=AdminModified.tpl>><input type=hidden name=command value=replace>><input type=hidden name=db value=catalog.txt>><input type=hidden name=db value=beschreibung.db> - ???><input type=hidden name=eqSKUdata value=[sku]>>><table border=1>><tr><td align=right>SKU</td><td>[sku] (this is the unique product code>for this item)</td></tr>><tr><td align=right>Date</td><td><input name=Date value=<a target="_parent" href="page.dna?numero=32">[date]</a>>size=15> (optional)</td></tr>><tr><td align=right>Category</td><td><input name=category>value=<a target="_parent" href="page.dna?numero=182">[input]</a>[category][/input] size=15></td></tr>><tr><td align=right>Title</td><td><input name=title>value=<a target="_parent" href="page.dna?numero=182">[input]</a>[title][/input] size=70></td></tr>><tr><td align=right>Description</td><td><textarea name=description>rows=2 cols=70>wrap=virtual><a target="_parent" href="page.dna?numero=182">[input]</a>[description][/input]
Beschreibung	cols=70 wrap=virtual><a target="_parent" href="page.dna?numero=182">[input]</a>[lookup>db=beschreibung.db&lookinfield=sku&value=[sku]&returnfield=des][/input]</te>xtarea></td></tr>></table>><input type=submit value=Update Product Information>></form>>[/foundItems]>>The lookup of the field des works fine, but I am not able to change the>field des this second database beschreibung.>I hope there will be a simple way!It's easy, just put a <a target="_parent" href="page.dna?numero=210">[replace]</a> context on the next page with the same search parameters as in the above example, but make it replace values in the beschreibung.db database. You should also get rid of the following line in your above example:<input type=hidden name=db value=beschreibung.db> - ???Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net <em>Kenneth Grome <ken@webdna.net></em> <br /> <a href="page.dna?numero=169"> <p><b>DOWNLOAD WEBDNA NOW!</b></p> </a> <h3>Top Articles:</h3> <b><a href="page.dna?numero=55">Talk List</a></b> <br /> <p>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...</p> <h3>Related Readings:</h3> <font size="-1"><a href="page.dna?numero=100527">[WebDNA] mail header timezone problem (2008)</a></font> <font size="-1"><a href="page.dna?numero=28797">Pull Down Search (2000)</a></font> <font size="-1"><a href="page.dna?numero=13652">Can I invoke an ssi plugin from within a webcat page (1997)</a></font> <font size="-1"><a href="page.dna?numero=46777">This Code Kills My WebCatalog Dead (2003)</a></font> <font size="-1"><a href="page.dna?numero=10143">2nd WebCatalog2 Feature Request (1996)</a></font> <font size="-1"><a href="page.dna?numero=46401">How to implement 'email to a friend' feature? (2002)</a></font> <font size="-1"><a href="page.dna?numero=66569"> CT Scan might have saved my life!! (2006)</a></font> <font size="-1"><a href="page.dna?numero=105006">[WebDNA] Processor Maxing out (2010)</a></font> <font size="-1"><a href="page.dna?numero=52322"> [encrypt] entire site? (2003)</a></font> <font size="-1"><a href="page.dna?numero=17256">Is this possible in simple search? question? (1998)</a></font> <font size="-1"><a href="page.dna?numero=12089">RE: E-mailer error codes (1997)</a></font> <font size="-1"><a href="page.dna?numero=12136">Summary search -- speed (1997)</a></font> <font size="-1"><a href="page.dna?numero=56186"> I hate talking to myself on this list (2004)</a></font> <font size="-1"><a href="page.dna?numero=13357">SiteEdit Pro Update Announcement (1997)</a></font> <font size="-1"><a href="page.dna?numero=19246">virtual virtual hosted store.... (1998)</a></font> <font size="-1"><a href="page.dna?numero=11868">[TaxableTotal] - not working with AOL and IE (1997)</a></font> <font size="-1"><a href="page.dna?numero=68424"> Preserving file creation dates on [copyfile] (2007)</a></font> <font size="-1"><a href="page.dna?numero=12907">Search with Special Chars (1997)</a></font> <font size="-1"><a href="page.dna?numero=60515"> Is it IE6 hating rediercts? (2004)</a></font> <font size="-1"><a href="page.dna?numero=11704">Thanks and Big News!!! (1997)</a></font> </div> </body> </html>