Escaping special characters in Templates?

[Stew Stryker]

I'm trying to create a template that includes a variable with a default value that has a comma in it.

The help file says:

If you want to use special characters (like comma

 

[Marco Kalter]

We'll add an example in the next version.

 

[Stew Stryker]

I guess it shouldn't be surprising that I'm still struggling with this feature?

But this time I think I've found a bug???

I'd like to include a template option that includes special characters and make it the default option, like this:

GRANT [Grant rights=*"SELECT, INSERT, UPDATE, DELETE", SELECT, INSERT, UPDATE, DELETE, ...] ON [table name] TO [grantee];

Now you can argue that this shouldn't be the default value, but should I still be able to make this first option be the default? Because PSD (7.1.4) gets messed up by the syntax above. But if I leave off the "*", it shows the special string "SELECT, INSERT, UPDATE, DELETE" as expected.

Thanks,

Stew

 

[Marco Kalter]

You should place the * inside the quotes:

GRANT [Grant rights="*SELECT, INSERT, UPDATE, DELETE", SELECT, INSERT, UPDATE, DELETE, ...] ON [table name] TO [grantee];