Windows registry entry (REG_SZ) with a comma

[Bob]

I am trying to set the timezone with a snippet as follows:

    "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\TimeZoneInformation"
      comment => "Set timezone to MST",
      database_operation => "create",
      database_rows => {
        ",REG_SZ,",
        "ActiveTimeBias,REG_DWORD,0x1a4",
        "Bias,REG_DWORD,0x1a4",
        "DaylightBias,REG_DWORD,0",
        "DaylightName,REG_SZ,'@tzres.dll,-201'",
        "DaylightStart,REG_BINARY,0",
        "DynamicDaylightTimeDisabled,REG_DWORD,0",
        "StandardBias,REG_DWORD,0",
        "StandardName,REG_SZ,'@tzres.dll,-202'",
        "StandardStart,REG_BINARY,0",
        "TimeZoneKeyName,REG_SZ,US Mountain Standard Time",
      },
      database_type => "ms_registry";

The issue is the following error:

   error: Registry row format should be NAME,REG_SZ,VALUE, not 'DaylightName,REG_SZ,'@tzres.dll,-201''

The issue is the value contains a comma character. I've tried a single quote to group it and I've tried escape() without luck. Any suggestions?

[Nick Anderson]

Bob <buha...@gmail.com> writes:

The issue is the following error:

error: Registry row format should be NAME,REG_SZ,VALUE, not 'DaylightName,REG_SZ,'@tzres.dll,-201''

The issue is the value contains a comma character. I've tried a single quote to group it and I've tried escape() without luck. Any suggestions?

Hi Bob,

The documentation for database_rows has a note that says "If a column value has a comma you can escape the comma with a backslash \.". Did you try that?

https://docs.cfengine.com/docs/master/reference-promise-types-databases.html#database_rows

– Nick Anderson | Doer of Things | (+1) 785-550-1767 | https://northern.tech

[Bob]

Thank you and my apologies. I really am trying to review the documentation before I ask.

[Nick Anderson]

Bob <buha...@gmail.com> writes:

> Thank you and my apologies. I really am trying to review the documentation before I ask.

It's fine, there is a /lot/ of documentation. And plausibly we need to
add cross references in various places.

--