Re: Deleting associated records from 2 different databases
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 40115
interpreted = N
texte = Have you tried using the [closedatabase tag after your [search] tag?= Anup----- Original Message ----- From: Gary Krockover
To: WebCatalog Talk Sent: Thursday, November 15, 2001 1:38 AM Subject: Re: Deleting associated records from 2 different databases > Yeah, seems obvious, but it stops after the first delete. I have: > > Deleting AKU:[aku] from catalog.txt
> [delete db=catalog.txt&eqakudatarq=[url][aku][/url]] > Deleting AKU:[aku] from products.txt
> Deleting SKU(s):[search > db=products.txt&eqakudatarq=[aku]][founditems][sku],[showif > [index]\3]
[/showif][/founditems][/search]
> [delete db=products.txt&eqakudatarq=[url][aku][/url]] > > And the results showing from this page are: > Deleting AKU:38130 from catalog.txt > Deleting AKU: from products.txt > Deleting SKU(s): > > Physically checking the 2 databases shows that it is being deleted from the > first but not the 2nd. I've played with adding close/commit databases in > there as well. > > ? > GK > > > ----- Original Message ----- > From: Anup Setty > To: WebCatalog Talk > Sent: Thursday, November 15, 2001 12:11 PM > Subject: Re: Deleting associated records from 2 different databases > > > > If I understand your question correctly, it is simple, just > > have two delete statements one after another, > > > > [delte from db=catalog.txt&eqAKUdatarq=xxxx] > > > > [delete from db=products.txt&eqAKUdatarq=xxxx] > > > > HTH > > > > == Anup Setty > > > > > > ----- Original Message ----- > > From: Gary Krockover > > To: WebCatalog Talk > > Sent: Thursday, November 15, 2001 12:26 AM > > Subject: Deleting associated records from 2 different databases > > > > > > > Hey all, > > > > > > I'm searching through the archives now with little luck. > > > > > > Situation: I have 2 databases, catalog.txt and products.txt. The > > keyfield > > > for both databases is AKU. Each database has different fields other than > > the > > > related AKU and product info is shown with a search and a lookup on the > > 2nd > > > database. > > > > > > Question: Is it possible to remove the same AKU from both databases in > > one > > > stroke at the same time? Currently, the client has to delete the AKU > from > > > each database using different delete's. > > > > > > Thanks, > > > GK > > > > > > > > > ------------------------------------------------------------- > > > 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/ > > > ------------------------------------------------------------- > 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:
Have you tried using the [closedatabase tag after your [search] tag?= Anup----- Original Message ----- From: Gary Krockover To: WebCatalog Talk Sent: Thursday, November 15, 2001 1:38 AM Subject: Re: Deleting associated records from 2 different databases > Yeah, seems obvious, but it stops after the first delete. I have: > > Deleting AKU:[aku] from catalog.txt
> [delete db=catalog.txt&eqakudatarq=[url][aku][/url]] > Deleting AKU:[aku] from products.txt
> Deleting SKU(s):[search > db=products.txt&eqakudatarq=[aku]][founditems][sku],[showif > [index]\3]
[/showif][/founditems][/search]
> [delete db=products.txt&eqakudatarq=[url][aku][/url]] > > And the results showing from this page are: > Deleting AKU:38130 from catalog.txt > Deleting AKU: from products.txt > Deleting SKU(s): > > Physically checking the 2 databases shows that it is being deleted from the > first but not the 2nd. I've played with adding close/commit databases in > there as well. > > ? > GK > > > ----- Original Message ----- > From: Anup Setty > To: WebCatalog Talk > Sent: Thursday, November 15, 2001 12:11 PM > Subject: Re: Deleting associated records from 2 different databases > > > > If I understand your question correctly, it is simple, just > > have two delete statements one after another, > > > > [delte from db=catalog.txt&eqAKUdatarq=xxxx] > > > > [delete from db=products.txt&eqAKUdatarq=xxxx] > > > > HTH > > > > == Anup Setty > > > > > > ----- Original Message ----- > > From: Gary Krockover > > To: WebCatalog Talk > > Sent: Thursday, November 15, 2001 12:26 AM > > Subject: Deleting associated records from 2 different databases > > > > > > > Hey all, > > > > > > I'm searching through the archives now with little luck. > > > > > > Situation: I have 2 databases, catalog.txt and products.txt. The > > keyfield > > > for both databases is AKU. Each database has different fields other than > > the > > > related AKU and product info is shown with a search and a lookup on the > > 2nd > > > database. > > > > > > Question: Is it possible to remove the same AKU from both databases in > > one > > > stroke at the same time? Currently, the client has to delete the AKU > from > > > each database using different delete's. > > > > > > Thanks, > > > GK > > > > > > > > > ------------------------------------------------------------- > > > 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/ > > > ------------------------------------------------------------- > 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:
Draft Manual, Tutorial, and more (1997)
[TaxableTotal] - not working with AOL and IE (1997)
OBDC Support (1997)
Form Data, Back Button and 6.0.1 Patch (2005)
Forms Search Questions (1997)
logout after authenticated (2002)
random prob (2003)
Problem (1997)
RE: type 2 errors with ssl server (1997)
Undocumented tags and contexts (2000)
Updating product information (2002)
Silly problem!!! (2001)
[WebDNA] new install - documentation (2017)
WebCat2 beta 11 - new prefs ... (1997)
Re[3]: 2nd WebCatalog2 Feature Request (1996)
Register First (2000)
Sendmail strangie (2002)
Email Mac (2002)
Bill To - Ship To Information display (1997)
[URL] and [showif] or [hideif] comparisons (2003)