03-26-2014 10:49 AM
Just wondering if anyone can point me in the right direction with the SQL source on the mashup control in Version 8.1.
I would like to use this control to grab data from an external database then filter the content using a field within the currently focussed Account.
So far I have been able to bring back all the records of the connected database, but cant seem to get it to use a filter or parameter.
Any help wouyld be greatly appreciated.
03-28-2014 12:16 AM
Use question marks for parameter placeholders in your SQL query and remember that defined parameter values are expressions, which means strings need to wrapped in single quotes.
Connection String: Provider=SLXOLEDB.1;Data Source=localhost;Initial Catalog=saleslogix_eval;User ID=admin
Query: select AccountName from Account where Status = ? order by AccountName
Name: Status (this can be anything)
Expression: 'Active' (including quotes)
03-28-2014 02:18 AM
Thanks for the reply, how do I form the parameter injection to the grid or Mashup control. I could not see the intelisense stub that would give me the option to add the parameter.
I was looking to add it in an OnLoad event of the form.
Thanks in advance