[WebDNA] Wishlist: ignore whitespace in database changes
This WebDNA talk-list message is from 2016
It keeps the original formatting.
numero = 112936
interpreted = N
texte = 523While most database record changes (append/replace) are pretty simple, =some of them can get pretty complex, and the code gets ugly fast.=20this is actual code I wrote this morning:[append db=3D^data/dbstats.db&autonumber=3Did][!]=[/!]dbpath=3D[$path]&dbname=3D[$name]&firstseen=3D[$timestamp]&lastseen=3D=[$timestamp]&opencount=3D1&changecount=3D0[!]=[/!]&Fcv=3D[$fields]&Fpv=3D&Fdh=3D[$fields]&Fdhts=3D[$timestamp]&Fdl=3D[$f=ields]&Fdlts=3D[$timestamp]&Fmh=3D[$fields]&Fmhts=3D[$timestamp][!]=[/!]&Rcv=3D[$records]&Rpv=3D&Rdh=3D[$records]&Rdhts=3D[$timestamp]&Rdl=3D[=$records]&Rdlts=3D[$timestamp]&Rmh=3D[$records]&Rmhts=3D[$timestamp][!]=[/!]&Mcv=3D[$memory]&Fpv=3D&Mdh=3D[$memory]&Mdhts=3D[$timestamp]&Mdl=3D[$m=emory]&Mdlts=3D[$timestamp]&Mmh=3D[$memory]&Mmhts=3D[$timestamp]][!]=[/!]&Dcv=3D[$filesize]&Dpv=3D&Ddh=3D[$filesize]&Ddhts=3D[$timestamp]&Ddl=3D=[$filesize]&Ddlts=3D[$timestamp]&Dmh=3D[$filesize]&Dmhts=3D[$timestamp][!]=[/!][/append]all the comment tags look horrible and are onerous to type and =occasionally get messed up, which adds time to debug.=20What if we had an ignorewhitespace=3DT modifier for append and replace =functions?=20[append db=3D^data/dbstats.db&autonumber=3Did&ignorewhitespace=3DT]dbpath=3D[$path]&dbname=3D[$name]&firstseen=3D[$timestamp]&lastseen=3D[$timestamp]&opencount=3D1&changecount=3D0=E2=80=A6 etc ...[/append]Heck, even the ampersands seem superfluous at that point, but I don=E2=80=99=t want to upset the purists. :P=20If one desires to store away line feeds, they could just [url] the value =being stored (which should done anyway) and problem solved.Brian B. Burton---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list
.To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us.
Associated Messages, from the most recent to the oldest:
523While most database record changes (append/replace) are pretty simple, =some of them can get pretty complex, and the code gets ugly fast.=20this is actual code I wrote this morning:[append db=3D^data/dbstats.db&autonumber=3Did][!]=[/!]dbpath=3D[$path]&dbname=3D[$name]&firstseen=3D[$timestamp]&lastseen=3D=[$timestamp]&opencount=3D1&changecount=3D0[!]=[/!]&Fcv=3D[$fields]&Fpv=3D&Fdh=3D[$fields]&Fdhts=3D[$timestamp]&Fdl=3D[$f=ields]&Fdlts=3D[$timestamp]&Fmh=3D[$fields]&Fmhts=3D[$timestamp][!]=[/!]&Rcv=3D[$records]&Rpv=3D&Rdh=3D[$records]&Rdhts=3D[$timestamp]&Rdl=3D[=$records]&Rdlts=3D[$timestamp]&Rmh=3D[$records]&Rmhts=3D[$timestamp][!]=[/!]&Mcv=3D[$memory]&Fpv=3D&Mdh=3D[$memory]&Mdhts=3D[$timestamp]&Mdl=3D[$m=emory]&Mdlts=3D[$timestamp]&Mmh=3D[$memory]&Mmhts=3D[$timestamp]][!]=[/!]&Dcv=3D[$filesize]&Dpv=3D&Ddh=3D[$filesize]&Ddhts=3D[$timestamp]&Ddl=3D=[$filesize]&Ddlts=3D[$timestamp]&Dmh=3D[$filesize]&Dmhts=3D[$timestamp][!]=[/!][/append]all the comment tags look horrible and are onerous to type and =occasionally get messed up, which adds time to debug.=20What if we had an ignorewhitespace=3DT modifier for append and replace =functions?=20[append db=3D^data/dbstats.db&autonumber=3Did&ignorewhitespace=3DT]dbpath=3D[$path]&dbname=3D[$name]&firstseen=3D[$timestamp]&lastseen=3D[$timestamp]&opencount=3D1&changecount=3D0=E2=80=A6 etc ...[/append]Heck, even the ampersands seem superfluous at that point, but I don=E2=80=99=t want to upset the purists. :P=20If one desires to store away line feeds, they could just [url] the value =being stored (which should done anyway) and problem solved.Brian B. Burton---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us.
Brian Burton
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:
User/pass with tcpconnect (2000)
[WebDNA] CICADA (2008)
errormessages.db (1997)
[WebDNA] Listfields in an input environment (2018)
Extended [ConvertChars] (1997)
[ModDate] & [ModTime] ? (1997)
File Upload (1997)
can you use [middle] in a search? (2001)
Include a big block of text (1997)
decrypt trouble - solved (2006)
Bug Report, maybe (1997)
Seeking NT Mail Server Experiences (1998)
searching by part of the date information (1999)
Searching using numbers (1998)
NT BETA BUG???? (1997)
RE: Multithreading of [replace] (1999)
Problem (1997)
If Empty ? (1997)
Search returns all, not 20 (1997)
ListFiles Sorting (2000)