|
From: Federico B. <fe...@in...> - 2016-12-22 11:29:45
|
Yes, it works as expected now. Thanks for the quick fix! Il giorno gio 22 dic 2016 alle 0:32, Gerd Wagner <ger...@t-...> ha scritto: > Federico, > > this bug is fixed. The fix is available here: > > https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20161222_0014 > > Please give it a try. > > Thanks > Gerd > > Am 21.12.2016 um 15:14 schrieb Federico Bruni: >> Hi all >> >> I thought that I was still affected by a bug fixed in 2014: >> https://sourceforge.net/p/squirrel-sql/bugs/618/ >> >> Example: >> >> SELECT * FROM CARS >> WHERE NAME LIKE 'TOY%' /*IN (:var1, :var2, :var3) */ ; >> >> Instead of just executing the LIKE 'TOY%' statement, I'm prompted for >> the variables which are in a commented block and should be therefore >> ignored. >> >> I've looked at commit e785904a6563f90d34bc1fc570fe472259c9903a in git >> and found out that if I use '--' for commenting then sqlparam won't >> prompt for variables: >> >> SELECT * FROM CARS >> WHERE NAME LIKE 'TOY%'; -- IN (:var1, :var2, :var3); >> >> I don't know what's the recommended way to do this sort of things in >> SQL, but I wanted to share this with you. >> >> Thanks >> Federico >> >> >> >> >> >> >> ------------------------------------------------------------------------------ >> Developer Access Program for Intel Xeon Phi Processors >> Access to Intel Xeon Phi processor-based developer platforms. >> With one year of Intel Parallel Studio XE. >> Training and support from Colfax. >> Order your platform today.http://sdm.link/intel >> _______________________________________________ >> Squirrel-sql-users mailing list >> Squ...@li... >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >> |
