Forum Discussion
omatzura
17 years agoSuper Contributor
Hi Manish,
hmm.. I think this should be viewed as a bug (ie that the expansion syntax is returned and not an empty string).. can you somehow in your sql-statement add handling of this? (I vaguely remember SQL Server had an ISNULL statement that allowed you to return a default value for null columns)..
Also, if you dont want the empty elements to show up in your request when there is no value, you may want to extend your select to include the xml-element;
SELECT "" + name + " " FROM ...
and in your request replace
${DataSource#name}
with
${DataSource#name}
Hope this helps!
regards,
/Ole
eviware.com
hmm.. I think this should be viewed as a bug (ie that the expansion syntax is returned and not an empty string).. can you somehow in your sql-statement add handling of this? (I vaguely remember SQL Server had an ISNULL statement that allowed you to return a default value for null columns)..
Also, if you dont want the empty elements to show up in your request when there is no value, you may want to extend your select to include the xml-element;
SELECT "
and in your request replace
with
${DataSource#name}
Hope this helps!
regards,
/Ole
eviware.com