[Gambas-user] MySQL Data

nigel at ...38... nigel at ...38...
Sun Jan 23 12:15:08 CET 2005


Eric,

Could you list your code - I have no problems with entering the characters listed in the datamanager or in the simple program that I use for testing the database component.

Nigel

> Message date : Jan 22 2005, 05:36 AM
> From : "Eric Damron" <edamron at ...776...>
> To : "Gambas Mail List" <gambas-user at lists.sourceforge.net>
> Copy to : 
> Subject : [Gambas-user] MySQL Data
> 
> 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
> 

-- 

Whatever you Wanadoo:
http://www.wanadoo.co.uk/time/

This email has been checked for most known viruses - find out more at: http://www.wanadoo.co.uk/help/id/7098.htm




More information about the User mailing list