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:

HELP WITH DATES (1997) WebStar SSL and WebCatalog conflict? (1999) Listfiles not listing mounted volume (2002) Where's Cart Created ? (1997) PCS Frames (1997) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) Scoping rules in WebDNA 4.0 (2000) Authorize.net? (2003) [WebDNA] My SQL will not Connect (2020) WebCatalog on Solaris? (2000) Associative lookup style? (1997) [WebDNA] Filtering exact numbers (2008) rn doesn't work on date fields (1998) writefile and emailer (2002) multi-paragraph fields (1997) reserved characters for field names? (1998) Linux ODBC and the ODBC Bridge (2000) ShowIf & HideIf Question? (1998) &fieldsdir=ra truely random?? (2000) Sku numbers (1997)