The function you are talking about is Shell(string). But it's useless in this case, as it escapes spaces and other characters others than the needed to avoid sql injection techniques. -----Original Message----- From: tobias <tobiasb...@web.de> Date: Wed, 18 Jan 2012 14:49:29 To: mailing list for gambas users<gambas-user@lists.sourceforge.net> Reply-To: mailing list for gambas users <gambas-user@lists.sourceforge.net> Subject: Re: [Gambas-user] Database question
M. Cs. wrote: > Hi! > Is there any built in function in Gambas3 which can secure the > database connection from the errors caused by special characters? > > I have written functions for replacing the dangerous characters like > ', +, . and so on, but I'd like to know whether there is a way to make > queries secure from failures. > > Thanks! > > ------------------------------------------------------------------------------ > Keep Your Developer Skills Current with LearnDevNow! > 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-d2d > _______________________________________________ > Gambas-user mailing list > Gambas-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/gambas-user there was (once? in gb2) a Quote class in gb that implemented a Shell function used for quoting a string for use in a shell. do you mean something like that? (preventing sql injection?) btw, where has this class gone in gb3? ------------------------------------------------------------------------------ Keep Your Developer Skills Current with LearnDevNow! 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-d2d _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user ------------------------------------------------------------------------------ Keep Your Developer Skills Current with LearnDevNow! 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-d2d _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
