This topic is locked
[SOLVED]

SQL Variable :master doesn't work if my field name has space

9/29/2025 02:42:42
PHPRunner General questions
J
jacktonghk authorDevClub member

The SQL variable :master works if my field name does not contain any space, e.g. :master.CustomerID, however, I cannot make it work if my field name is [Customer ID]. I am using PHP runner 11 and sql server 2016

Sergey Kornilov admin 9/29/2025

For field names with spaces or other bad characters use :{field name} syntax. Specifically in your case use :{master.Customer ID}

And, of course, this is just another reminder, why you should not be using spaces in field names.

J
jacktonghk authorDevClub member 9/29/2025

Thanks Sergey!!