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:
Grep question [parsing variables] problem (2003)
Include vs. lookup? (1998)
show all problem (1997)
cannot delete last admin (1999)
WebCatalog 2.0 & WebDNA docs in HTML ... (1997)
Non-technical messages ... (1997)
Word wrapping (1997)
Behind the Scenes. . . (1998)
GuestBook example (1997)
Carts & Refering URLs (1997)
email program problem (1998)
Time code! (2002)
Variable prices and Formulas.db (1997)
WebDNA 4.5.1 Now Available [OT] (2003)
[BULK] [WebDNA] AJAX module (2012)
WCS Newbie question (1997)
WebCat2final1 crashes (1997)
HELP!? (2002)
PCS Frames (1997)
Re:add line item context and showitems (1998)