[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:

Re: [WebDNA] Wishlist: ignore whitespace in database changes (Stuart Tremain 2016) Re: [WebDNA] Wishlist: ignore whitespace in database changes (Patrick McCormick 2016) Was: [WebDNA] Wishlist: ignore whitespace in database changes - Now: WebDNA Data Model (dbrooke@euca.us 2016) [BULK] Re: [WebDNA] Wishlist: ignore whitespace in database changes (Alex McCombie 2016) Was: [WebDNA] Wishlist: ignore whitespace in database changes - Now: WebDNA Data Model (dbrooke@euca.us 2016) Re: [WebDNA] Wishlist: ignore whitespace in database changes (christophe.billiottet@webdna.us 2016) Re: [WebDNA] Wishlist: ignore whitespace in database changes (Stuart Tremain 2016) Re: [WebDNA] Wishlist: ignore whitespace in database changes (Brian Burton 2016) Re: [WebDNA] Wishlist: ignore whitespace in database changes (Kenneth Grome 2016) Re: [WebDNA] Wishlist: ignore whitespace in database changes (christophe.billiottet@webdna.us 2016) Re: [WebDNA] Wishlist: ignore whitespace in database changes (Brian Burton 2016) Re: [WebDNA] Wishlist: ignore whitespace in database changes (dbrooke@euca.us 2016) [WebDNA] Wishlist: ignore whitespace in database changes (Brian Burton 2016)

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:

My first WebCat site (2000) How Many SKU's is enough? (1997) Date subtraction (2002) [OT] Domain Name Scam (2000) For those of you not on the WebCatalog Beta... (1997) Transfer of data from Invoice to thank you templates (1998) Locking up with WebCatalog... (1997) Credit card processing - UK (1997) search engine friendly URLS (Mac) (1998) Some Questions (1997) WCf2 and nested tags (1997) [HIDEIF] inside [FOUNDITEM] (1997) Credit Card not accepted (1998) Hiding the URL(was Cart ID Duplication) (2001) [replaceChars] would be nice ... (1997) Suddenly can't see files... (2000) Line Endings (2003) WebCatalog host... (2000) # fields limited? (1997) Date search - yes or no (1997)