Escape curly brackets in command line

cdoloriert

Hi,

I've been trying to execute the following command:

iwodcmd start Monitor/datadeploy/integration/Assets_dd -k iwdd=storedproc -k iwdd-op=do-sql -k user-op=execute_my_procedure -k database=MonitorGermanyInt -k assetID={960F21B4-9785-4467-9469-46C7D8CFA80C} -k assetTypeID=2 -k assetPath=imported/Monitordotcom/images/lilies.jpg -k assetSize=51144

However, the curly braces for assetID argument doesn't seem to be working. The Asset data deploy file is bellow:

[PHP]










exec dbo.Mon_CheckAssetInfo '$assetID^', $assetTypeID^, '$assetPath^', $assetSize^







[/PHP]


I tried double quotes and single qoutes and \{85949894\}, but none of them worked.
When I checked the logs, I saw the following:


DBD: Deployment : storedproc
DBD: Database Vendor set to rdbms
DBD: Max Identifier length set to 128 characters.
DBD: **WARN**ubstituteParameters 104 Replacing undefined parameter $assetID with empty string
DBD: [Mon Sep 21 11:13:48 EDT 2009] Begin executing storedproc
DBD: Setting up consumer TDbAgent
DBD: Validating cached connection...
DBD: Cached connection OK
DBD: Connected to [MUM-SQL-TEST1:1433;databaseName=MonitorGermanyInt]
DBD: iwdd-op=do-sql
DBD: SQL : = exec dbo.Mon_CheckAssetInfo '', 2, 'imported/Monitordotcom/images/lilies.jpg', 51144
DBD: Update effected: 1 Rows
DBD: 1 row(s) affected.
DBD: Committing database [MUM-SQL-TEST1:1433;databaseName=MonitorGermanyInt]...

It gets replaced by the empty string.

Any suggestions on how to escape this special character?

Thanks in advance

Migrateduser

Have you tried just embedding the curly braces into your exec line instead of passing them in with the parameter?


exec dbo.Mon_CheckAssetInfo '{$assetID^}', $assetTypeID^, '$assetPath^', $assetSize^