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:
[subtotal] and others (1997)
[BoldWords] WebCat.acgib15Mac (1997)
CC Payment Processors (2007)
quick [middle] Q (2000)
SMSI FTP - calander system THANKS! (2002)
WCS Newbie question (1997)
Protect (1997)
WebCat b15 Mac plug-in (1997)
This list needs a digest: rant, rave... (1997)
OT JavaScript question (1999)
WebCat2b15MacPlugin - showing [math] (1997)
Date Formats (1997)
Not really WebCat (1997)
WebCat2 - Getting to the browser's username/password data (1997)
Lookup command (1998)
WC Bulletin Board Issue (2003)
RE: WebCat: Access denied, but why? (1997)
Custom WebCat Prefs ... (1997)
Quantity discount on some items? (2000)
emailer don't work (1998)