I didn't notice this earlier but for some reason it looks like the query parameter functionality is broken for me when editing a query.
If I run this query from the edit view
declare @title nvarchar(50) = ##title:string##
print '|'+ @title +'|'
the result is, if I enter test in the title field,
|,test|
Where does that comma at the start come from?
Strangely enough if I simply run that same query from the permalink all works as expected, no comma is added.
If I remove the type indicator like so:
declare @title nvarchar(50) = ##title##
print '|'+ @title +'|'
I'm greeted with an error:
Incorrect syntax near ','. Must declare the scalar variable "@title".
enclosing the parameter in quotes fixes that but then my result is the same as previous, I get an extra comma.
If I added the type again while the query parameter is within quotes like so:
declare @title nvarchar(50) = '##title:string##'
print '|'+ @title +'|'
I'm back at the previous error.
I tried to move the query parameter out of the declare
declare @title nvarchar(50)
set @title = ##title:string##
but that didn't help.
I can reproduce this in both IE11 and Google Chrome.
For the time being I'll do a replace(@title, ',','')
.
If this is indeed a bug, can this be fixed, please?