Re: [Squirrel-sql-users] sqlparam plugin asks for /* */ commented variables

[Gerd W. <ger...@t-...>]

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
>