1. 

   eugfri, Member

   hi,

   I have exactly same issue as in this thread:
   https://mydbr.com/forums/topic.php?id=1896#post-5363

   But i don't see what the resolution was.
   I have parameter with "&" in it:

   SELECT 'dbr.report', 'sp_DBR_CustomerContact_new', 'newcontact[]', 'inCompanyName=(REPLACE(vCompanyName))';

   and I get the error msg in the subj.
   I have tried this:

   SELECT 'dbr.report', 'sp_DBR_CustomerContact_new', 'newcontact[]', 'inCompanyName=(REPLACE(vCompanyName,''&'',''\&''))';

   This seems to go through and I don't get the error, but then seems like i need to handle escaped & in my param value inside of my sp_DBR_CustomerContact_new.

   Is there better solution to the issue?

   Thanks!
2. 

   myDBR Team, Key Master

   Hi,
   we do not seem to be able to replicate it. Could you check that you are running the latest version / build. There should be no need to use REPLACE (which would not work anyways as it's inside a string).

   Syntax:

   SELECT 'dbr.report', 'sp_DBR_CustomerContact_new', 'newcontact[]', 'inCompanyName=(vCompanyName)';

   should work just fine assuming the vCompanyName is a parameter to the main report itself and not a variable as the name would suggest.

   If the problem persists, please open a support ticket with SQL export of your report.
   --
   myDBR Team
3. 

   eugfri, Member

   Got this sorted, thank you!

Reply

You must log in to post.