You are not logged in.
When using a custom query to Collect data from a Data Base table you will find any \ (backslash) in a value used in a variable in the query is simply ignored. For instance - Assume you have a entry in memory called 'name' which has the value 'fred\sally', and your custom query is 'select * from myTable where myColumn = ~#~name~#~'.
X-ServiceBroker will send the following to the SQL driver 'select * from myTable where myColumn = fredsally' and SQL will not find your "fred\sally' record.
To get around this you need to double up on the \ (backslash). One way to do this is to run the following Substitute rule on the field you would like to use in the custom query.
<sxi:Substitute>
<sxi:Find>\\</sxi:Find>
<sxi:Replace>\\</sxi:Replace>
</sxi:Substitute>
NO THE \\ IN BOTH THE FIND AND THE REPLACE IS NOT A TYPO.
Offline
Found this very helpful, thanks Kev!
Offline