Re: REPLACE and/or APPEND

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 41745
interpreted = N
texte = >I want to add a record to a database (based on a session id) if it does not >already exist, otherwise I just want to update it. It seems I am going the >long way about this. Can't I get REPLACE to do it in one line of WebDNA >code?Append=T in a REPLACE context is your friend:[REPLACE db=sessions.db&eqsessionidDATAreq=[sessionid]&Append=T]info=[info][/REPLACE] -- ************************************************************* Christer Olsson Stora Nygatan 21 Phone +46 40 791 50 Ljusa Idéer AB S-211 37 Malmoe Fax +46 40 97 99 77 Sweden http://www.ljusaideer.se------------------------------------------------------------- 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: REPLACE and/or APPEND (Christer Olsson 2002)
  2. Re: REPLACE and/or APPEND (Jesse Williams-Proudman 2002)
  3. Re: REPLACE and/or APPEND (Gary Krockover 2002)
  4. Re: REPLACE and/or APPEND (Chris List Recipient 2002)
  5. Re: REPLACE and/or APPEND (Pedro Rivera 2002)
  6. Re: REPLACE and/or APPEND (Jesse Williams-Proudman 2002)
  7. REPLACE and/or APPEND (Chris List Recipient 2002)
>I want to add a record to a database (based on a session id) if it does not >already exist, otherwise I just want to update it. It seems I am going the >long way about this. Can't I get REPLACE to do it in one line of WebDNA >code?Append=T in a REPLACE context is your friend:[REPLACE db=sessions.db&eqsessionidDATAreq=[sessionid]&Append=T]info=[info][/REPLACE] -- ************************************************************* Christer Olsson Stora Nygatan 21 Phone +46 40 791 50 Ljusa Idéer AB S-211 37 Malmoe Fax +46 40 97 99 77 Sweden http://www.ljusaideer.se------------------------------------------------------------- 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/ Christer Olsson

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:

WebCat & WebTen (1997) Bug with sendmail under RedHat (2006) Search and Change (2003) problems with 2 tags (1997) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997) make updates in a temporary database (2004) Re[2]: Wierd problem with 3.08 WIN Version (2000) Exclude by date - multiple (1997) Non-Cart Files in Shopping Cart Folder (1997) [ShowNext] (2007) WebCat2.0 acgi vs plugin (1997) WebCat B13 Mac CGI -- Frames question (1997) WebCatalog f2 Installation (1997) Webmerchant (1999) Large founditems loops (2000) What port is Email on ? (2000) Why did this copyfile stop working? (2004) Banner DNA (1997) website pro trouble (1998) [OT] WebDNA and MyODBC (2003)