Questions tagged [expressionbuilder]
95 questions
17
votes
1 answer
What is the escape character for SSIS Expression Builder?
I need to escape quotation marks in SQL Server Integration Services' Expression Builder. I cannot escape it with double or triple quotes.
M. Travis Volker
- 2,310
- 3
- 20
- 21
9
votes
3 answers
Get value from web.config applicationSettings into ASP.NET markup
I might be completely off track by now, so I will just ask this here so someone can help me.
What I want to do, is to insert a value from my web.config, stored in an applicationSettings area, into my aspx markup. Specifically I want to reade a URL…
Niels Ziegler
- 466
- 2
- 6
- 15
7
votes
4 answers
When are ASP.NET Expression Builders most useful?
I saw an example of using Expression Builders, and creating your own Custom Expression Builder Classes here:
https://web.archive.org/web/20210513211719/http://aspnet.4guysfromrolla.com/articles/022509-1.aspx
However, I fail to see the value in using…
John B
- 20,062
- 35
- 120
- 170
3
votes
3 answers
In Access VBA expression builder, how do I sum a column conditionally?
Let's say I have two fields A and B and one textbox B_input. I would like to set up a query so it sums all entries of column A where B = B_input
Currently I have:
==Sum(IIf([B_input]<>"All",[A],IIf([B_input]<>[B],0,[A])))
I did more testing, it…
Bill Software Engineer
- 7,362
- 23
- 91
- 174
3
votes
1 answer
How to use the Result Set from a Query in the Constraint Editor to conditionally execute SQL Task?
My SQL Script is storing in @gempar = NULL and in @beneficiary = '2018-01-01'.
In need to Execute the next Execute SQL Tasks based on the content of those variables. IF ISNULL(@gempar) = True then we don't run the following task (because then…
Boels Maxence
- 349
- 3
- 16
3
votes
1 answer
Registering a Custom ASP.NET ExpressionBuilder Programmatically
Is it possible to register a custom ExpressionBuilder class programmatically during application startup?
The equivalent web.config declaration is obviously:
qJake
- 16,821
- 17
- 83
- 135
3
votes
2 answers
Issue with form property in expression builder - MS Access 2016
We have a form where one of the fields needs an expression.
When we are building that expression, actual need is to select the column name, but we see that there is a property coming up along with the column name with the same name.
Even if we…
Raj Kumar
- 953
- 1
- 8
- 19
3
votes
1 answer
Dynamic linq expression tree with nested properties
I have a list which I must filter on child properties. The filter operator is dynamic and I'm using a predicate builder in order to combine several filters/lambdas.
For simplicity, let's say that I have two classes like this:
public class…
Pal-B
- 139
- 1
- 7
3
votes
3 answers
ASP.NET ExpressionBuilder syntax - output AppSetting within img tag
I would like to use ASP.NET's ExpressionBuilder syntax to dynamically retrieve domain of static content from an AppSetting.
I am using the following syntax, which does not work:
frankadelic
- 20,543
- 37
- 111
- 164
3
votes
1 answer
Replacing anonymous methods with expression tree
If I want to replace this anonymous method:
Func f = delegate(int i)
{
return i + 1;
};
with an expression tree, it would like this:
ParameterExpression i = Expression.Parameter(typeof(int), "i");
Expression one =…
Martin Mulder
- 12,642
- 3
- 25
- 54
2
votes
1 answer
Data Factory Expression - get a sas token from JSON
I have an output from web activity in Azure Data Factory which generate a JSON containing SAS token for blob storage.
I need to pass this SAS Token as an URL to an other Web Activity after every run, as it will expired after 5 minutes.
output…
Volume069
- 71
- 6
2
votes
1 answer
Replace OrderBy with Where in LINQ query
There is a known issue with CosmosDb where if you use an ORDER BY clause it excludes documents that do not have this property defined
To work round this I'm trying to create functionality that takes a LINQ query and replaces the Order clause with a…
ElGringo
- 369
- 3
- 10
2
votes
3 answers
Use SQL Field in SSIS Variable
Is it possible to reference a SQL field in your SSIS variable?
For instance, I would like use the field from the "table" below
Select '999999' AS Physician_Profile_ID
as a dynamic variable (named "CMSPhysProID" in our example) here
I plan on…
Steven
- 139
- 1
- 11
2
votes
1 answer
Why does this line of localization behave this way?
I'm localizing an ASP.NET web site. Usually to localize text in an .aspx page I just use
<%= Resources.ResourceFile.ResourceName %>
For asp.net controls, this won't work. I have to use the syntax
<%$ Resources:ResourceFile, ResourceName…
Brandon
- 68,708
- 30
- 194
- 223
2
votes
2 answers
Expression builder for deep property comparison
I was looking at a simple rule engine http://netmatze.wordpress.com/2012/01/22/building-a-rule-engine-in-c/ and I'm doing something very similar to this. I have two classes that look like:
class A
{
public List ListB { get; set; }
…
riververy
- 21
- 1