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:
Triggers and SandBoxes - solved (2004)
WebDNA dying or ... ? (2005)
webcat nt (1997)
syntax question, not in online refernce (1997)
[WebDNA] An unknown error occured // Deadlock avoided (2011)
Nested search (1997)
Looking for a host (1997)
Grep Ampersands (2008)
security problem (1997)
Plugin or CGI or both (1997)
New Mac Public Beta Available (1997)
search results through frames (2000)
[WebDNA] Accepting Payments on Site (2013)
MacAuthorize Problem (1998)
Authenticate and IIS (1997)
[WebDNA] [hideif]'s not working in [sendmail] (2008)
To use GREP to boldface text (2003)
OT: RAID Options (2004)
Re:2nd WebCatalog2 Feature Request (1996)
RE: Languages (1997)