On Sat, 10 Aug 2013, Johny Provoost wrote: > > Op 10-08-13 09:02, bill-lancaster schreef: > > Have seen a couple of posts that refer to this but can't quite understand > > the > > answer > > > > I have a database which conntains a string 'Queen's Head' > > > > so > > hResult = hConn.Exec("SELECT contacts.* FROM contacts WHERE Title = > > 'Queen's Head'") > > produces an error. > > > > How best to solve this? > > > > > > > > -- > > View this message in context: > > http://gambas.8142.n7.nabble.com/mysql-seach-string-contains-single-quote-tp42768.html > > Sent from the gambas-user mailing list archive at Nabble.com. > > > > ------------------------------------------------------------------------------ > > Get 100% visibility into Java/.NET code with AppDynamics Lite! > > It's a free troubleshooting tool designed for production. > > Get down to code-level detail for bottlenecks, with <2% overhead. > > Download for free and get started troubleshooting in minutes. > > http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk > > _______________________________________________ > > Gambas-user mailing list > > Gambas-user@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/gambas-user > > > > It's because Queen's Head has a ' in the string. > > I always use > Var="Queen's Head" > hResult=hConn.Exec("SELECT contacts.* FROM contacts WHERE Title=" > &"\"" & Var & "\"") > or > hResult=hConn.Exec("SELECT contacts.* FROM contacts WHERE Title=" & > Chr(34) & Var & Chr(34)) >
This is even shorter: hResult = hConn.Exec("SELECT contacts.* FROM contacts WHERE Title='Queen\\'s Head'") Since ' is meaningful in MySQL, you have to mask it with \ and since you do this in a Gambas string constant, you have to double the backslash. Regards, Tobi ------------------------------------------------------------------------------ Get 100% visibility into Java/.NET code with AppDynamics Lite! It's a free troubleshooting tool designed for production. Get down to code-level detail for bottlenecks, with <2% overhead. Download for free and get started troubleshooting in minutes. http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user