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:

Re2: frames & carts (1997) Final invoice problems (1998) [append] (1997) More on the email templates (1997) ShipTotal Yet Again (1998) [OT] Startin' sumthin' again - Python, anyone tried it? (2006) lookup (1998) The List is Changing (1997) Re:Emailer and encryption (1997) bug in [SendMail] (1997) pop up menu's (1998) Less than or equal to........ (1997) Help! WebCat2 bug (1997) [Was] silly question... (2003) Re:2nd WebCatalog2 Feature Request (1996) [WebDNA] Webdna, Css & ie (2011) verify online (1997) More on the email templates (1997) convert characters (2003) docs for WebCatalog2 (1997)