Re: Deleting associated records from 2 different databases

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 40114
interpreted = N
texte = oops!! I had spelling mistake as well as syntax ;( Just got back from lunch break, been playing pool at lunch!== Anup----- Original Message ----- From: Brian Fries To: WebCatalog Talk Sent: Thursday, November 15, 2001 1:43 PM Subject: Re: Deleting associated records from 2 different databases > Looks like Anup's fingers were a bit loose... fixing the syntax: > > [delete db=catalog.txt&eqAKUdata=xxx] > [delete db=products.txt&eqAKUdata=xxx] > > - brian > > At 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/ ------------------------------------------------------------- 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:

    
  1. Re: Deleting associated records from 2 different databases (Brian Fries 2001)
  2. Re: Deleting associated records from 2 different databases (Anup Setty 2001)
  3. Re: Deleting associated records from 2 different databases (Anup Setty 2001)
  4. Re: Deleting associated records from 2 different databases (Anup Setty 2001)
  5. Re: Deleting associated records from 2 different databases (Gary Krockover 2001)
  6. Re: Deleting associated records from 2 different databases (Gary Krockover 2001)
  7. Deleting associated records from 2 different databases (Gary Krockover 2001)
oops!! I had spelling mistake as well as syntax ;( Just got back from lunch break, been playing pool at lunch!== Anup----- Original Message ----- From: Brian Fries To: WebCatalog Talk Sent: Thursday, November 15, 2001 1:43 PM Subject: Re: Deleting associated records from 2 different databases > Looks like Anup's fingers were a bit loose... fixing the syntax: > > [delete db=catalog.txt&eqAKUdata=xxx] > [delete db=products.txt&eqAKUdata=xxx] > > - brian > > At 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/ ------------------------------------------------------------- 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:

Separate SSL Server (1997) Sort Order on a page search (1997) quick setheader questions... (2000) WebCatalog for guestbook ? (1997) Webcat no longer supported? (2006) easiest way to check for a non-alphanumeric character? (2000) Looping control (1997) formvars available in formulas.db? (2000) Emailer S-L-O-W-N-E-S-S (2002) Unix Webcat Permission - Suggestions (2000) 'Document Contains No Data' (1999) mass mailing (1998) MacAuthorize hub, no modal password dialog? (1997) Document Contains No Data! (1997) 2.0 Info (1997) Format of Required fields error message (1997) [browsername] not working? (1997) BR (1997) Not really WebCat (1997) version 2 for NT (1997)