Hi Robert, you are so right about the $$ a lot of modules uses it, prescription, lab requests, depot... it's really a dark chapter..
gj. On 2010-09-21 8:49.MD, Robert Meggle wrote: > Hi Muthu, > > We are now on the level where all had started of care2x nearly 10 years > ago. Since that time that peace of code had not been touched. But you're > right, the "_" will be escaped by MySQL and the interesting thing is > that somehow it had been worked now since years. > > Another aspect, especially on that ground.level.zero: The idea to store > that kind of global settings in a table like we are discussing it now is > really ok, but we can discuss the naming convention of it. But the way > how it is used by $$ use of var.... look: > http://www.php.net/manual/en/language.variables.variable.php > > That is a dark chapter of php how to (mis)use variables. Normally you > should read it, understand it, and -please- forget it and never use it! > > Robert > > > Am Dienstag, den 21.09.2010, 23:19 +0530 schrieb Ap.Muthu: >> Hi Robert, >> >> That's a good one. >> >> I did notice that in many parts of the code the global config variable was >> selectively filtered using "person_%". In MySQL, the "_" should be escaped >> as otherwise it means any characters wildcard. The existing filter will >> choose "personell" and "person_" as well! I do not know if the "person\_%" >> will work as an argument in the function but it certainly works in MySQL >> directly. At the moment it is not affecting any working by having a few more >> unfiltered variables getting in. >> >> Regards, >> Ap.Muthu >> >>> Hi, >>> >>> just one note on 6779, there was one value missing in >>> care_config_global. Can be added by: >>> >>> INSERT INTO care_config_global VALUES ('person_insurance_1_nr_hide', >>> '1', NULL, '', '', '', 00000000000000, '', '0000-00-00 00:00:00'); >>> >>> Robert >> >> >> ------------------------------------------------------------------------------ >> Start uncovering the many advantages of virtual appliances >> and start using them to simplify application deployment and >> accelerate your shift to cloud computing. >> http://p.sf.net/sfu/novell-sfdev2dev >> _______________________________________________ >> Care2002-developers mailing list >> Care2002-developers@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/care2002-developers ------------------------------------------------------------------------------ Start uncovering the many advantages of virtual appliances and start using them to simplify application deployment and accelerate your shift to cloud computing. http://p.sf.net/sfu/novell-sfdev2dev _______________________________________________ Care2002-developers mailing list Care2002-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/care2002-developers