Re: Deleting associated records from 2 different databases
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 40116
interpreted = N
texte = Looks like Anup's fingers were a bit loose... fixing the syntax:[delete db=catalog.txt&eqAKUdata=xxx][delete db=products.txt&eqAKUdata=xxx]- brianAt 1:11 PM 11/15/2001, Anup Setty wrote:>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/-- <= Brian C. Fries, BrainScan Software http://www.brainscansoftware.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:
Looks like Anup's fingers were a bit loose... fixing the syntax:[delete db=catalog.txt&eqAKUdata=xxx][delete db=products.txt&eqAKUdata=xxx]- brianAt 1:11 PM 11/15/2001, Anup Setty wrote:>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/-- <= Brian C. Fries, BrainScan Software http://www.brainscansoftware.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/
Brian Fries
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:
Create Folder Question... (2000)
unitshipcost vs shipcosts (1997)
Emailer setup (1997)
two unique banners on one page (1997)
Help! WebCat2 bug (1997)
Signal Raised Error (1997)
40,000+ items = mutiple dbs? (1999)
OT: RAID Options (2004)
WebDelivery downloads alias, not original ? (1997)
Setting up WebCatalog with Retail Pro data (1996)
Locking up with WebCatalog... (1997)
Word Break (1999)
WebDNA v5 Array Q (2003)
emailer (1997)
RE: ANother SHOWIF problem (1997)
Line Feed Character Appended (1998)
Searching (2004)
t or f (1997)
Country & Ship-to address & other fields ? (1997)
Math inside [showif] (1998)