[Gambas-user] MySQL Data

[Chris Wilson]

I too would like to know how to deal with the '&' symbol.  However,
I'm not having a problem with 's. maybe because I'm converting
everything from the gui from unicode to western european.  For the &
symbol I'm just catching it then warning that they can't be entered.
Not exactly ideal.

Chris


On Fri, 21 Jan 2005 21:34:12 -0800, Eric Damron <edamron at ...776...> wrote:
> I'm writing a simple DVD collection database front end to MySQL in order
> to learn Gambas. I've noticed that when the user enters a title like
> "Hogan's Heros" an exception is thrown because of the apostrophe. I
> fixed this problem by sending all user inputs to a function that looks
> for this and returns "\'" when it finds one.
> 
> However, if the user enters a "&" the same thing happens even if I
> convert it to "\&" Does anyone know how to properly "sanitize" user
> input to MySQL?
> 
> Thanks.
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting
> Tool for open source databases. Create drag-&-drop reports. Save time
> by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc.
> Download a FREE copy at http://www.intelliview.com/go/osdn_nl
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>