On Wed, 2010-04-07 at 21:55 +0200, Fabien Bodard wrote: > 2010/4/7 Keith Clark <keithcl...@k-wbookworm.com>: > > On Wed, 2010-04-07 at 14:40 -0500, nando wrote: > >> Replace will work for quote and backslash > >> For double quote: > >> > >> doublequote$ is chr$(34) > >> Replace$(mystring, chr$(34), "\" & chr$(34) > >> > >> But, Benoit had an email of the nice solution. > >> -Fernando > > > > I did not understand that solution either. > > > > > > > > ------------------------------------------------------------------------------ > > Download Intel® Parallel Studio Eval > > Try the new software tools for yourself. Speed compiling, find bugs > > proactively, and fine-tune applications for parallel performance. > > See why Intel Parallel Studio got high marks during beta. > > http://p.sf.net/sfu/intel-sw-dev > > _______________________________________________ > > Gambas-user mailing list > > Gambas-user@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/gambas-user > > > > did you understand how subst() function work ijn gambas ?? > > mystring = subst("this is my &1 &2", "black", "dog") > > print mystring give : > > this my black dog > > &1 and &2 are replaced by subst param > > for the sql queries it work at the same ... but with an automatic escaping. > so the argument are corrected in backgroud by an excape function. > > > hresult = db.exec("select &1 From &2 where titi=&3", "titi", "tititable", 1) > Ok, I finally got it now!!!!!
Whew, that one took awhile to sink in! Thanks everyone for your help. Keith ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
