trim from sql select statement solution
I have looked everywhere for this solution, but do not see it. Can not use "trim(at.name) as it gives an error = invalid column name Using "oracle.jdbc.driver.OracleDriver" sql.eachRow("select ...
Forum Discussion
May have quickly found my own solution.
1. Save to property
testRunner.testCase.setPropertyValue( "AssetType", "$row.name" )
2. Retrieve property and add trim to it. Seems to work.
def assetType = context.expand( '${#TestCase#AssetType}' ).trim()
log.info "|$assetType|"
Tue Jan 10 10:46:15 MST 2012:INFO:|MovieAsset|
1. Save to property
testRunner.testCase.setPropertyValue( "AssetType", "$row.name" )
2. Retrieve property and add trim to it. Seems to work.
def assetType = context.expand( '${#TestCase#AssetType}' ).trim()
log.info "|$assetType|"
Tue Jan 10 10:46:15 MST 2012:INFO:|MovieAsset|