Re: Add to a field

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 16450
interpreted = N
texte = At 8:58 AM -0800 3/6/98, bob is rumored to have typed: > Is there an easy way to add information to a field. ie I want to add a > carriage return and a date each time someone checks in. I do not want to > replace their information. > > My real goal here is that each time I bill a customers account I get a > invoice num and date into their respective database fields. I am going to > be billing on a massive scale so I cannot access each record individually. > > My logic here is failing me.Do a [LOOKUP] inside a [REPLACE].[REPLACE db=MYDB.db&eqSKUdatarq=[SKU]]DATES=[LOOKUP db=MYDB.db&value=[sku]&lookinfield=sku&returnfield=dates] 03/05/1998[/REPLACE]The [LOOKUP] is executed before the [REPLACE], so it'll replace the DATES entry with the dates entry plus some extra info. I think that should do it.MichaelMichael Winston *By Phone!: (503)/652/8815 x341 Internet Coordinator *By e-mail!: michaelw@dhorse.com Dark Horse Comics, Inc. *By web!: http://www.dhorse.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Add to a field (John Hill 1998)
  2. Re: Add to a field (Michael Winston 1998)
  3. Re: Add to a field (bob 1998)
  4. Re: Add to a field (bob 1998)
  5. Re: Add to a field (Michael Winston 1998)
  6. Re: Add to a field (John Hill 1998)
  7. Add to a field (bob 1998)
At 8:58 AM -0800 3/6/98, bob is rumored to have typed: > Is there an easy way to add information to a field. ie I want to add a > carriage return and a date each time someone checks in. I do not want to > replace their information. > > My real goal here is that each time I bill a customers account I get a > invoice num and date into their respective database fields. I am going to > be billing on a massive scale so I cannot access each record individually. > > My logic here is failing me.Do a [lookup] inside a [replace].[REPLACE db=MYDB.db&eqSKUdatarq=[SKU]]DATES=[LOOKUP db=MYDB.db&value=[sku]&lookinfield=sku&returnfield=dates] 03/05/1998[/REPLACE]The [lookup] is executed before the [replace], so it'll replace the DATES entry with the dates entry plus some extra info. I think that should do it.MichaelMichael Winston *By Phone!: (503)/652/8815 x341 Internet Coordinator *By e-mail!: michaelw@dhorse.com Dark Horse Comics, Inc. *By web!: http://www.dhorse.com/ Michael Winston

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:

caching -check- (2001) Up and running ... at last !! (1997) Where's Cart Created ? (1997) 404s - Apache vs. WebDNA (2008) international time (1997) How true is this? (1999) Separate SSL Server (1997) [showif]'s inside [search] params? (2000) SiteGuard Admin Feature ? (1997) expired beta (1997) [Sum] function? (1997) Catalogs and W* (1996) Stinkin' [Referrer] (1998) Retrieve deleted files (2001) Write to the desktop? (2002) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) Hard Questions ? (1997) F3 crashing server (1997) problem with applets embedded in tpl files (1997) Lost and Recovered. (1998)