[Gambas-user] DB.Quote() doesn't quotes apostrophes

richard terry rterry at ...1823...
Mon Jan 23 05:57:19 CET 2012


On Monday 23 January 2012 10:15:07 M. Cs. wrote:
> I have a dinamically created query text. I don't know the number of
> parameters passed to the DB.Exec, so I cannot use &1,&2,... form. I
> need to use the DB.Quote()
> My problem is: If I have a string
> mystring="Blackmore's Night",
> the DB.Quote(mystring) won't quote the ', so the query will crash. In
> fact I'm getting query string
> SELECT * FROM CATALOGS WHERE VName='Blackmore's Night'....
> It occurs with sqlite database.
> Is there any solution for that?


In postgres I'd use this "$$Blackmore's NIght$$"

Haven't followed the thread so don't know what db you are using
Apologies if this is wide of the mark.

richard


> 
> Thanks!
> 
> Csaba
> 
> ---------------------------------------------------------------------------
> --- Try before you buy = See our experts in action!
> The most comprehensive online learning library for Microsoft developers
> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
> Metro Style Apps, more. Free future releases when you subscribe now!
> http://p.sf.net/sfu/learndevnow-dev2
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
> 




More information about the User mailing list