[Gambas-user] Database question

Sebi sebikul at ...626...
Wed Jan 18 16:35:41 CET 2012


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 <tobiasboe1 at ...20...>
Date: Wed, 18 Jan 2012 14:49:29 
To: mailing list for gambas users<gambas-user at lists.sourceforge.net>
Reply-To: mailing list for gambas users <gambas-user at 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 at 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 at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user


More information about the User mailing list