Re: [WebDNA] Wishlist: ignore whitespace in database changes
This WebDNA talk-list message is from 2016
It keeps the original formatting.
numero = 112944
interpreted = N
texte = 531A long time ago I suggested a preference we could set to "T" tomake WebDNA identify db fields by their prefixes. This might bethe easiest way for us to use such a system, assuming we controlour own field names, because we can instantly recognize the fieldtype by its name:n.fieldname =3D numberd.fieldname =3D datea.fieldname =3D alpha (or fieldname =3D alpha)In this simple system WebDNA would treat a fieldname that beginswith "n." as numeric and "d." as a date, but only when this newpreference is set to "T". The "a." prefix would be optional, andany field name not prefixed with "n." or "d." would be treated asalphabetical.---Another method of implementation might be to use a new ".type"file that is related to a specific db, similar to the way the".hdr" file is related to a specific db. For a loginCodes.dbthis new type file would be named "loginCodes.type".When this file exist in the same folder as its corresponding dbWebDNA would automatically identify the field types based on thesettings in this file. If the file does not exist or is not inthe same folder as the db, WebDNA would behave as it does now.---Either of these implementations will preserves the currentbehavior of WebDNA while adding a new capability for those whowish to use it. There are probably issues and limitations toconsider in either system, but at least this gives you a coupleideas to consider ...But first PLEASE add a "table=3D" parameter to listfields so we canuse it to create our own debugging code for WebDNA tables. I findit hard to believe that this feature does not already exist!Regards,Kenneth GromeWebDNA Solutionshttp://www.webdnasolutions.comWeb Database Systems and Linux Server AdministrationOn 08/31/2016 02:57 PM, christophe.billiottet@webdna.us wrote:> I personally believe this extra flexibility allows to deal with databas=e content the way we want, and allows to treat a single field either as a= date, a number or a text field, or even the tree types in a single page =of code.>=20> I think extra rigidity diminishes creativity, and what I like most in W=ebDNA is that it behave like a "chameleon" language. It is so flexible th=at you can do whatever you want with it, the way you want.>=20> I would be interested to read what others have to say about this reques=ted modification,>=20> - chris>=20>=20>=20>=20>=20>> On Aug 31, 2016, at 20:08, Brian Burton
wrote:>>>> Over the years I=E2=80=99ve been bending WebDNA to my will. I=E2=80=99=ve more or less successfully implemented the view and controller ideology= of an MVC framework in WebDNA, and am getting ever closer to doing the w=ork to get data models working in webDNA. It=E2=80=99s so frustrating in =2016 to not be able to tag a field in a database as unique or numeric and= let the language deal with it for you when you interact with the databas=e. I recently wasted more time then I care to admit to making [delete db=3D=somedb&leIDdata=3D10000] work because i forgot to add &IDtype=3Dnum to th=e code.>=20>=20>=20> ---------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us> Bug Reporting: support@webdna.us>=20---------------------------------------------------------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:
531A long time ago I suggested a preference we could set to "T" tomake WebDNA identify db fields by their prefixes. This might bethe easiest way for us to use such a system, assuming we controlour own field names, because we can instantly recognize the fieldtype by its name:n.fieldname =3D numberd.fieldname =3D datea.fieldname =3D alpha (or fieldname =3D alpha)In this simple system WebDNA would treat a fieldname that beginswith "n." as numeric and "d." as a date, but only when this newpreference is set to "T". The "a." prefix would be optional, andany field name not prefixed with "n." or "d." would be treated asalphabetical.---Another method of implementation might be to use a new ".type"file that is related to a specific db, similar to the way the".hdr" file is related to a specific db. For a loginCodes.dbthis new type file would be named "loginCodes.type".When this file exist in the same folder as its corresponding dbWebDNA would automatically identify the field types based on thesettings in this file. If the file does not exist or is not inthe same folder as the db, WebDNA would behave as it does now.---Either of these implementations will preserves the currentbehavior of WebDNA while adding a new capability for those whowish to use it. There are probably issues and limitations toconsider in either system, but at least this gives you a coupleideas to consider ...But first PLEASE add a "table=3D" parameter to listfields so we canuse it to create our own debugging code for WebDNA tables. I findit hard to believe that this feature does not already exist!Regards,Kenneth GromeWebDNA Solutionshttp://www.webdnasolutions.comWeb Database Systems and Linux Server AdministrationOn 08/31/2016 02:57 PM, christophe.billiottet@webdna.us wrote:> I personally believe this extra flexibility allows to deal with databas=e content the way we want, and allows to treat a single field either as a= date, a number or a text field, or even the tree types in a single page =of code.>=20> I think extra rigidity diminishes creativity, and what I like most in W=ebDNA is that it behave like a "chameleon" language. It is so flexible th=at you can do whatever you want with it, the way you want.>=20> I would be interested to read what others have to say about this reques=ted modification,>=20> - chris>=20>=20>=20>=20>=20>> On Aug 31, 2016, at 20:08, Brian Burton wrote:>>>> Over the years I=E2=80=99ve been bending WebDNA to my will. I=E2=80=99=ve more or less successfully implemented the view and controller ideology= of an MVC framework in WebDNA, and am getting ever closer to doing the w=ork to get data models working in webDNA. It=E2=80=99s so frustrating in =2016 to not be able to tag a field in a database as unique or numeric and= let the language deal with it for you when you interact with the databas=e. I recently wasted more time then I care to admit to making [delete db=3D=somedb&leIDdata=3D10000] work because i forgot to add &IDtype=3Dnum to th=e code.>=20>=20>=20> ---------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us> Bug Reporting: support@webdna.us>=20---------------------------------------------------------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.
Kenneth Grome
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:
Error.html (1997)
Suffix Mapping (1997)
New Mac Emailer... (1997)
TCPConnect / Current Temperature (2004)
Database Helper missing? (2000)
A question on sub-categories (1997)
Re:no [search] with NT (1997)
[/application] error? (1997)
[WebDNA] WebDNA 7 (2011)
[writefile] (1997)
Re2: AAgghh!! Help, please. SSL strikes again. (1997)
NT requires capitalized append? (2000)
Version f1 status (1997)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
Re[2]: Using [Include] Context (1999)
Searching multiple Databases (1997)
OPEN MARKET PATENTS SOUND ECOMMERCE ALARM (1998)
japanese characters (1997)
b18 problem on NT 4.0 (1997)
WebCat2: Items xx to xx shown, etc. (1997)