Re: [Openaaq-discuss] using apostrophe or backslash in AAQ
Status: Beta
Brought to you by:
a-non-mouse
From: Michael M. <mi...@wi...> - 2003-07-25 19:41:28
|
Alex Polkovsky wrote: >I'm making plans early this fall to change AAQ to use the DBI quote >method to escape special characters in strings. This will fix problems >caused by apostrophe or backslash being present in the entered text. > >At the moment the only way to use these characters in AAQ is to enter \' >or \\ respectively. Double quote (") is handled correctly at present. > >This update will remove some superfluous and amateurish code on my part. > >Details on the quote() method are at: >http://www.mysql.com/doc/en/Perl_DBI_Class.html > Another approach would be to use parameter binding. If you use parameter binding then I think you don't need to call the quote function at all and NULLs will be handled with easy as well. I can give you some example later if you like. > > >Alex. > > >------------------------------------------------------- >This SF.Net email sponsored by: Free pre-built ASP.NET sites including >Data Reports, E-commerce, Portals, and Forums are available now. >Download today and enter to win an XBOX or Visual Studio .NET. >http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01 >_______________________________________________ >Openaaq-discuss mailing list >Ope...@li... >https://lists.sourceforge.net/lists/listinfo/openaaq-discuss > > > |