Re: Deleting associated records from 2 different databases
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 40105
interpreted = N
texte = 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/
Associated Messages, from the most recent to the oldest:
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/
Gary Krockover
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:
Execute Applescript (1997)
A Suggestion? (1998)
off-topic: SMS interface? (2001)
Looking for a host (1997)
[ShowIf] if the varieable exists (1998)
WebCat editing, SiteGuard & SiteEdit (1997)
[WebDNA] Connect to MS SQL (2013)
Writing [raw] to a file (2000)
Need formum software... (2003)
Hiding Email Addresses (2003)
Help formatting search results w/ table (1997)
remotely add + sign (1997)
[OT] 'Email this story to a friend' (2003)
Refreshing document (2000)
Preserving form data (1999)
More on the email templates (1997)
[WebDNA] WebDNA 8.6 Ubuntu 16.04 (2018)
Snake Bites (1997)
Re:Using WebMerchant Only? (1998)
WC2.0 Memory Requirements (1997)