[Gambas-user] MySQL query problems with apostropies

[Keith Clark]

> 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)
> 
Yes, but I don't understand how that will help me with my problem.  I
could have multiple ' and " and / characters all throughout a very
lengthy string.  Do I have to search for those and break them up?