Re: Deleting associated records from 2 different databases
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 40106
interpreted = N
texte = I fixed it, not sure why, but I had to reverse the order of the deletes. The preceding page searches on catalog.txt for the AKU, then the next page deletes that AKU from products.txt and then catalog.txt.With the deletes in the other order, it was stopping after deleting only from catalog.txt, I'm assuming because of the search somehow.Thanks, GK ----- Original Message ----- From: Anup Setty
To: WebCatalog Talk Sent: Thursday, November 15, 2001 12:37 PM Subject: Re: Deleting associated records from 2 different databases > 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/ ------------------------------------------------------------- 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:
I fixed it, not sure why, but I had to reverse the order of the deletes. The preceding page searches on catalog.txt for the AKU, then the next page deletes that AKU from products.txt and then catalog.txt.With the deletes in the other order, it was stopping after deleting only from catalog.txt, I'm assuming because of the search somehow.Thanks, GK ----- Original Message ----- From: Anup Setty To: WebCatalog Talk Sent: Thursday, November 15, 2001 12:37 PM Subject: Re: Deleting associated records from 2 different databases > 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/ ------------------------------------------------------------- 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:
Ooops..Broswer Info.txt (was Web*SSL and WebCatalog) (1997)
[WebDNA] Graphite Forum (2009)
Help- Spam Bots are spamming my site. (2007)
ErrorLog with Linux? (2000)
searchable list archive (1997)
shoppingcart reload qty (1997)
Sense/Disallow HTML tags during $Append (1997)
Robots fill event log (1997)
Help name our technology! (1997)
Errata: WCS Newbie question (1997)
WCS Newbie question (1997)
[convertChars] and HTML Tags (1997)
Three new problems ... (1997)
How is it done? (1998)
WebCat2 - [include] tags (1997)
math problems (2000)
UPS charges (2000)
Another Large Database Questions (1997)
RE: OK, here goes... (1997)
partial credits (2003)