Re: REPLACE and/or APPEND
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 41743
interpreted = N
texte = Try:[Replace db=sessions.db&etc,etc&Append=T]And drop the lookup, don't need it.GK> I want to add a record to a database (based on a session id) if it doesnot> 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? Here is my sad solution:>> [TEXT]found=[LOOKUP>db=sessions.db&value=[sessionid]&lookinfield=sessionid&returnfield=sessionid> ¬found=][/TEXT]> [SHOWIF [found]!]> [REPLACE> db=sessions.db&eqsessionidDATAreq=[sessionid]]info=[info][/REPLACE]> [/SHOWIF]> [HIDEIF [found]!]> [APPEND db=sessions.db]sessionid=[sessionid]&info=[info][/APPEND]> [/HIDEIF]>> Thanks>> -------------------------------------------------------------> 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:
Try:[Replace db=sessions.db&etc,etc&Append=T]And drop the lookup, don't need it.GK> I want to add a record to a database (based on a session id) if it doesnot> 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? Here is my sad solution:>> [text]found=[LOOKUP>db=sessions.db&value=[sessionid]&lookinfield=sessionid&returnfield=sessionid> ¬found=][/TEXT]> [SHOWIF [found]!]> [REPLACE> db=sessions.db&eqsessionidDATAreq=[sessionid]]info=[info][/REPLACE]> [/SHOWIF]> [HIDEIF [found]!]> [APPEND db=sessions.db]sessionid=[sessionid]&info=[info][/APPEND]> [/HIDEIF]>> Thanks>> -------------------------------------------------------------> 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/
Gary Krockover
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:
sort without the or a (1998)
WebCat editing, SiteGuard & SiteEdit (1997)
error -108 (1997)
Webstar 1.3.1 PPC (1997)
PSC recommends what date format yr 2000??? (1997)
docs for WebCatalog2 (1997)
RE: Problems with shopping cart (1997)
OSX 10.2.6/iTools 7.0/WebDNA 5.0 installation (2003)
(2000)
japanese characters (1997)
Cart Question (1998)
WebDNA & Apache 1.3.27 (2003)
Bug Report, maybe (1997)
2.1 bugs left over from beta cycle (1998)
vs (1997)
WebCatalog 2.1b4/Mac available (1997)
Moment of Thanks (1997)
SiteEdit NewFile.html ? (1997)
Too many lines too add in one go (2003)
all records returned. (1997)